Joining Variables

[Keith Howey]

Hi everyone,
I have a dataset with 4 variables, but I want to join 3 variables into 1 variable, using the 4th variable as an ID.

So I’d like to turn this:

Building          Code1 Code2 Code3
Alpha            10A      20T     31Y
Bravo            13B      22U
Charlie          17D                37P

Into this:

Building          Code
Alpha            10A
Alpha            20T
Alpha            31Y
Bravo            13B
Bravo            22U
Charlie          17D
Charlie          37P



After I do this, I plan to match this table with another table to mark unacceptable codes.

Is this possible without creating additional tables and merging/adding variables? Any suggestions?

Thanks.



Keith Howey
Evaluation Associate
Quality Assurance and Compliance
Common Ground
Ph:[phone] x9383
mailto:[hidden email]
http://www.commonground.org

=====================
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

[Jim Marks]

VARSTOCASES
   /MAKE code FROM code1 to code3.

Data > restructure in the GUI


Jim Marks
Sr Market Research Manager
National Market Research
Kaiser Foundation Health Plan of the Mid-Atlantic States, Inc.
2101 E. Jefferson St.
Rockville, MD 20852
Phone: [phone]
Cell Phone: [phone]

NOTICE TO RECIPIENT:  If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents.  If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them.  Thank you.




From:        Keith Howey <[hidden email]>
To:        [hidden email]
Date:        06/21/2012 12:42 PM
Subject:        Joining Variables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi everyone,
I have a dataset with 4 variables, but I want to join 3 variables into 1 variable, using the 4th variable as an ID.

So I’d like to turn this:

Building          Code1 Code2 Code3
Alpha            10A      20T     31Y
Bravo            13B      22U
Charlie          17D                37P

Into this:

Building          Code
Alpha            10A
Alpha            20T
Alpha            31Y
Bravo            13B
Bravo            22U
Charlie          17D
Charlie          37P



After I do this, I plan to match this table with another table to mark unacceptable codes.

Is this possible without creating additional tables and merging/adding variables? Any suggestions?

Thanks.



Keith Howey
Evaluation Associate
Quality Assurance and Compliance
Common Ground
Ph:[phone] x9383
mailto:khowey@...
http://www.commonground.org

=====================
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

[Keith Howey]

Thanks Jim.
________________________________________
From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Jim Marks [[hidden email]]
Sent: Thursday, June 21, 2012 1:15 PM
To: [hidden email]
Subject: Re: Joining Variables

VARSTOCASES
   /MAKE code FROM code1 to code3.

Data > restructure in the GUI


Jim Marks
Sr Market Research Manager
National Market Research
Kaiser Foundation Health Plan of the Mid-Atlantic States, Inc.
2101 E. Jefferson St.
Rockville, MD 20852
Phone: [phone]
Cell Phone: [phone]

NOTICE TO RECIPIENT:  If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents.  If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them.  Thank you.




From:        Keith Howey <[hidden email]>
To:        [hidden email]
Date:        06/21/2012 12:42 PM
Subject:        Joining Variables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>
________________________________



Hi everyone,
I have a dataset with 4 variables, but I want to join 3 variables into 1 variable, using the 4th variable as an ID.

So I’d like to turn this:

Building          Code1 Code2 Code3
Alpha            10A      20T     31Y
Bravo            13B      22U
Charlie          17D                37P

Into this:

Building          Code
Alpha            10A
Alpha            20T
Alpha            31Y
Bravo            13B
Bravo            22U
Charlie          17D
Charlie          37P



After I do this, I plan to match this table with another table to mark unacceptable codes.

Is this possible without creating additional tables and merging/adding variables? Any suggestions?

Thanks.



Keith Howey
Evaluation Associate
Quality Assurance and Compliance
Common Ground
Ph:[phone] x9383
mailto:[hidden email]
http://www.commonground.org<http://www.commonground.org/>

=====================
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