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
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;
...
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;
...
Use labels.
data mydata ;
x=10;
label x='This is a really long name for the variable X';
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.