proc export csv sheet name

[SASdevAnneMarie]

 Hello Experts,

I'm looking for a way to name the sheet while the proc export on csv file ?

Thank you !

[himself]

Spoiler

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;

[JosvanderVelden]

The sheet statement is only valid when using excel-specific dbms (ex. dbms=xlsx). For more information read the documentation https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/n0msy4hy1so0ren1acm90iijxn8j.htm#p18z.... If you want to preserve formats also read: https://communities.sas.com/t5/SAS-Procedures/How-to-retain-the-Variable-Format-when-PROC-EXPORT-TO-...

[Tom · Accepted solution]

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.

[SASdevAnneMarie]

Thank you Tom!