I want to take a SAS data set and create an XLS or XLSX file where the first row is not the SAS variable names. In other words, I want row 1 in Excel to be the first row of data in the SAS data set.
I do not want an XML file.
How can I do this?
Here is one way: A Poor/Rich SAS Users Proc Export - sasCommunity
Well that was way too easy! Thanks!
I'll be sure to make it more difficult next time!
Proc Report needs a boost. Here's the PROC REPORT/NOHEADER method.
Cynthia
ods csv file='c:\temp\noheader.csv';
proc report data=sashelp.class nowd noheader;
run;
ods csv close;
proc export data=sashelp.class outfile='c:\temp\class.xls' dbms=xls replace;
putnames=no;
run;
In one short link: SAS/ACCESS(R) 9.2 Interface to PC Files: Reference, Second Edition
Yes. They are different engine. Excel engine can handle both ascii( english character) - single byte stored and DBMS - double byte stored ( like Chinese Korea Japanese) . but XLS only can handle single byte stored character( english ) . since you are from U.S , that doesn't matter if using excel or xls . But for me from China , only can use Excel engine.
Xia Keshan
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.