topic Re: proc export csv sheet name in SAS Programming

proc export csv sheet name

SASdevAnneMarie — Wed, 21 Feb 2024 10:25:44 GMT

Hello Experts,

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

Thank you !

Re: proc export csv sheet name

himself — Wed, 21 Feb 2024 10:58:36 GMT

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;

Re: proc export csv sheet name

JosvanderVelden — Wed, 21 Feb 2024 11:23:39 GMT

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#p18zl68aqzqpl8n1vg3w6bugxcul. 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-EXCEL/td-p/357108

Re: proc export csv sheet name

Tom — Wed, 21 Feb 2024 14:08:55 GMT

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.

Re: proc export csv sheet name

SASdevAnneMarie — Wed, 21 Feb 2024 17:10:13 GMT

Thank you Tom!