PROC Report

[molla]

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

[Reeza]

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?

[molla]

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.

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.02 seconds
cpu time 0.01 seconds

[Reeza]

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

[Cynthia_sas · Accepted solution]

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

options ls=150;

or

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