Proc export to CSV

[singhsahab]

Hi All,

I've a dataset called test which have three varibales ID, Q1 and Q2. While exporting dataset into CSV format with the label name label names not appers in output file,only varibale original name appers in output . i'm using below code 

proc export data=readin outfile="\\path\read.csv"
dbms=csv Replace;
LABEL Q1="QUA 1" Q2="QUA 2";
run;

Thank you to all in advance !!!

[ChrisNZ]

proc export does not support the label statement.

[ChrisBrooks]

Actually it does support the label statement but there are two things wrong wrong with your code:

1. It only supports variable labels on the data set - you can't change them during the Proc Expand; and

2. You've put your label statement in the wrong place - it goes BEFORE the first semi-colon e.g.

proc export data=sashelp.cars outfile="/folders/myshortcuts/Dropbox/cars.csv" label ;
dbms=csv;
run;

[ChrisNZ]

The label statement must be used in a prior step before the proc export as it is not supported. Then the label option can be used to export the labels instead of the names.

[ChrisBrooks]

You're right @ChrisNZ it is actually an option in Proc Export and not a statement - i admit I sometimes tend to use the terms interchangeably 🙂

[ChrisNZ]

I have a bit of OCD with terminology.
Not that it prevents me from making mistakes. 🙂