DATA Step, Macro, Functions and more

When exporting how do I map sas headers to longer headers?

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

When exporting how do I map sas headers to longer headers?

Hi,

Too satisfy SAS headers max size i have been forced too shorten down my headers from 50 byte to 32 byte.

Is there a way that i can automatically map my headers from 32 byte to 50 byte with a macro when i export them from sas?

I have a excel document that maps my normal headers too short sas headers.

I essentially want too go back from short headers to normal size headers.

/Br Jacob


Accepted Solutions
Solution
‎07-07-2015 10:41 AM
Super User
Super User
Posts: 7,997

Re: When exporting how do I map sas headers to longer headers?

How do you export?  If you use ods tagsets.excelxp then you can set column headings either in the variables label or in the proc report:

ods tagsets.excelxp file="xyz.xlsx";

proc report data=xyz;

     columns a b;

     define a / "A long variable label";

...

run;

...

View solution in original post


All Replies
Solution
‎07-07-2015 10:41 AM
Super User
Super User
Posts: 7,997

Re: When exporting how do I map sas headers to longer headers?

How do you export?  If you use ods tagsets.excelxp then you can set column headings either in the variables label or in the proc report:

ods tagsets.excelxp file="xyz.xlsx";

proc report data=xyz;

     columns a b;

     define a / "A long variable label";

...

run;

...

Super User
Super User
Posts: 7,079

Re: When exporting how do I map sas headers to longer headers?

Use labels.

data mydata ;

   x=10;

   label x='This is a really long name for the variable X';

run;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 205 views
  • 3 likes
  • 3 in conversation