Hi all,
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.
SASHunter
Look at the code that actually produces the report. I guess you have an option there that causes labels to be used.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.