BookmarkSubscribeRSS Feed
Defense
Obsidian | Level 7

 

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

4 REPLIES 4
Defense
Obsidian | Level 7

Thanks

ballardw
Super User

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
Tourmaline | Level 20
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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 4259 views
  • 1 like
  • 4 in conversation