Greetings ODS Tagset Gurus. I am working on a customised CSV tagset that has the following changes: Does not put out the usual header row with column names. Does not put quotes around text values. This I have done successfully. The problem remains is that the CSV file created contains a blank line at both the top and the bottom. I started with the custom tagset from here: http://support.sas.com/documentation/cdl/en/odsug/62755/HTML/default/viewer.htm#n1ln06jm8i5ttnn1qg5mz4xj4koi.htm and tweaked it like this: proc template; define notes 'This is the MDR CSV template'; /* define event table; start: put 'Start'; finish: put 'End'; end; */ define event put_value; put VALUE; end ; define event put_value_cr; put VALUE NL; end ; define event row; finish: put NL ; end ; /* define event header; start: put ',' /if ^cmp( COLSTART, '1'); put ''''; put VALUE; finish: put ''''; end; */ define event data; start: put ',' /if ^cmp( COLSTART, '1' ); /* put ''''; */ put VALUE; /* finish: put ''''; */ end ; define event colspanfill; put ',' ; end ; define event rowspanfill; put ',' /if ^exists( VALUE); end ; define event breakline; put NL; end ; define event splitline; put NL; end ; registered_tm = '(r)' ; trademark = '(tm)' ; copyright = '(c)' ; output_type = 'csv' ; stacked_columns = OFF; end ; run ; I then tested the tagset like this: ods Tagsets.csv_mdr file = "test.csv" ; proc print data = sashelp.class noobs; run; ods Tagsets.csv_mdr close; ods listing; I am running SAS 9.1.3 SP4 under Windows. I suspect a tweak of the row event is required because if you comment this out all data ends up on the same line. Would appreciate some help in what this tweak should be! tagset Tagsets.csv_mdr;
... View more