That's how the aggregate function works. You break on specific variables and create others.
------------------------------
Art Jack
------------------------------
Original Message:
Sent: Mon March 13, 2023 10:34 AM
From: Renee Damstra
Subject: Aggregate function error string variable
I am sorry, do you mean I have to use your command/formula instead? Would this then add a new variable since you have seemed to remove this part?
------------------------------
Renee Damstra
Original Message:
Sent: Mon March 13, 2023 08:34 AM
From: Art Jack
Subject: Aggregate function error string variable
aggregate outfile=* /break subjid /responded_sum=sum(responded)
------------------------------
Art Jack
Original Message:
Sent: Mon March 13, 2023 05:53 AM
From: Renee Damstra
Subject: Aggregate function error string variable
This is my syntax:
AGGREGATE
/OUTFILE=*MODE=ADDVARIABLES
/BREAK=subjID
/Responded_sum=SUM(Responded)
I get the error that this has been used with a string variable not a numeric (see printscreen)
However, this variable is set as 'scale' and when I check with Data - define variable properties it also says numeric. So what is the problem?
------------------------------
Renee Damstra
------------------------------