Help using Base SAS procedures

PROC Report

Accepted Solution Solved
Reply
Contributor
Posts: 63
Accepted Solution

PROC Report

[ Edited ]

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


Accepted Solutions
Solution
‎04-23-2017 03:12 PM
SAS Super FREQ
Posts: 8,739

Re: PROC Report

[ Edited ]

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


All Replies
Super User
Posts: 17,730

Re: PROC Report

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?

Contributor
Posts: 63

Re: PROC Report

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

 

Super User
Posts: 17,730

Re: PROC Report

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

Solution
‎04-23-2017 03:12 PM
SAS Super FREQ
Posts: 8,739

Re: PROC Report

[ Edited ]

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

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