05-20-2016 11:39 PM
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?
05-21-2016 02:25 AM
SAS variable names are limited to 32 characters. You need to adapt your Excel headers to this limit.
05-22-2016 01:26 AM
Note that SAS has something called LABELS to provide nicer text for many uses that can be associated with a variable.
Very brief example:
label x ="The number of candy bars";
proc print data=have label;
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.
05-22-2016 08:47 AM