Help using Base SAS procedures

Long variable name

Reply
Contributor
Posts: 22

Long variable name

 

Hi, 

As I import an excel table with very long column head into SAS via SAS import wizard, the variable names (column heads) are truncated in sas dataset.  How can I avoid the truncating?

thanks

Defense

Super User
Posts: 7,760

Re: Long variable name

SAS variable names are limited to 32 characters. You need to adapt your Excel headers to this limit.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 22

Re: Long variable name

Posted in reply to KurtBremser

Thanks

Super User
Posts: 11,343

Re: Long variable name

Note that SAS has something called LABELS to provide nicer text for many uses that can be associated with a variable.

Very brief example:

 

data have;

   x=4;

   label x ="The number of candy bars";

run;

proc print data=have label;

run;

 

Will the text of the label instead of the variable as a column heading.
By default most procedures will use the label (or at least part of it) in output. And Labels can be much longer than a variable name, 256 and can include characters like # ! @$%^&*() and so on.

Super User
Posts: 5,424

Re: Long variable name

By default, SAS will use column headers as SAS labels. But the maximum length is 64 chars due to a limitation in the Jet engine. Of course you could expand the label in a later step, but that would be considered a work around.
http://support.sas.com/documentation/cdl/en/acpcref/67382/HTML/default/viewer.htm#n0msy4hy1so0ren1ac...
Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 363 views
  • 1 like
  • 4 in conversation