03-16-2016 08:39 AM
I have a quick question - I can find info on how to use Labels instead of SAS Names when writing to Excel in an ODS statement, but I want it the other way around. I would think that this would be the default. But in my case it's using the Labels.
Here is my code:
ods excel file=outdisp options(sheet_interval="none" columns="&varfrq" sheet_name="Person Freqs");
I want the ODS to use the SAS Names which are listed in the &varfrq macro.
Thanks for any help.
03-16-2016 09:23 AM
Look at the code that actually produces the report. I guess you have an option there that causes labels to be used.
03-16-2016 09:52 AM