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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.