Hello Experts,
I'm looking for a way to name the sheet while the proc export on csv file ?
Thank you !
A CSV file is just a text file. A CSV file does not have "sheet name". When you are writing a CSV file you only need to specify the name of the FILE you want to create.
Hi I think to do this you need to specify the sheet name as follows:
i.e use the Sheet statement
Hope this helps.
proc export data=mydata
outfile='C:\path\to\mydata.csv'
dbms=csv
replace;
sheet='MySheetName';/*Insert the Sheet name here*/
run;
A CSV file is just a text file. A CSV file does not have "sheet name". When you are writing a CSV file you only need to specify the name of the FILE you want to create.
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.