BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
molla
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ

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

View solution in original post

4 REPLIES 4
Reeza
Super User

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
Fluorite | Level 6

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
Super User

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

Cynthia_sas
SAS Super FREQ

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 10791 views
  • 0 likes
  • 3 in conversation