can excelXP have BOTH column headings(labels) and variable name?

frisco — Mon, 09 Nov 2009 20:03:12 GMT

I am giving an end user an export on Excel with labels using tagsets.excelxp - I would like to include variable names for ease of troubleshooting - is this possible? I did not see a post on this, forgive me if the question has already been asked.

Re: can excelXP have BOTH column headings(labels) and variable name?

Cynthia_sas — Mon, 09 Nov 2009 21:36:59 GMT

Hi:
I don't believe there's an automatic option to do it, but you could code it yourself using either the "brute force" method shown below or any number of more automated and/or "macro-ized" solutions to build the text string that represents the label.

cynthia

[pre]
ods tagsets.excelxp file='var_labl.xml' style=sasweb;

proc report data=sashelp.class nowd split='#';
column name age sex height weight;
define name / order 'Name#What Name';
define age /display 'Age#How Old';
define height / display 'Height#How Tall';
define sex / display 'Sex#What Gender';
define weight / display 'Weight#How Heavy';
run;

ods tagsets.excelxp close;

[/pre]

topic Re: can excelXP have BOTH column headings(labels) and variable name? in ODS and Base Reporting

can excelXP have BOTH column headings(labels) and variable name?

Re: can excelXP have BOTH column headings(labels) and variable name?