I don't know why it is adding quotes. It does not do that when I try it in normal SAS 9.4M5 release.
The unneeded quotes were added by the LABEL option.
As to the variables it is just outputting the variables in your dataset. If you want different variables then change the dataset before creating the CSV file from it.
filename csv temp;
proc export data=sashelp.class(obs=3) file=csv dbms=csv;
delimiter=',';
run;
357 data _null_;
358 infile csv;
359 input ;
360 list;
361 run;
NOTE: The infile CSV is:
Filename=xxxx,
RECFM=V,LRECL=32767,File Size (bytes)=92,
Last Modified=13May2019:19:39:29,
Create Time=13May2019:19:39:29
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
1 Name,Sex,Age,Height,Weight 26
2 Alfred,M,14,69,112.5 20
3 Alice,F,13,56.5,84 18
4 Barbara,F,13,65.3,98 20
NOTE: 4 records were read from the infile CSV.
The minimum record length was 18.
The maximum record length was 26.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
But if you generate the CSV file yourself then you can use the labels as the column headers without getting unneeded quotes.
proc transpose data=sashelp.class(obs=0) out=names ;
var _all_;
label name='Name Label';
run;
data _null_;
file csv dsd ;
length _name_ $32 _label_ $256;
set names end=eof;
_label_=coalescec(_label_,_name_);
put _label_ @;
if eof then put;
run;
data _null_;
file csv dsd mod ;
set sashelp.class(obs=3);
put (_all_) (+0);
run;
617 data _null_;
618 infile csv;
619 input ;
620 put _infile_;
621 run;
NOTE: The infile CSV is:
Filename=XXX,
RECFM=V,LRECL=32767,File Size (bytes)=98,
Last Modified=13May2019:19:50:38,
Create Time=13May2019:19:45:44
Name Label,Sex,Age,Height,Weight
Alfred,M,14,69,112.5
Alice,F,13,56.5,84
Barbara,F,13,65.3,98
NOTE: 4 records were read from the infile CSV.
The minimum record length was 18.
The maximum record length was 32.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Click image to register for webinar
