topic Re: Creating a .csv File in Microsoft Integration with SAS

Creating a .csv File

deleted_user — Wed, 25 Feb 2009 16:17:21 GMT

When I create a .csv file is there any way to have the Label put into the first line instead of the Var Name?

Re: Creating a .csv File

sbb — Wed, 25 Feb 2009 23:32:56 GMT

What SAS code are you using to create the CSV? For example, if you are using ODS CSV and combining that code with PROC PRINT, you can specify the LABEL parameter in PROC PRINT to use the LABEL instead of the variable name. If not using PROC PRINT, please share the SAS code you are using to generate the CSV.

Scott Barry
SBBWorks, Inc.

Re: Creating a .csv File

deleted_user — Tue, 03 Mar 2009 20:39:20 GMT

I'm not using ODS - just a simple Proc Export:

PROC EXPORT DATA= mdata.fnl_adam_mems
OUTFILE="c:mdata\fnl_adam_mems.csv"
DBMS=CSV REPLACE;
RUN;

Re: Creating a .csv File

sbb — Tue, 03 Mar 2009 23:04:59 GMT

After visiting the SAS support website http://support.sas.com/ I did a search using the argument "proc export label column" and one of the search results is the link below:

http://support.sas.com/kb/12/754.html

Scott Barry
SBBWorks, Inc.

Re: Creating a .csv File

deleted_user — Wed, 04 Mar 2009 15:56:40 GMT

Hi Scott,

Thanks so much for your help. None of the Documentation I have included the LABEL parameter - how frustrating that the solution was so simple!

Liz

Re: Creating a .csv File

data_null__ — Wed, 04 Mar 2009 21:04:01 GMT

[pre]
ods csv file='csvWithLabels.csv';
proc print label noobs data=sashelp.shoes(obs=20);
run;
ods csv close;
[/pre]

Re: Creating a .csv File

deleted_user — Fri, 17 Apr 2009 16:24:38 GMT

Apparently I spoke too soon. When I run the following Proc Export code I get an error message stating that the (LABEL) option is not recognized:
PROC EXPORT DATA=contents OUTFILE="S:\Mdata\contents.csv" DBMS=CSV REPLACE LABEL;
RUN;

What am I doing wrong?

Re: Creating a .csv File

deleted_user — Fri, 17 Apr 2009 16:35:24 GMT

I figured it out - we are using SAS 9.1.3 and LABEL will be available in 9.2