How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
Locked
How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
 
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
Administrator
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
Administrator
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
Administrator
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
Administrator
|
This post was updated on .
David, given your track record in this forum, my first thought upon seeing
that !D1 was, "Where's the macro definition?"  David Marso wrote > It is definitely a good thing to post the EXACT code you run and any error > messages. > This works. I corrected the mistyped !D1 which should have been ID1. > Good catch Bruce. > -- > DATA LIST LIST / ID1 ID2 ID3 (3A2). > BEGIN DATA > C 1 2 (for example, this has to turn into C12 in a new column) > er 11 7 (this has to become er117) > I 16 1 > B 8 2 > T 19 9 > V 20 8 > M 1 5 > G 9 7 > N 17 6 > H 16 3 > END DATA. > ALTER TYPE ID1 ID2 ID3 (A2). > STRING UniqueID (A8). > COMPUTE UniqueID =CONCAT(ID1,ID2,ID3). > LIST. > > ID1 ID2 ID3 UniqueID > > C 1 2 C12 > er 11 7 er117 > I 16 1 I161 > B 8 2 B82 > T 19 9 T199 > V 20 8 V208 > M 1 5 M15 > G 9 7 G97 > N 17 6 N176 > H 16 3 H163 > > > Number of cases read: 10 Number of cases listed: 10 > > > stargirl1992 wrote >> The code is not working for me. Do you know why? There are some errors... >> "Variable STRING specified for ALTER TYPE command line does not exist in >> the >> working data file" but there are variables named ID1, ID2, and ID3. >> And for the next 2 command lines, the error is: On the STRING command, >> the >> list of variables being defined was not followed by the formats for those >> variables. Execution of this command stops." >> >> I'm very confused. Maybe I should also mention that before I inputted >> this >> code, I had already manually changed the ID1, ID2, and ID3 into string >> variables in the Variable View. >> >> The only thing that seems to work is if I just write the syntax: STRING >> UniqueID (A8) ... then it makes a new empty variable for me. But when I >> do >> the COMPUTE command, it says the variable has already been defined. >> >> >> >> -- >> Sent from: http://spssx-discussion.1045642.n5.nabble.com/ >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to > >> LISTSERV@.UGA > >> (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 > > > > > > ----- > 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?" > -- > Sent from: http://spssx-discussion.1045642.n5.nabble.com/ > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- -- Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (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
--
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/). |
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
Administrator
|
Re: How do I combine 3 variables (which consist of both letters and numbers) into 1 variable?
|
Administrator
|
| Free forum by Nabble | Edit this page |