CSV file creation assistance needed

HarfordKaren — Fri, 26 Apr 2013 13:21:05 GMT

I am relatively new to SAS programming. The state has modified how they want their data files. They used to want .dat files and now have changed to .csv files with 2 header records (second one has the column headings). What is the best way to do this in a SAS program?

Re: CSV file creation assistance needed

jwsquillace — Fri, 26 Apr 2013 13:52:49 GMT

Here is SAS code that demonstrates how to use a DATA step to generate a CSV file with two lines for heading

data _NULL_;

set sashelp.class; /* replace with your data set name */

file 'c:\temp\test.csv' dlm=',';

if _N_ = 1 then do;

put 'first line heading'; /* replace with your heading */

put 'name,age,sex,height,weight'; /* replace with your variables */

end;

put name age sex height weight; /* replace with your variables */

run;

If you have more then 256 characters per output line, you need an LRECL parameter on the FILE statement.

I invite you to send email to support.sas.com if you have further questions.

Jan

topic CSV file creation assistance needed in SAS Programming

CSV file creation assistance needed

Re: CSV file creation assistance needed