12-18-2014 02:46 PM
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?
12-18-2014 04:35 PM
Proc Report needs a boost. Here's the PROC REPORT/NOHEADER method.
ods csv file='c:\temp\noheader.csv';
proc report data=sashelp.class nowd noheader;
ods csv close;
12-19-2014 08:32 AM
12-19-2014 08:57 AM
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.
Need further help from the community? Please ask a new question.