I have the following code to create an ods listing with a semi-colon delimiter. When I do this, it does not include the column names from my table "test"
How do I include the column names?
options nodate nonumber;
ods _all_ close;
ods listing;
data _null_;
file print dsd dlm=';' ;
set library.test;
put (_all_) (:);
run;
Create a put statement that executes on the first row of data:
If _n_ = 1 then put "var1;var2;var3;";
before the other PUT statement.
or you may want to use Proc Export for this unless you specifically need the Listing output.
Create a put statement that executes on the first row of data:
If _n_ = 1 then put "var1;var2;var3;";
before the other PUT statement.
or you may want to use Proc Export for this unless you specifically need the Listing output.
How about using ODS ?
ods csvall file='c:\temp\x.csv' options(doc="help" Delimiter=';' );
title ' ';
proc print data=sashelp.class noobs;run;
ods csvall close;
Xia Keshan
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.