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?
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
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.