Computed Variable "Not in the Report Definition" in Proc Report

ManitobaMoose — Wed, 17 Jan 2018 03:08:54 GMT

Hi,

For some reason my computed variable AveResponse is not showing up in my output. The log also shows a warning message stating that "AveResponse Not in the Report Definition". Q1-Q5 are quizzes with a score that ranges from 1 to 5. I am looking to display the average response for each ID of the 5 quizzes.

Everything looks ok as far as I can see. Anyone else have any ideas? Thanks.

-----------------------------

Libname Learn '/folders/myfolders/Learn' ;

Title "Report on the Survey Data Set" ;
Title2 ;
Title3 ;

proc report data=learn.survey nowd headline ls=80 ;
   columns Subj Gender Age Income Q1-Q5 ;
   define Subj      / display "ID" width=5 ;
   define Gender    / display width=5 ;
   define Age       / display width=5 ;
   define Income    / display "Salary" width=5 format=dollar10. ;
   define Q1        / display noprint ;
   define Q2        / display noprint ;
   define Q3        / display noprint ;
   define Q4        / display noprint ;
   define Q5        / display noprint ;
   Compute AveResponse ;
       AveResponse = mean of(Q1-Q5) ;
   EndComp ;
   define AveResponse / computed "Average Response" width=8 format=3.1 ;
run ;

Re: Computed Variable "Not in the Report Definition" in Proc Report

andreas_lds — Wed, 17 Jan 2018 07:27:35 GMT

Adding AveResponse to the columns statement should fix the issue.

Re: Computed Variable "Not in the Report Definition" in Proc Report

ManitobaMoose — Wed, 17 Jan 2018 16:00:35 GMT

Great! I just overlooked that.... Thanks!

topic Computed Variable "Not in the Report Definition" in Proc Report in SAS Programming

Computed Variable "Not in the Report Definition" in Proc Report

Re: Computed Variable "Not in the Report Definition" in Proc Report

Re: Computed Variable "Not in the Report Definition" in Proc Report