Usage Note 16842: Writing SAS Variable Labels that Contain Dots to Excel Field/Column
Names
SAS variable labels that contain a dot do not get written to
Excel as field names, using the Libname/Excel engine statement
and the DBLABEL dataset option. The following error will
be returned:
ERROR: Bind parameters: Invalid column name: xxx.xxx
In SAS, replace the dots with the pound sign (#).
The names will be written to Excel and the # will be
converted to dot.
data test;
set sashelp.class;
label name='o#d'
sex=gender
age='how#old';
run;
libname foo 'c:\My Documents\Test.xls';
data foo.new(dblabel=yes);
set work.test;
run;
libname foo clear;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 | |
Microsoft Windows XP Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
*
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: | low |
Date Modified: | 2008-03-04 14:50:07 |
Date Created: | 2006-01-12 10:58:48 |