topic Re: Creating XLS file with no SAS variable name in Row 1 in SAS Programming

Creating XLS file with no SAS variable name in Row 1

PaigeMiller — Thu, 18 Dec 2014 19:46:33 GMT

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?

Re: Creating XLS file with no SAS variable name in Row 1

art297 — Thu, 18 Dec 2014 20:00:00 GMT

Here is one way: A Poor/Rich SAS Users Proc Export - sasCommunity

Re: Creating XLS file with no SAS variable name in Row 1

PaigeMiller — Thu, 18 Dec 2014 20:09:54 GMT

Well that was way too easy! Thanks!

Re: Creating XLS file with no SAS variable name in Row 1

art297 — Thu, 18 Dec 2014 20:22:01 GMT

I'll be sure to make it more difficult next time!

Re: Creating XLS file with no SAS variable name in Row 1

Cynthia_sas — Thu, 18 Dec 2014 21:35:33 GMT

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;

Re: Creating XLS file with no SAS variable name in Row 1

Ksharp — Fri, 19 Dec 2014 13:24:05 GMT

proc export data=sashelp.class outfile='c:\temp\class.xls' dbms=xls replace;

putnames=no;

run;

Re: Creating XLS file with no SAS variable name in Row 1

PaigeMiller — Fri, 19 Dec 2014 13:32:01 GMT

Okay , that's a great answer.

When I tried this before posting the original question, I used dbms=excel, and I got an error. Obviously, dbms=xls works.

Can anyone explain the difference?

Re: Creating XLS file with no SAS variable name in Row 1

art297 — Fri, 19 Dec 2014 13:48:19 GMT

In one short link: SAS/ACCESS(R) 9.2 Interface to PC Files: Reference, Second Edition

Re: Creating XLS file with no SAS variable name in Row 1

Ksharp — Fri, 19 Dec 2014 13:57:01 GMT

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