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
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;
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;
Perfect. SAS community is the Best friend for those working as solo SAS performer in the team.
I love this community
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.