09-25-2013 10:10 AM
Hi - I am creating a CSV file with Proc Report. There are over 200 columns and no matter what LRECL I specify the report keeps wrapping around. Can you tell me if there is a setting on maximum record lenght within the procdure itself?
09-25-2013 10:30 AM
Hi - I am using ODS CSV to output on mainframe. Even before I download the file to view in Excel I can browse it to see that the title row has wrapped around
09-25-2013 10:31 AM
Browse it in what? Is there an actual linefeed, or is it just your viewer is wrapping it? If it is in excel, is it still wrapping there?
09-25-2013 10:35 AM
On Z/OS I can browse the file and I can see that it has wrapped. When I download the file and open it in Excel it wraps as well. When I shorten the list of columns it does not wrap. That is why I am wondering if there is a record lenght parameter with PROC Report, or maybe a restriction with CSV files.
09-25-2013 11:26 AM
I don't have any wrapping when I run the following, which generates almost 600 columns:
ods csv file="c:\temp\test.csv"; PROC REPORT data=sashelp.prdsale nowd; columns actual predict country,region,division,prodtype,year,month,(actual predict); define actual/analysis sum; define predict/analysis sum; define country/across; define region/across; define division/across; define prodtype/across; define year/across; define month/across; run; ods csv close;
09-25-2013 12:32 PM
When you create your CSV file on the mainframe, you may need to explicitly use an LRECL in the DCB of the JCL procedure or use the LRECL option on the FILENAME statement. I would recommend that you work with SAS Tech Support on this question. You might (but I'm not sure about this) need to specify RS=NONE -- usually you use this option with HTML, to prevent unwanted line breaks, but you might need it with CSV destination too. That would be another question for Tech Support.