topic missing underscore in Sas variable names in SAS Enterprise Guide

missing underscore in Sas variable names

steve_citi — Thu, 10 Jun 2010 19:43:24 GMT

I am running the following macro in SAS EG.

The SAS dataset created does NOT have underscores between column names containing 2 or more words. For example, Branch Number does NOT become Branch_Number, but stays Branch Number.

%macro import_xls(data=,sheet=,xls=);

proc import dbms=excelcs out=&data
datafile="&xls"
replace;
server="&machineid..nam.nsroot.net"; /* Name of PC files server */
port=8621; /* Port number listening on the PC server */
version='2002'; /* Excel file version */
sheet="&sheet"; /* Sheet name */
scantext=yes; /* Scan all rows data for the largest size */
usedate=yes; /* Use DATE format for date/time columns */
scantime=yes; /* Scan and identify time columns */
dbsaslabel=none; /* Leave SAS label names to be nulls */
textsize=512; /* Largest text size allowed */
run;

%mend import_xls;

Re: missing underscore in Sas variable names

twocanbazza — Thu, 10 Jun 2010 21:56:45 GMT

Have a look at the option "validvarname".

Re: missing underscore in Sas variable names

RichardH_sas — Mon, 14 Jun 2010 13:52:24 GMT

In certain cases, EG will allow non-default column names to be created. As the other poster suggests, you might try submitting the following code, then calling your macro program:

OPTIONS VALIDVARNAME=V7;

The default setting in EG is VALIDVARNAME=ANY.

There's a note about GETNAMES=YES changing things over to SAS names... might be worth a test as well.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#/documentation/cdl/en/proc/61895/HTML/default/a000312413.htm

Tech support could also be a good resource on this: http://support.sas.com/techsup/contact/