Providing software solutions since 1976
The maximum value for the GUESSINGROWS= statement for PROC IMPORT when reading a comma, tab, or delimited file is 2147483647. An alternative to the numeric value is specifying GUESSINGROWS=MAX. The maximum value for ...
To learn why some of your values are truncated when you use PROC IMPORT, the Import Wizard, or EFI(External File Interface) to read in a comma, tab or delimited file, click here for SAS Note 1075.
41933 - ADLM seen in MPRINT output of SASŪ log when PROC IMPORT or PROC EXPORT is inside a macro- Usage Note
The line ADLM; will be seen in the MPRINT output of the SAS log when PROC IMPORT or PROC EXPORT reading or writing a comma, tab or delimited file is inside a macro and the macro is executed. Here is an example of ...
41925 - How to read an encoded comma, tab, or delimited file using PROC IMPORT- Usage Note
To read an encoded external file using PROC IMPORT, the external file will need to be allocated using the FILENAME statement. On the FILENAME statement the ENCODING="xxx" where "xxx" is the type of encoded file and ...
3610 - "ERROR: Cannot open X display" when running PROC EXPORT or PROC IMPORT in batch mode- Usage Note
If you run PROC EXPORT or PROC IMPORT steps in batch mode in UNIX environments, you will receive the following error: ERROR: Cannot open X display. Check the name/server access authorization. The process might ...
1075 - How to scan more than 20 records to determine variable attributes in EFI- Usage Note
In Versions 7 and 8 of the SAS System, by default the Import Wizard, PROC IMPORT and the External File Interface (EFI) scan 20 records to determine variable attributes when reading delimited text files. Changing the ...
When using PROC IMPORT or the Import Wizard to read in an external file, values enclosed in quotation marks are automatically created as character variables. Even if the value is numeric like "12345" and is enclosed in ...
15676 - Improved DATE,TIME, and DATETIME sampling in EFI, PROC IMPORT, and Import Wizard in SAS 9.2- Usage Note
Beginning in SAS 9.2, the Base SAS EFI, PROC IMPORT, and Import Wizard sampling algorithm used to determine if a value is a DATE, TIME, or DATETIME has been changed. The value is read in using both a TIME and DATETIME ...
46944 - New SAS transport format and tools available- Usage Note
Variable names longer than eight characters and other unsupported data set features in the XPORT engine are supported. This availability does not change the expectation that the FDA should receive clinical trial data ...
43831 - An error occurs when importing XML files if the name of the root element is Chinese- Usage Note
An import table error occurs when importing XML files if the root element consists of Chinese characters.
