topic Re: Proc Export to excel with just one row and no column names in SAS Programming

Proc Export to excel with just one row and no column names

Stalk — Tue, 12 Jul 2022 15:01:18 GMT

I am using Proc export to write to three sheets in an single workbook.

In the first sheet( cell A1) I just have to write text "Product ver: 3.1" with out any titles or columns so the SQL data base can read my excel books with all the 3 pages. Is there a simple way to do this?

When I export all the three sheet are populating with data except the first sheet where it is writing as follows.. How can I avoid the column name "txt" and only product version.

txt

Product Ver: 3.1

Thank you

Re: Proc Export to excel with just one row and no column names

Tom — Tue, 12 Jul 2022 15:13:26 GMT

Show what code you used to "export" to an excel file.

PROC EXPORT should be able to do that.

data have;
  txt='Product Ver: 3.1';
run;
proc export data=have file='c:\downloads\no_header.xlsx' replace dbms=xlsx;
  putnames=NO;
run;

Re: Proc Export to excel with just one row and no column names

Stalk — Tue, 12 Jul 2022 15:24:05 GMT

Perfect. SAS community is the Best friend for those working as solo SAS performer in the team.

I love this community

Re: Proc Export to excel with just one row and no column names

Stalk — Wed, 03 Aug 2022 16:52:44 GMT

Actually, what is the equivalent to putnames=NO when using ODS excel?
proc export is truncating some of the character data so decided to use ods excel.

ODS excel options(sheet_name='Version' );

Proc print data=ver noobs;
run;

Re: Proc Export to excel with just one row and no column names

Stalk — Wed, 03 Aug 2022 18:19:41 GMT

Worked..
Proc report data=ver noheaders;
run;