topic Re: Maximum Record Length for Proc Report and ODS/CSV in ODS and Base Reporting

Maximum Record Length for Proc Report and ODS/CSV

Petersi — Wed, 25 Sep 2013 14:10:35 GMT

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?

Re: Maximum Record Length for Proc Report and ODS/CSV

ballardw — Wed, 25 Sep 2013 14:18:26 GMT

Post how you are creating your CSV file so we can help diagnose the problem.

Re: Maximum Record Length for Proc Report and ODS/CSV

snoopy369 — Wed, 25 Sep 2013 14:19:59 GMT

What are you viewing the report in when you say it is 'wrapping around'?

Re: Maximum Record Length for Proc Report and ODS/CSV

Petersi — Wed, 25 Sep 2013 14:30:37 GMT

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

Re: Maximum Record Length for Proc Report and ODS/CSV

snoopy369 — Wed, 25 Sep 2013 14:31:35 GMT

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?

Re: Maximum Record Length for Proc Report and ODS/CSV

Petersi — Wed, 25 Sep 2013 14:35:14 GMT

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.

Re: Maximum Record Length for Proc Report and ODS/CSV

snoopy369 — Wed, 25 Sep 2013 15:26:45 GMT

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;

Do you?

Re: Maximum Record Length for Proc Report and ODS/CSV

Cynthia_sas — Wed, 25 Sep 2013 16:32:41 GMT

Hi:

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.

cynthia