Usage Note 34254: How to allow a numeric value enclosed in quotation marks to be read in as numeric variable with PROC IMPORT or the IMPORT WIZARD
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 quotation marks, the value will be created as a character variable instead of a numeric variable. To prevent a numeric value enclosed in quotation marks from being read in as character when using either PROC IMPORT or the Import Wizard, you can submit the following %LET prior to PROC IMPORT or the Import Wizard:
%let EFI_QUOTED_NUMERICS = yes;
By submitting the above %LET prior to PROC IMPORT or the Import Wizard, the numeric value enclosed in quotation marks will be read as a numeric variable.
Operating System and Release Information
SAS System | Base SAS | Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
Linux for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M0 |
Linux | 9.2 TS1M0 | 9.2 TS2M0 |
64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M0 |
HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M0 |
64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M0 |
Windows Vista | 9.2 TS1M0 | 9.2 TS2M0 |
64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | high |
Topic: | SAS Reference ==> Procedures ==> IMPORT Common Programming Tasks ==> Reading and Writing External Data ==> with PROC IMPORT
|
Date Modified: | 2008-12-18 10:52:00 |
Date Created: | 2008-12-17 14:55:12 |