Recoding
Locked
 
|
I'm trying to recode some variables into new names. They're already numbers on a scale of -3 to 3, as seen below:
RECODE BoyfriendGirlfriendBDView FatherBDView MotherBDView SiblingsBDView ProfessorBDView ClassmatesBDView CloseFriendsBDView SupervisorBossBDView (-3=-3) (-2=-2) (-1=-1) (0=0) (1=1) (2=2) (3=3) INTO SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a. EXECUTE. This is the message I get: RECODE On the RECODE command, all the variables to be recoded must be of the same type. That is, all must be string variables, or all must be numeric variables. Any thoughts? Thanks so much! |
|
I thought this had already been answered. One suggestion was ALTER TYPE, but you can also use *Use CTRL+H to change ( to (" and = to " = . RECODE BoyfriendGirlfriendBDView FatherBDView MotherBDView SiblingsBDView INTO SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a. FORMATS SN1a SN2a SN3a SN4 SN5a SN6a SN7a SN8a (f2.0). If you syntax instead of the GUI you will find it much quicker to type the shorter variable names! John F Hall [Retired academic survey researcher] Website: http://surveyresearch.weebly.com/ SPSS course: http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html Research: http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html |
Administrator
|
In reply to this post by leeshification
The error message could hardly be more obvious!
Check the variable types and make them to be consistent.
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
In reply to this post by leeshification
Have you considered COMPUTE? You are not doing any recoding.
COMPUTE SN1a = BoyfriendGirlfriendBDView . COMPUTE SN2a = FatherBDView. COMPUTE SN3a ... COMPUTE SN8a = SupervisorBossBDView. or maybe like DO REPEAT a = BoyfriendGirlfriendBDView FatherBDView MotherBDView SiblingsBDView ProfessorBDView ClassmatesBDView CloseFriendsBDView SupervisorBossBDView /b = SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a. COMPUTE a = b. END REPEAT. /PR
|
|
|
In reply to this post by David Marso
What puzzles me in why you are using RECODE here. Why not a simple COMPUTE? The only difference here is that if there are other input values than the ones listed, they will be mapped to system missing or blank in the output variables. Or, if this is just a renaming, use RENAME VARIABLES. On Mon, Jun 26, 2017 at 10:53 AM, David Marso <[hidden email]> wrote: The error message could hardly be more obvious! |
|
|
The compute examples from earlier (e.g.
COMPUTE SN1a = BoyfriendGirlfriendBDView .) would have similar data type errors. Alternative: (b and a reversed from earlier example). DO REPEAT a = BoyfriendGirlfriendBDView FatherBDView MotherBDView SiblingsBDView ProfessorBDView ClassmatesBDView CloseFriendsBDView SupervisorBossBDView
/b = SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a. COMPUTE b = Number(a,F2.0). END REPEAT. Would a simple rename and Alter Type (WITH Variable LABELS) be sufficient? Or do the original variables need to be retained? Rename variables (BoyfriendGirlfriendBDView FatherBDView MotherBDView SiblingsBDView ProfessorBDView ClassmatesBDView CloseFriendsBDView SupervisorBossBDView = SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a). ALTER TYPE SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a (F2.0). Melissa From: SPSSX(r) Discussion [mailto:[hidden email]]
On Behalf Of Jon Peck What puzzles me in why you are using RECODE here. Why not a simple COMPUTE? The only difference here is that if there are other input values than the ones listed, they will be mapped to system missing or
blank in the output variables. Or, if this is just a renaming, use RENAME VARIABLES. On Mon, Jun 26, 2017 at 10:53 AM, David Marso <[hidden email]> wrote:
-- Jon K Peck ===================== 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
This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations. ===================== 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 leeshification
For copying values, you can use RENAME var1 (else=copy) INTO newvara.
If you use the RENAME VARIABLES command, you save the other characteristics like MISSING. That seems useful for your example.
The Error message explicitly says that you have included a mixture of string and numeric variables - I don't know if that is the message that SPSS will give if you have incorrectly tried to CONVERT string to numerical values without giving the old values in quotes. If that is what you want to do, use (CONVERT).
-- Rich Ulrich From: SPSSX(r) Discussion <[hidden email]> on behalf of leeshification <[hidden email]>
Sent: Sunday, July 23, 2017 10:24:39 AM To: [hidden email] Subject: Recoding I'm trying to rename some variables that were rated on a scale from -3 to 3.
=====================
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
I want each of the variables to be renamed to SN1a, SN2a, SN3a, etc.... This is what I tried to run: RECODE BoyfriendGirlfriendBDView FatherBDView MotherBDView SiblingsBDView ProfessorBDView ClassmatesBDView CloseFriendsBDView SupervisorBossBDView (-3=-3) (-2=-2) (-1=-1) (0=0) (1=1) (2=2) (3=3) INTO SN1a SN2a SN3a SN4a SN5a SN6a SN7a SN8a. EXECUTE. This was the error I received: 159 RECODE On the RECODE command, all the variables to be recoded must be of the same type. That is, all must be string variables, or all must be numeric variables. Anyone have any ideas? Thanks so much! -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Recoding-tp5734567.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 |
| Free forum by Nabble | Edit this page |