Specifies the data file for a single group.
Syntax
result = pd.SetDataFile (groupNumber, dbFormat, fileName, tableName, groupingVariable, groupingValue)
The SetDataFile method syntax has the following parts:
Part |
Description |
result |
0 if successful. |
groupNumber |
Group number of the group for which the data file information is specified. The first group is group number 1. |
dbFormat |
(Integer) A database format specifier, as described in Settings. |
fileName |
(String) The name of the data file. |
tableName |
(String) The name of the data table within the data file (for data files that contain multiple data tables). |
groupingVariable |
(String) The name of the grouping variable. The empty string if there is no grouping variable. AT PRESENT, THIS ARGUMENT IS IGNORED. (Grouping variables are not currently implemented for the SetDataFile method.) |
groupingValue |
(Object) The value of the grouping variable for this group. At present, groupingValue is ignored. |
Settings
The settings for dbFormat are:
Constant |
Value |
Description |
mmDBASE3 |
0 |
Dbase III |
mmDBASE4 |
1 |
Dbase IV |
mmDBASE5 |
2 |
Dbase V |
mmEXCEL3 |
3 |
Excel 3 |
mmEXCEL4 |
4 |
Excel 4 |
mmEXCEL5 |
5 |
Excel 5, Excel 7 |
mmEXCEL97 |
6 |
Excel 97, Excel 8 |
mmFOXPRO20 |
7 |
Foxpro 2.0 |
mmFOXPRO25 |
8 |
Foxpro 2.5 |
mmFOXPRO26 |
9 |
Foxpro 2.6 |
mmLOTUSWK1 |
11 |
Lotus *.wk1 |
mmLOTUSWK3 |
12 |
Lotus *.wk3 |
mmLOTUSWK4 |
13 |
Lotus *.wk4 |
mmAccess |
14 |
Microsoft Access |
mmSPSS |
18 |
SPSS Statistics |
mmText |
19 |
Text |
See example.