Long variable name

[Defense]

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

[Kurt_Bremser]

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

[Defense]

Thanks

[ballardw]

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.

[LinusH]

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...