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

[jacobkr]

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

[RW9 · Accepted solution]

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;

...

[Tom]

Use labels.

data mydata ;

   x=10;

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

run;