Usage Note 13735: How to import ranges of data in Excel and retain column names
The rangeimporter9.sas program can import ranges of Excel data that
do not include the first row or column and retain the column
names. PROC IMPORT by default does not have this capability.
The program requires the range and the name of the Excel file
in order to run. The SAS/ACCESS for PC File formats product
is required in order to run this macro.
The rangeimporter9.sas program can be found at this link:
ftp://ftp.sas.com/techsup/download/base/
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows NT Workstation | 9.1 TS1M2 | |
| Microsoft Windows 2000 Server | 9.1 TS1M2 | |
| Microsoft Windows XP Professional | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M2 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M2 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M2 | |
*
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.
| Date Modified: | 2005-01-28 09:37:17 |
| Date Created: | 2004-11-02 15:42:31 |
