topic Re: Add header to export in SAS Programming

Add header to export

PROCDATARUN — Wed, 01 Dec 2021 06:36:28 GMT

PROCDATARUN — Wed, 01 Dec 2021 06:38:25 GMT

How do I add the header row to the following export code.

data _null_;
set WORK.Output ;
file '/sasd/cs/sasd/John/WORK.Output.csv' dsd ;
put (_all_) (+0);
run;

andreas_lds — Wed, 01 Dec 2021 06:58:59 GMT

Insert the following code between FILE and PUT:

if _n_ = 1 then do;
  put "This is a header row";
end;

ballardw — Wed, 01 Dec 2021 16:22:02 GMT

And just in case:

if _n_ = 1 then do; put "This is a header row"; put "and this is a second header row"; put "example of third header row"; /* repeat as needed */ end;

Ksharp — Thu, 02 Dec 2021 12:51:16 GMT

Why not :

proc export data=...... outfile=....... LABEL;
.............