I'm using below Proc export code to export CSV excel file into path and able to create second dataset(recs&i), But i am not able to create multiple sheets(header, recs&i) in same excel
I've tried to use statement SHEET option in both procs, but getting error.
/*create files on local server*/
PROC EXPORT DATA= header
LABEL
OUTFILE= "&full_path_outfile."
DBMS=CSV REPLACE;
RUN;
PROC EXPORT DATA= recs&i.
LABEL
OUTFILE= "&full_path_outfile."
DBMS=CSV REPLACE; DELIMITER=';';
RUN;
As i am creating CSV file with ; delimiter, and able to open CSV file directly into excel, Could you please suggest the way to create multiple sheets in same csv excel file?
CSV file format does not have the concept of "Sheets". It is a flat text format file. Excel has the concept of "Sheet". If you want to view the data in separate sheets in Excel then you need to change your export target to be Excel not CSV. However I recommend if you are exporting to Excel to use the newer ExceXP tagset to output your data as you have far more control and options: Base SAS: Demo: ExcelXP Tagset and Microsoft Excel
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 25. 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.