Aggregate syntax error
Locked
 
|
Can anyone help me with this error?
We run this code all the time, and now it is not working. The only thing we change is the name of the files to update the YYMM (active1307 for example) Here is the code: AGGREGATE /OUTFILE=* MODE=ADDVARIABLES OVERWRITE=YES /PRESORTED /BREAK=advo_key_b /active1307 = MAX(active1307) /pobox1307 = MAX(pobox1307) /res1307 = MAX(res1307). Here is the error code: >Error # 10934 in column 21. Text: active1307 >The AGGREGATE command specifies an unknown existing variable name. >Execution of this command stops. >Error # 10921 in column 31. Text: ) >The number of existing variables does not match the number of new variables in >a new variable definition on the AGGREGATE command. >Error # 10934 in column 20. Text: pobox1307 >The AGGREGATE command specifies an unknown existing variable name. >Error # 10921 in column 29. Text: ) >The number of existing variables does not match the number of new variables in >a new variable definition on the AGGREGATE command. >Error # 10934 in column 18. Text: res1307 >The AGGREGATE command specifies an unknown existing variable name. >Error # 10921 in column 25. Text: ) >The number of existing variables does not match the number of new variables in >a new variable definition on the AGGREGATE command. I appreciate all of your help. |
Administrator
|
What happens if you insert this line before your AGGREGATE command?
DESCRIPTIVES active1307 pobox1307 res1307. I ask, because the error messages suggest that those 3 variables do not exist in the working data file. Do you have multiple datasets on the go, by any chance? If so, make sure that you have the right one active (see DATASET ACTIVATE) before running your AGGREGATE command. HTH.
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
|
|
In reply to this post by oldiz304
Ok, here is the really niave, obvious question: Are you SURE that the variable name "active1307" exists in the file to be passed through Aggregate?
Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of oldiz304 Sent: Thursday, April 24, 2014 3:20 PM To: [hidden email] Subject: Aggregate syntax error Can anyone help me with this error? We run this code all the time, and now it is not working. The only thing we change is the name of the files to update the YYMM (active1307 for example) Here is the code: AGGREGATE /OUTFILE=* MODE=ADDVARIABLES OVERWRITE=YES /PRESORTED /BREAK=advo_key_b /active1307 = MAX(active1307) /pobox1307 = MAX(pobox1307) /res1307 = MAX(res1307). Here is the error code: >Error # 10934 in column 21. Text: active1307 The AGGREGATE command >specifies an unknown existing variable name. >Execution of this command stops. >Error # 10921 in column 31. Text: ) >The number of existing variables does not match the number of new >variables in >a new variable definition on the AGGREGATE command. >Error # 10934 in column 20. Text: pobox1307 The AGGREGATE command >specifies an unknown existing variable name. >Error # 10921 in column 29. Text: ) >The number of existing variables does not match the number of new >variables in >a new variable definition on the AGGREGATE command. >Error # 10934 in column 18. Text: res1307 The AGGREGATE command >specifies an unknown existing variable name. >Error # 10921 in column 25. Text: ) >The number of existing variables does not match the number of new >variables in >a new variable definition on the AGGREGATE command. I appreciate all of your help. -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Aggregate-syntax-error-tp5725658.html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
In reply to this post by Bruce Weaver
Thank you very much for your assistance. As it turns out, there were a few key variables that needed to be deleted before re-running a slew of statements and this was the first thing that stopped the whole execution. Thanks again. -- Ben Horwitz, MS Operations and Data Manager The Data Center "Independent Analysis for Informed Decisions in Southeast Louisiana" On Thu, Apr 24, 2014 at 3:07 PM, Bruce Weaver [via SPSSX Discussion] <[hidden email]> wrote: What happens if you insert this line before your AGGREGATE command? |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |