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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.