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

[Stalk]

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

[Tom · Accepted solution]

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;

[Stalk]

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

I love this community

[Stalk]

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;

[Stalk]

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