topic Proc export to CSV in SAS Programming

Proc export to CSV

singhsahab — Wed, 20 Sep 2017 04:54:37 GMT

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 !!!

Re: Proc export to CSV

ChrisNZ — Wed, 20 Sep 2017 05:22:28 GMT

proc export does not support the label statement.

Re: Proc export to CSV

ChrisBrooks — Wed, 20 Sep 2017 07:50:10 GMT

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;

Re: Proc export to CSV

ChrisNZ — Wed, 20 Sep 2017 08:35:37 GMT

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.

Re: Proc export to CSV

ChrisBrooks — Wed, 20 Sep 2017 08:53:11 GMT

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 🙂

Re: Proc export to CSV

ChrisNZ — Wed, 20 Sep 2017 09:02:28 GMT

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