Error 4285

Problem(Abstract) When executing an IF command using Statistics Syntax, execution stops with the following error message: Error# 4285 in column spss error incorrect variable name . Text: Incorrect variable name: either the name is spss error 4381 more than 64 characters, or it is not defined by a previous command. Execution of this command stops. how to compute variables in spss Symptom Syntax being executed appears as: IF (MySourceVariable=MyValue1) MyTargetVariable=1. IF (MySourceVariable=MyValue2) MyTargetVariable=2. EXECUTE. Cause Error is displayed because the end-user failed to encapsulate the string text within apostrophes ( ' ) or double-quoation ( " ) marks. Because the values that the IF command is looking up is not surrounded by quotes or apostrophes, SPSS Statistics thinks that it is supposed to be looking up a variable name. Environment This issue is not depended on a specific platform Diagnosing the problem Review IF command and compare it to the example found in the Command Syntax Reference Guide > IF: IF with String Values IF (SEX EQ 'F') EEO=QUOTA+GAIN. * The logical expression tests the string variable SEX for the value F. * When the expression is true (when SEX equals F), the value of the numeric variable EEO is assigned the value of QUOTA plus GAIN. Both QUOTA and GAIN must be previously defined numeric variables. * When the expression is false or missing (for example, if SEX equals F), the value of EEO remains unchanged. If EEO has not been previously defined, it contains the system-missing value. Resolving the problem Surround the value of a string variable in apostrophe's or double-quote marks to successfully execute this command. The correct syntax would be: IF (MySourceVariable='MyValue1') MyTargetVariable=1. IF (MySourceVariable='MyValue2') MyTargetVariable=2. EXECUTE. Document information More support for: SPSS Statistics Statistics Desktop Software version: Not Applicable Operating system(s): Platform Independent Reference #: 1967706 Modified date: 2015-09-29 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility

von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://stackoverflow.com/questions/10727759/generating-mean-values-to-empty-cells more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up generating mean values to empty cells up vote 1 down vote spss error favorite I am new to SPSS and I am trying to generate average values to empty cells (basicly fill in missing info by the average answer the user has given) and I can not get my example code to work (or understand the example well). Please could someone help me? COMPUTE QOL_puutt = Nmiss(ass, bass, grass, gas). This part I understand Do repeat A = ass1 ass2 ass3. spss error incorrect If ((Missing (A)) & QOL_puutt <= 4) A = RND(Mean (ass1, ass2, ass3)). End repeat. Here something goes wrong. I understood that ass1,ass2,ass3 would refer to cells (column ass row 3)??? Here are the error codes Error # 4285 in column 15. Text: ass1 Incorrect variable name: either the name is more than 64 characters, or it is not defined by a previous command. Execution of this command stops. Error # 4285 in column 15. Text: ass2 Incorrect variable name: either the name is more than 64 characters, or it is not defined by a previous command. Execution of this command stops. Error # 4285 in column 15. Text: ass3 Incorrect variable name: either the name is more than 64 characters, or it is not defined by a previous command. Execution of this command stops spss share|improve this question asked May 23 '12 at 21:00 user1054844 1861518 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Its a little hard to tell what the code is due to the wrapping, but you can simplify it like this do repeatA = ass1 ass2 ass3. if missing(A) A = mean(ass, bass, grass, gas). end repeat. If all the values are missing