Previous Page | | | Next Page |
File Format-Specific Reference for the IMPORT and EXPORT Procedures |
CSV Files |
Tab-Delimited File |
Other Delimiters |
External File Interface (EFI) |
Using the SAS Import and Export Wizards and The IMPORT Procedure |
IMPORT and EXPORT Procedure Statements for Delimited Files |
Delimited File Type | Statement Options | PROC Import | PROC Export | Valid Value | Default Value |
---|---|---|---|---|---|
CSV and TAB | DATAROW | Yes | No | 1 to 2147483647 | 2 |
GETNAMES | Yes | No | Yes | No | Yes | |
GUESSINGROWS | Yes | No | 1 to 2147483647 | 20 | |
PUTNAMES | No | Yes | Yes|No | Yes | |
DLM | DATAROW | Yes | No | 1 to 2147483647 | 2 |
DELIMITER | Yes | Yes | 'char' | 'nn'x | ' ' | |
GETNAMES | Yes | No | Yes|No | Yes | |
GUESSINGROWS | Yes | No | 1 to 2147483647 | 20 | |
PUTNAMES | No | Yes | Yes | No | Yes |
2 |
1 to 2147483647 |
If GETNAMES=Yes, then DATAROW=numberge 2. |
If GETNAMES=No, then DATAROW=1. |
A blank character. |
Support only for DLM and CSV typefiles. |
A blank character is used as the defaultdelimiter. |
Specify the delimiter as a single characteror as a hexadecimal value. If columns of data are separated by an ampersand,specify DELIMITER='&'. |
YES | specifies that the IMPORT procedure generate SASvariable names from the data values in the first row of the imported Excelfile. |
NO | specifies that the IMPORT procedure generate SASvariable names as F1, F2, F3, and so on. |
Yes |
Valid only for Windows. |
Valid only for the IMPORT procedure. |
Supported only when DBMS=EXCEL.Due to a Microsoft Jet engine limitation, no more than 64 characters of columnnames are written to SAS variable labels. |
20 |
Number of rows: 1 to 2147483647 |
The default row number can be changed inthe SAS REGISTRY as follows: From the SAS menu SolutionsAccessoriesRegistry Editor. Whenthe Registry Editor opens, select ProductsBASEEFIGuessingRows. This opens the EditSigned Integer Valuewhere you can modify the Value Data item. |
specifies that the EXPORT procedure is todo the following tasks:
|
specifies that the EXPORT procedure is towrite the first row of SAS data set values to the first row of the exporteddata file. |
Yes |
If you specify the LABEL= option, the SASvariable labels (not the variable names) are written as column headings. |
Previous Page | | | Next Page | | | Top of Page |