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

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 ;

1 ACCEPTED SOLUTION

Accepted Solutions
andreas_lds
Jade | Level 19

Adding AveResponse to the columns statement should fix the issue.

View solution in original post

2 REPLIES 2
andreas_lds
Jade | Level 19

Adding AveResponse to the columns statement should fix the issue.

ManitobaMoose
Quartz | Level 8

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

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 4022 views
  • 4 likes
  • 2 in conversation