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!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.