topic Re: When exporting how do I map sas headers to longer headers? in SAS Programming

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

jacobkr — Tue, 07 Jul 2015 14:23:40 GMT

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 — Tue, 07 Jul 2015 14:41:26 GMT

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 — Tue, 07 Jul 2015 14:46:22 GMT

Use labels.

data mydata ;

x=10;

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

run;