proc export needs

[deleted_user]

proc export needs a nonames option/statement to allow user to suppress printing of SAS dataset column names on an output file.

For example:

proc export data=mysasdata
outfile="c:\mydata.csv"
dbms=csv
replace
;
run;

Presently, there is no option or statement that will allow the user to suppress printing of the SAS data set column names as the first record of the output file.

[deleted_user]

> proc export needs a nonames option/statement to allow
> user to suppress printing of SAS dataset column names
> on an output file.
>
> For example:
>
> proc export data=mysasdata
> outfile="c:\mydata.csv"
> dbms=csv
> replace
> ;
> run;
>
> Presently, there is no option or statement that will
> allow the user to suppress printing of the SAS data
> set column names as the first record of the output
> file.

for a short (5-line) work around (while you wait and hope ? )

data _null_ ;
file "output file path&name -quoted" dsd lrecl= 30000 ;
set your.dataset ;
put ( _all_ )( : ) ;
run ;

it seems short enough not to need wrappng in a macro !

Good Luck

PeterC

[Chiefsfan4ever]

Just to add to Peter's comments, you would want a dsd statement to make it comma delimited


Data _null_;
file &outfile. DSD DLM = ',';
Set your.dataset;
put (_all_)(:);
run;