topic Re: proc print truncated in SAS Procedures

proc print truncated

GeorgeSAS — Tue, 28 Jun 2016 18:03:24 GMT

Hello,

How to split proc print a very long row into different lines to avoid of being truncated?

Here is the example SAS code: x2 and x3 are too long and were truncated,I want to print them into several lines without being truncated.

Thanks!

data n;

x='11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111';

x2=x||x;

x3=x2||x2;

run;

option ls=max;

proc print data=n;

run;

WARNING: Data too long for column "x2"; truncated to 252 characters to fit.

WARNING: Data too long for column "x3"; truncated to 252 characters to fit.

Re: proc print truncated

Astounding — Tue, 28 Jun 2016 18:52:16 GMT

Not with PROC PRINT. You would have to switch to PROC REPORT and use the WRAP option.

Re: proc print truncated

PGStats — Wed, 29 Jun 2016 02:41:11 GMT

You have some control with SQL printing:


proc sql flow=30 40;
select * from n;
quit;

Re: proc print truncated

Cynthia_sas — Wed, 29 Jun 2016 02:50:56 GMT

Hi:
WRAP only works with LISTING output. So if you want to control cellwidth and impact text flow, then use a STYLE attribute and the WIDTH= style attribute.
cynthia