Hello all,
I know this has been covered here in the past but the solutions offered are not working for me so I will broach the topic again. ()
I'm trying to export label names to an excel file and I can't get the names to export, I keep getting the variable name. It's quite frustrating. Here is the code:
proc export data = Ser_ref
outfile='C:\Documents and Settings\Desktop\sf.xls'
label dbms=excel replace;
sheet='2014';
run;
I appreciate any help, thanks in advance!
Hi:
If the posted solutions are not working, then it's best to work with Tech Support. They can collect all the information they need, like your version of SAS, bitness (32/64) of SAS and Office, whether you have SAS/Access for PC Files installed and try to replicate that the posted code doesn't work.
cynthia
"bitness"? learn a new word every day...
As an alternative, why not use:
ods tagsets.execlxp file="....xls" options=(sheet_name="...");
proc report data=...
run;
ods tagset close;
You can specify labels, filter, zoom and lots of other nice items.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.