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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.