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 ;
Adding AveResponse to the columns statement should fix the issue.
Adding AveResponse to the columns statement should fix the issue.
Great! I just overlooked that.... Thanks!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.