SPSSX Discussion

what does this error information mean?

Classic

List

Threaded

7 messages Options

Wang Xu-4

what does this error information mean?

Dear SPSS Listers,

Today I ran a recoding session to recode all the missing values in the survey data into a default number 9. However, when spss was processing the data, the error information as followed pops up, what does this mean? I have one more question about it, I tried to run 'recode' to recode some variables' missing value number to 9, but another way of reocoding the missing value is to set in the variable window under each variable. What are the differences of two ways of setting missing values? Thanks a lot!

RECODE A1A A1B A1C A1D A1E A1F A1G A1H A2A A2B A2C A2D A2E A2F A2G A2H A3A A3B A3C A3D A3E A3F A3G A3H A4A A4B A4C A4D A4E A4F A4G A
    4H A5A A5B A5C A5D A5E A5F A5G A5H A6A A6B A6C A6D A6E A6F A6G A6H A7A A7B A7C A7D A7E A7F A7G A7H A8A A8B A8C A8D A8E A8F
     A8G A8H A9A A9B A9C A9D A9E A9F A9G A9H A10A A10B A10C A10D A10E A10F A10G A10H A11A A11B A11C A11D A11E A11F A11G A11H A12A A12
    B A12C A12D A12E A12F A12G A12H A13A A13B A13C A13D A13E A13F A13G A13H A14A A14B A14C A14D A14E A14F A14G A14H A15A A15B A1
     A15D A15E A15F A15G A15H A16A A16B A16C A16D A16E A16F A16G A16H A17A A17B A17C A17D A17E A17F A17G A17H A18A A18B A18C A18D A18
    E A18F A18G A18H A19A A19B A19C A19D A19E A19F A19G A19H A20A A20B A20C A20D A20E A20F A20G A20H A21A A21B A21C A21D A21E A2
     A21G A21H A22A A22B A22C A22D A22E A22F A22G A22H A23A A23B A23C A23D A23E A23F A23G A23H A24A A24B A24C A24D A24E A24F A24G A24
    H A25A A25B A25C A25D A25H A25E A25F A25G A26A A26B A26C A26D A26H A26E A26F A26G A27A A27B A27C A27D A27E A27F A27G A27H A2
     A28B A28C A28D A28E A28F A28G A28H A29A A29B A29C A29D A29E A29F A29G A29H A30A A30B A30C A30D A30E A30F A30G A30H A31H A31E A31
    F A31G A31A A31B A31C A31D A32H A32E A32F A32G A32A A32B A32C A32D A33H A33E A33F A33G A33A A33B A33C A33D A34H A34E A34F A3
     A34A A34B A34C A34D (SYSMIS=9).

>Error # 4631 in column 255. Text: A1
>On the RECODE command, the list of variables to be recoded includes the name
>of a nonexistent variable.
>This command not executed.
EXECUTE.

网易为中小企业免费提供企业邮箱（自主域名）

Heidi Green

Re: what does this error information mean?

To answer the nonexistent variable problem: You have a typo between A15B and A15D. Instead of A15C, you have A1.

A15B A1
A15D

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of dachengruoque
Sent: Wednesday, June 16, 2010 9:13 AM
To: [hidden email]
Subject: what does this error information mean?
Importance: High

Dear SPSS Listers,

>Error # 4631 in column 255. Text: A1
>On the RECODE command, the list of variables to be recoded includes the name
>of a nonexistent variable.
>This command not executed.
EXECUTE.

网易为中小企业免费提供企业邮箱（自主域名）

____________
DefenderMX2.

Bruce Weaver

Re: what does this error information mean?

Administrator

Also, there is bound to be a much tidier way to do this that does not require you to list each variable individually. E.g., if the variables are contiguous, you could use the TO keyword.

RECODE A1A TO A34D (SYSMIS=9).
exe.

If there are groups of variables that are contiguous, but with some other variables stuck in between the groups, you can use multiple TO's. E.g.,

RECODE
A1A TO A9H
A10A TO A34D (SYSMIS=9).
exe.

And if these variables represent ALL of the variables in the file, you can shorten it even more:

RECODE ALL (SYSMIS=9).
exe.

Heidi Green wrote

To answer the nonexistent variable problem: You have a typo between A15B and A15D. Instead of A15C, you have A1.

A15B A1
A15D

________________________________

From: SPSSX(r) Discussion [mailto:SPSSX-L@listserv.uga.edu] On Behalf Of dachengruoque
Sent: Wednesday, June 16, 2010 9:13 AM
To: SPSSX-L@listserv.uga.edu
Subject: what does this error information mean?
Importance: High

Dear SPSS Listers,

Today I ran a recoding session to recode all the missing values in the survey data into a default number 9. However, when spss was processing the data, the error information as followed pops up, what does this mean? I have one more question about it, I tried to run 'recode' to recode some variables' missing value number to 9, but another way of reocoding the missing value is to set in the variable window under each variable. What are the differences of two ways of setting missing values? Thanks a lot!

RECODE A1A A1B A1C A1D A1E A1F A1G A1H A2A A2B A2C A2D A2E A2F A2G A2H A3A A3B A3C A3D A3E A3F A3G A3H A4A A4B A4C A4D A4E A4F A4G A
4H A5A A5B A5C A5D A5E A5F A5G A5H A6A A6B A6C A6D A6E A6F A6G A6H A7A A7B A7C A7D A7E A7F A7G A7H A8A A8B A8C A8D A8E A8F
A8G A8H A9A A9B A9C A9D A9E A9F A9G A9H A10A A10B A10C A10D A10E A10F A10G A10H A11A A11B A11C A11D A11E A11F A11G A11H A12A A12
B A12C A12D A12E A12F A12G A12H A13A A13B A13C A13D A13E A13F A13G A13H A14A A14B A14C A14D A14E A14F A14G A14H A15A A15B A1
A15D A15E A15F A15G A15H A16A A16B A16C A16D A16E A16F A16G A16H A17A A17B A17C A17D A17E A17F A17G A17H A18A A18B A18C A18D A18
E A18F A18G A18H A19A A19B A19C A19D A19E A19F A19G A19H A20A A20B A20C A20D A20E A20F A20G A20H A21A A21B A21C A21D A21E A2
A21G A21H A22A A22B A22C A22D A22E A22F A22G A22H A23A A23B A23C A23D A23E A23F A23G A23H A24A A24B A24C A24D A24E A24F A24G A24
H A25A A25B A25C A25D A25H A25E A25F A25G A26A A26B A26C A26D A26H A26E A26F A26G A27A A27B A27C A27D A27E A27F A27G A27H A2
A28B A28C A28D A28E A28F A28G A28H A29A A29B A29C A29D A29E A29F A29G A29H A30A A30B A30C A30D A30E A30F A30G A30H A31H A31E A31
F A31G A31A A31B A31C A31D A32H A32E A32F A32G A32A A32B A32C A32D A33H A33E A33F A33G A33A A33B A33C A33D A34H A34E A34F A3
A34A A34B A34C A34D (SYSMIS=9).

>Error # 4631 in column 255. Text: A1
>On the RECODE command, the list of variables to be recoded includes the name
>of a nonexistent variable.
>This command not executed.
EXECUTE.

________________________________

网易为中小企业免费提供企业邮箱（自主域名） <http://ym.163.com/?from=od3>

____________
DefenderMX2.

--
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/).

Wang Xu-4

Re: what does this error information mean?

In reply to this post by Heidi Green

Thanks a lot Heidi Green, but in the variable view, I located the variable between A15B and A15D is just A15C not A1, what does that mean? I am baffled!

在2010-06-17 00:19:46，"Heidi Green" <[hidden email]> 写道：

To answer the nonexistent variable problem: You have a typo between A15B and A15D. Instead of A15C, you have A1.

A15B A1
     A15D

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of dachengruoque
Sent: Wednesday, June 16, 2010 9:13 AM
To: [hidden email]
Subject: what does this error information mean?
Importance: High

Dear SPSS Listers,

Today I ran a recoding session to recode all the missing values in the survey data into a default number 9. However, when spss was processing the data, the error information as followed pops up, what does this mean? I have one more question about it, I tried to run 'recode' to recode some variables' missing value number to 9, but another way of reocoding the missing value is to set in the variable window under each variable. What are the differences of two ways of setting missing values? Thanks a lot!

RECODE A1A A1B A1C A1D A1E A1F A1G A1H A2A A2B A2C A2D A2E A2F A2G A2H A3A A3B A3C A3D A3E A3F A3G A3H A4A A4B A4C A4D A4E A4F A4G A
    4H A5A A5B A5C A5D A5E A5F A5G A5H A6A A6B A6C A6D A6E A6F A6G A6H A7A A7B A7C A7D A7E A7F A7G A7H A8A A8B A8C A8D A8E A8F
     A8G A8H A9A A9B A9C A9D A9E A9F A9G A9H A10A A10B A10C A10D A10E A10F A10G A10H A11A A11B A11C A11D A11E A11F A11G A11H A12A A12
    B A12C A12D A12E A12F A12G A12H A13A A13B A13C A13D A13E A13F A13G A13H A14A A14B A14C A14D A14E A14F A14G A14H A15A A15B A1
     A15D A15E A15F A15G A15H A16A A16B A16C A16D A16E A16F A16G A16H A17A A17B A17C A17D A17E A17F A17G A17H A18A A18B A18C A18D A18
    E A18F A18G A18H A19A A19B A19C A19D A19E A19F A19G A19H A20A A20B A20C A20D A20E A20F A20G A20H A21A A21B A21C A21D A21E A2
     A21G A21H A22A A22B A22C A22D A22E A22F A22G A22H A23A A23B A23C A23D A23E A23F A23G A23H A24A A24B A24C A24D A24E A24F A24G A24
    H A25A A25B A25C A25D A25H A25E A25F A25G A26A A26B A26C A26D A26H A26E A26F A26G A27A A27B A27C A27D A27E A27F A27G A27H A2
     A28B A28C A28D A28E A28F A28G A28H A29A A29B A29C A29D A29E A29F A29G A29H A30A A30B A30C A30D A30E A30F A30G A30H A31H A31E A31
    F A31G A31A A31B A31C A31D A32H A32E A32F A32G A32A A32B A32C A32D A33H A33E A33F A33G A33A A33B A33C A33D A34H A34E A34F A3
     A34A A34B A34C A34D (SYSMIS=9).

>Error # 4631 in column 255. Text: A1
>On the RECODE command, the list of variables to be recoded includes the name
>of a nonexistent variable.
>This command not executed.
EXECUTE.

网易为中小企业免费提供企业邮箱（自主域名）

____________
DefenderMX2.

网易为中小企业免费提供企业邮箱（自主域名）

Wang Xu-4

Re: what does this error information mean?

Thanks a lot, Heidi Green for your prompt reply and hlep! I am very grateful of your help on this. I sort of iorn out the problem. But first, I am a green hand at handling data with spss. Instead of typing and running syntax with spss, I chose Transform-----Recode into the same variables then choose the variables and missing values and new values (999).It seems that spss has difficulty understanding variable names, since I name it something like A15 C. So I ran the command by inputting only ten variables each time instead of squeezing them all into the recode window. Then every problem is gone. Every missing value is recoded into 999.

在2010-06-17 09:13:13，"Heidi Green" <[hidden email]> 写道：

The mistake is in the recode syntax that you are running, not in your data file. Did you paste the syntax from the windows drop down? If so, perhaps it pasted wrong. There are a few other variables that look like they might have typos too. I would check each variable in the list you pasted below against what is in your data file. Or, as another responder mentioned, use the “TO” command. I may have time to help more tomorrow if you need it…

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of dachengruoque
Sent: Wednesday, June 16, 2010 5:15 PM
To: [hidden email]
Subject: Re: what does this error information mean?
Importance: High

Thanks a lot Heidi Green, but in the variable view, I located the variable between A15B and A15D is just A15C not A1, what does that mean? I am baffled!

在2010-06-17 00:19:46，"Heidi Green" <[hidden email]> 写道：

To answer the nonexistent variable problem: You have a typo between A15B and A15D. Instead of A15C, you have A1.

A15B A1
     A15D

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of dachengruoque
Sent: Wednesday, June 16, 2010 9:13 AM
To: [hidden email]
Subject: what does this error information mean?
Importance: High

Dear SPSS Listers,

Today I ran a recoding session to recode all the missing values in the survey data into a default number 9. However, when spss was processing the data, the error information as followed pops up, what does this mean? I have one more question about it, I tried to run 'recode' to recode some variables' missing value number to 9, but another way of reocoding the missing value is to set in the variable window under each variable. What are the differences of two ways of setting missing values? Thanks a lot!

RECODE A1A A1B A1C A1D A1E A1F A1G A1H A2A A2B A2C A2D A2E A2F A2G A2H A3A A3B A3C A3D A3E A3F A3G A3H A4A A4B A4C A4D A4E A4F A4G A
    4H A5A A5B A5C A5D A5E A5F A5G A5H A6A A6B A6C A6D A6E A6F A6G A6H A7A A7B A7C A7D A7E A7F A7G A7H A8A A8B A8C A8D A8E A8F
     A8G A8H A9A A9B A9C A9D A9E A9F A9G A9H A10A A10B A10C A10D A10E A10F A10G A10H A11A A11B A11C A11D A11E A11F A11G A11H A12A A12
    B A12C A12D A12E A12F A12G A12H A13A A13B A13C A13D A13E A13F A13G A13H A14A A14B A14C A14D A14E A14F A14G A14H A15A A15B A1
     A15D A15E A15F A15G A15H A16A A16B A16C A16D A16E A16F A16G A16H A17A A17B A17C A17D A17E A17F A17G A17H A18A A18B A18C A18D A18
    E A18F A18G A18H A19A A19B A19C A19D A19E A19F A19G A19H A20A A20B A20C A20D A20E A20F A20G A20H A21A A21B A21C A21D A21E A2
     A21G A21H A22A A22B A22C A22D A22E A22F A22G A22H A23A A23B A23C A23D A23E A23F A23G A23H A24A A24B A24C A24D A24E A24F A24G A24
    H A25A A25B A25C A25D A25H A25E A25F A25G A26A A26B A26C A26D A26H A26E A26F A26G A27A A27B A27C A27D A27E A27F A27G A27H A2
     A28B A28C A28D A28E A28F A28G A28H A29A A29B A29C A29D A29E A29F A29G A29H A30A A30B A30C A30D A30E A30F A30G A30H A31H A31E A31
    F A31G A31A A31B A31C A31D A32H A32E A32F A32G A32A A32B A32C A32D A33H A33E A33F A33G A33A A33B A33C A33D A34H A34E A34F A3
     A34A A34B A34C A34D (SYSMIS=9).

>Error # 4631 in column 255. Text: A1
>On the RECODE command, the list of variables to be recoded includes the name
>of a nonexistent variable.
>This command not executed.
EXECUTE.

网易为中小企业免费提供企业邮箱（自主域名）

____________
DefenderMX2.

网易为中小企业免费提供企业邮箱（自主域名）

____________
DefenderMX2.

网易为中小企业免费提供企业邮箱（自主域名）

Khaing Soe-2

what does this error information mean?

In reply to this post by Bruce Weaver

Dear Listers,

To perform computing task - summation of variables var 1a + var1b to var 10a + var 10b followed by dividing the result with 4.

The follwing code was used and not worked.

COMPUTE consumptionfood = ((HE1C+HE1D) TO (HE10C+HE10D))*4.
VARIABLE LABELS consumptionfood 'Monthly Consumption Expenditure for Food'.

COMPUTE consumptionnf =( (HE11B+HE11C) TO (HE15B +HE15C)) + ( ( ( HE16B+HE16C) TO (HE21B + HE21C) ) / 12).
VARIABLE LABELS consumptionnf 'Monthly Consumption Expenditure for Non Food'.

COMPUTE consumptiontotal= consumptionfood + consumptionnf.
VARIABLE LABELS consumptiontotal ' Monthly Consumption Expenditure'.
EXECUTE .

The error mesage says TO key word is not appropriate other than SUM and MEAN.What should be used instead? or where am I wrong? Please advise.

Thanks,

Khaing Soe

Ruben Geert van den Berg

Re: what does this error information mean?

Dear Khaing,

If I understand you correctly, you want to add up

1) var1a

2) var1b to var 10a/*-> var1b, var10a and all variables that are located between them

3) var10b

and divide this by 4.

Please try

COMPUTE consumptionfood = (sum(HE1C,HE1D TO HE10C,HE10D))/*4.

execute.

HTH,

Ruben van den Berg
Consultant Models & Methods
TNS NIPO
Email: [hidden email]
Mobiel: +31 6 24641435
Telefoon: +31 20 522 5738
Internet: www.tns-nipo.com

Date: Wed, 16 Jun 2010 21:36:12 -0700
From: [hidden email]
Subject: what does this error information mean?
To: [hidden email]

Dear Listers,

To perform computing task - summation of variables var 1a + var1b to var 10a + var 10b followed by dividing the result with 4.

The follwing code was used and not worked.

COMPUTE consumptionfood = ((HE1C+HE1D) TO (HE10C+HE10D))*4.
VARIABLE LABELS consumptionfood 'Monthly Consumption Expenditure for Food'.

COMPUTE consumptionnf =( (HE11B+HE11C) TO (HE15B +HE15C)) + ( ( ( HE16B+HE16C) TO (HE21B + HE21C) ) / 12).
VARIABLE LABELS consumptionnf 'Monthly Consumption Expenditure for Non Food'.

COMPUTE consumptiontotal= consumptionfood + consumptionnf.
VARIABLE LABELS consumptiontotal ' Monthly Consumption Expenditure'.
EXECUTE .

The error mesage says TO key word is not appropriate other than SUM and MEAN.What should be used instead? or where am I wrong? Please advise.

Thanks,

Khaing Soe

Express yourself instantly with MSN Messenger! MSN Messenger