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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: