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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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: