DATA Step, Macro, Functions and more

csv file with column names

Accepted Solution Solved
Reply
Super Contributor
Posts: 268
Accepted Solution

csv file with column names

I need to amend this data step so that the column names are written to output file in row 1.

 

filename csv "G:\Departments\Research\MAP\&yr1&yr2.\Fall &yr.\clean_for_enrich.csv";

data _null_;
set join1b ;
file csv dlm=',';
put ( _all_ ) (+0);
run;


Accepted Solutions
Solution
‎10-14-2016 01:15 PM
Super User
Posts: 10,500

Re: csv file with column names

Easiest may be

Proc export data=join1b outfile=csv dbms=csv;

        

run;

View solution in original post


All Replies
Solution
‎10-14-2016 01:15 PM
Super User
Posts: 10,500

Re: csv file with column names

Easiest may be

Proc export data=join1b outfile=csv dbms=csv;

        

run;

Super Contributor
Posts: 268

Re: csv file with column names

Agreed. I was making it  too complicated.

Super User
Posts: 10,500

Re: csv file with column names

If you need to provide a specific order, such for a file that may be read by another program that requires a fixed order then the PUT statement would be appropriate but since you didn't show that then I though export would work.

 

The easy semi-kludge for the header row is to include something like this BEFORE the Put statement in the order to match the variables on the put statement:

 

If _n_ = 1 then put '"column 1 text","column 2 text", ...,"column n text"';

note that is '  "   and "  ' at the start and end. If there are no spaces or commas desired in the Column x text then the " could be omitted.

 

The line basically says: If this is the first line of the file then put the header row. 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 372 views
  • 0 likes
  • 2 in conversation