topic Re: CSV file output in SAS Data Management

CSV file output

Nehcour0420 — Fri, 24 Aug 2012 14:02:45 GMT

Hi,

I am trying to output a sas dataset into a CSV file using labels as the heades.

In the 9.1 version, if I use:

proc export data=...

outfile=...

dbms=scv replace;

I couldn't use labels as header.(I know there is a label option of proc export in 9.2 but unfortunately I am using 9.1 )

However, if I choose to use:

ods csv file=...

proc print ... label;

run;

ods csv close;

The out put quotes all data (char and numerical) which I really don't want.

Is there any way that I can output a csv file with labels as headline and no quotes in the output using version 9.1rc_?

Thanks,

Eric

Tom — Fri, 24 Aug 2012 14:12:10 GMT

Data _null_ already posted code for that to this thread.

Nehcour0420 — Fri, 24 Aug 2012 15:01:26 GMT

Thanks Tom, however my problem is actually have labels but no double quotation marks in my output using either proc export or ods csv + proc print.

Tom — Fri, 24 Aug 2012 15:06:44 GMT

Why would you want the double quotes unless there is a delimiter that needs quoting?

Do you have some system that has a specialized format that it requires?

Nehcour0420 — Fri, 24 Aug 2012 16:29:32 GMT

I DO NOT want the double quotes but when I use ods csv to output, SAS generate all double quotes in the output file automatically.