So I mocked up some simple data to give an example of what it sounds like you want:
data list free /x1 x2 x3.
begin data.
10 6 9
3 9 9
9 5 8
10 9 9
5 7 10
3 6 1
2 10 2
10 5 3
9 1 5
1 10 6
end data.
compute x=1.
aggregate /outfile=* /break=x /p1 to p3=pgt(x1 to x3 8).
compute avg=mean(p1 to p3).
list.
That should do it. Just substitute your variables for the "x1 to x3". If they aren't contiguous in the file like that, then just list them individually.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------
Original Message:
Sent: Mon October 18, 2021 02:54 PM
From: Jessica McGregor
Subject: Help - Compute a Variable
So I have 3 variables in my file. Each variable has responses that range from 0 - 10. I'd like to calculate the % of respondents that picked a 9 or a 10 for each of the 3 variables - so say V1 = 70%, V2 = 25% and V3 = 76%, and then take the straight average of those %'s - so (70%+25%+76%)/3 = 57%. Hopefully this helps! THANKS so much.
------------------------------
Jessica McGregor
Original Message:
Sent: Mon October 18, 2021 09:56 AM
From: Rick Marcantonio
Subject: Help - Compute a Variable
Hi, Jessica. I'm sorry, I'm not clear on "%9/10" part. I assume that you have seen AGGREGATE's functions such as PIN (percent in), which is coming to mind, but before I recommend anything I need to better understand exactly what you're wanting.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
Original Message:
Sent: Thu October 14, 2021 05:10 PM
From: Jessica McGregor
Subject: Help - Compute a Variable
I am trying to compute a variable using Compute or Aggregate and am not sure the best way to do it. I have three variables and want to take the %9/10 from each of the 3 variables and then take the straight average. Please advise on the best way to do this...
------------------------------
Jessica McGregor
------------------------------
#SPSSStatistics