topic Re: PROC Report in SAS Procedures

PROC Report

molla — Sat, 22 Apr 2017 18:13:31 GMT

Hii I am trying to use proc report for displaying report,am a beginner to use proc report,pls help ,e regarding the error which I got..

options nodate pageno=1 ps=60 ls=72;
proc report data=final_test nowd;
title "Summary of Adverse Events Related to Investigational Product";
columns systemorganclasspreferredterm active placebo;
define systemorganclasspreferredterm / display ;
define active / display ;
define placebo / display ;
run;

error:

ERROR: The width of active is not between 1 and 72. Adjust the column
width or line size.
NOTE: This affects LISTING output.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 22 observations read from the data set WORK.FINAL_TEST.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: PROC Report

Reeza — Sat, 22 Apr 2017 18:13:04 GMT

Post your full log.

Usually the width error does not cause PROC REPORT to error out and not complete, so I suspect you have another error. Or do you only have ODS LISTING turned on? Is ODS HTML also on?

Re: PROC Report

molla — Sat, 22 Apr 2017 18:33:19 GMT

7702 options nodate pageno=1 ps=60 ls=72;

7703 proc report data=final_test nowd;
7704 title "Summary of Adverse Events Related to Investigational
7704! Product";
7705 columns systemorganclasspreferredterm active placebo;
7706 define systemorganclasspreferredterm / display ;
7707 define active / display ;
7708 define placebo / display ;
7709 run;

ERROR: The width of active is not between 1 and 72. Adjust the column
width or line size.
NOTE: This affects LISTING output.

Re: PROC Report

Reeza — Sat, 22 Apr 2017 18:34:19 GMT

What's the length/format of the variable ACTIVE?

Re: PROC Report

Cynthia_sas — Sat, 22 Apr 2017 21:22:20 GMT

You caused the problem with LS=72 in the OPTIONS statement. One thing you can do is increase the LS= option.

options ls=150;

options ls=256;

Or, you can simply turn the LISTING destination OFF:
ODS LISTING CLOSE;

before your PROC REPORT and/or make sure that ODS HTML is turned on.

ODS HTML;

The error message also tells you the fix . Look at the first ERROR under line 7709, where it says

"ERROR: The width of active is not between 1 and 72. Adjust the column width or line size."

cynthia