Blank Lines

[SPhill]

Anyone know how to eliminate the top two blank rows that ODS CSV creates?

Thanks

Scott(SAS8.2 TSO JCL MVS)

My code below:-

ods CSV body=CSV
style=minimal
rs=none;
*;
proc print;
run;
ods CSV close;

 

[burndengreen]

try the following link to the SAS institute web site it seems to deal with your problem

http://support.sas.com/faq/035/FAQ03565.html

Cheers

 

[SPhill]

Thanks for this, I'll give it a go.


Scott

 

[ChrisW75]

Yep, it's all down to the NL statements. I recommend looking up information about creating your own tagsets as well, as the default CSV one is a little iffy I think. I ended up creating my own template to produce CSV files from ODS. It basically puts " marks around every single field so that when it gets read into Excel it's treated as text and not reformated. (the only downside is that the numbers are treated astext too so you can't add them up in Excel then).