topic Re: Using PUT to output simple csv with variables in ODS and Base Reporting

Using PUT to output simple csv with variables

deleted_user — Tue, 09 May 2006 18:22:03 GMT

data outdata.ivrs (keep = protocol site screen dob lbdt hgb tsat ferr gfr_cb gfr);
set outdata.indata;
file 'c:\Local\kimj\Studies\Luitpold\test.csv' dlm=',';
put protocol site screen dob lbdt hgb tsat ferr gfr_cb gfr;
run;

------------------------------------
Hello,

I'm creating a simple csv file using FILE and PUT in the above code.
I'm trying to insert the variable names in the first row automatically - what would be the easiest way to do so?

Thank you for your help.

James

Re: Using PUT to output simple csv with variables

garybald — Tue, 09 May 2006 18:29:21 GMT

Try putting these lines in between your file and put lines

if _n_ = 1 then do;
put 'protocol' 'site' etc.;
end;

Re: Using PUT to output simple csv with variables

deleted_user — Tue, 09 May 2006 18:40:09 GMT

Thank you!!!

That was a neat trick - I was looking for all over the documentations for some special options!

James

Re: Using PUT to output simple csv with variables

Cynthia_sas — Wed, 10 May 2006 17:00:25 GMT

Also, since this is the ODS forum 😉 ODS CSV will do it automatically without any PUT statements at all and it will work with other procedures, not just PROC PRINT and if you want titles or bylines, then you can use ODS CSVALL instead.
cynthia
[pre]
ODS CSV file='c:\temp\wombat.csv';
proc print data=sashelp.class;
run;
ODS CSV CLOSE;
[/pre]