DATA Step, Macro, Functions and more

Proc export to CSV

Reply
Occasional Contributor
Posts: 10

Proc export to CSV

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

PROC Star
Posts: 1,760

Re: Proc export to CSV

Posted in reply to singhsahab

proc export does not support the label statement.

 

Super Contributor
Posts: 440

Re: Proc export to CSV

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;
PROC Star
Posts: 1,760

Re: Proc export to CSV

Posted in reply to singhsahab
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.
Super Contributor
Posts: 440

Re: Proc export to CSV

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 :-)

PROC Star
Posts: 1,760

Re: Proc export to CSV

Posted in reply to singhsahab
I have a bit of OCD with terminology.
Not that it prevents me from making mistakes. Smiley Happy
Ask a Question
Discussion stats
  • 5 replies
  • 245 views
  • 5 likes
  • 3 in conversation