08-24-2012 10:02 AM
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=...
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;
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_?
08-24-2012 11:06 AM
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?
08-24-2012 12:29 PM
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.
The problem could be simplified to:
how can I output a csv file with labels using proc export in 9.1.