SPSSX Discussion

matching files with same and different cases

Classic

List

Threaded

3 messages Options

J McClure

matching files with same and different cases

Hi,
I have a primary dataset with 150 vaariable. I have a second dataset
with only 3 variables (VetGoal_1 VetGoal_2, and VetGoal_3) that are not
in the primary dataset. I want to add the 3 variables to my primary
dataset. The problem is that the second dataset has about 900 cases.
The primary dataset has a subset of 482 of the 900 cases.
How do I merge them.
Thanks!
Jan

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

Bruce Weaver

Re: matching files with same and different cases

Administrator

J McClure wrote

Hi,
I have a primary dataset with 150 vaariable. I have a second dataset
with only 3 variables (VetGoal_1 VetGoal_2, and VetGoal_3) that are not
in the primary dataset. I want to add the 3 variables to my primary
dataset. The problem is that the second dataset has about 900 cases.
The primary dataset has a subset of 482 of the 900 cases.
How do I merge them.
Thanks!
Jan

You must have missed this recent post to the list.

http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1009&L=spssx-l&F=&S=&P=36634

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

Richard Ristow

Re: matching files with same and different cases

In reply to this post by J McClure

At 05:28 PM 9/18/2010, J McClure wrote:

>I have a primary dataset with 150 variables. I have a second dataset
>with only 3 variables (VetGoal_1 VetGoal_2, and VetGoal_3) that are
>not in the primary dataset. I want to add the 3 variables to my
>primary dataset. The problem is that the second dataset has about
>900 cases. The primary dataset has a subset of 482 of the 900 cases.

If you have a key variable that appears in both datasets and
identifies corresponding records, it's an easy MATCH FILES; see
several recent posted examples. If you don't, you're close to out of luck.

(ALWAYS have enough identifying variables to uniquely identify every
record in your data file.)

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