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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: