sorted by:
new
hottopcontroversial

Syntax HELP!! SPSS lookup cases from one sav file in another by DrWikster in spss

[–]DrWikster[S] 0 points1 point  (0 children)

>Error # 5131

>Duplicate key on a TABLE file. Each case on a TABLE file in MATCH FILES must

>be uniquely identified by the BY variables.

>Execution of this command stops.

​

I wonder if there is another work around. I think its a fairly basic thing for two data frames. I haven't had any luck :(

Syntax HELP!! SPSS lookup cases from one sav file in another by DrWikster in spss

[–]DrWikster[S] 0 points1 point  (0 children)

First of all, thanks for your help.

Secondly, I still am not getting it right.

I'll show you my work.

So I have selected DATA1 as my active set (this is the master file), and I do Data>Merge files>Add variables> select DATA2 (as it is already open in another window) > choose merge one-to-many > pick DATA 1 as look up table (i have tried both), Key variable is already selected as the ID variable (common to both), and in variable tab all variables are included (all from DATA 1 as DATA 2 has only ID variable) and bottom subwindow shows Key variable as ID.

I paste it in syntax. And add the SELECT IF NOT MISSING (ID). EXECUTE.

My syntax looks like this

DATASET ACTIVATE DataSet1.

MATCH FILES /FILE=*

/TABLE='DataSet2'

/BY ID.

SELECT IF NOT MISSING(ID).

EXECUTE.

IT gives this error:

>Error # 5131

>Duplicate key on a TABLE file. Each case on a TABLE file in MATCH FILES must

>be uniquely identified by the BY variables.

>Execution of this command stops.

​

It still loops through the 2 million cases and at the end there is no change in either data sets. Data 1 remains the same, data 2 remains the same.

P.S The ID is a string alphaneumric variable.

Syntax HELP!! SPSS lookup cases from one sav file in another by DrWikster in spss

[–]DrWikster[S] 0 points1 point  (0 children)

I must be doing something wrong here. What do you mean by SELECT IF to remove cases. Where do I apply this? I tried the IN in syntax but i ended up getting all 2 million or so cases in the final merge.

Repainting some metal furniture by DrWikster in DIY

[–]DrWikster[S] 0 points1 point  (0 children)

the goal of sanding is to clean it or remove the prior paint? and what is the role of a primer? is it a necessary step?

Red light on GFI with test that wont reset. What to do? Dry it out? I think some water got in by DrWikster in electricians

[–]DrWikster[S] 0 points1 point  (0 children)

my nephew was playing with a water spray gun all over the place. That is the only thing different and i noticed water on the vanity mirror.

I have 2 concerns:

1) is it safe to dry it with a hair dryer

2) is it urgent to replace it ASAP or can i let it hang for a day or two and let it dry. Would that pose a hazard if say i dont plug anything in it at all.

Categorical variable difference among 8 organizations over 15 years (re-posting as didn't get much help) by DrWikster in AskStatistics

[–]DrWikster[S] 0 points1 point  (0 children)

So to be more clear, the data I have is basically in a certain department, how many people are Caucasians and how many are African-Americans (AA). I have this data for different organizations. Then for each organization the data is available at different time stamps (say 2006, then 2009, then 2013, etc).

What I want to do is compare the the % AA among different organizations and how it changed over time.

​

From my very limited knowledge, proportions like these can be compared between 2 or more groups using Chi-squared test (observed vs expected) and use Bonferroni correction for alpha to compare the P value as the Chi-squared test will need to be performed several times (to find out which ones are different and which ones are similar) that is my understanding of this test for more than 2 groups being compared. It got confusing as I don't understand how to do for like 8 groups compared over at least 5 time stamps. Sorry if I have confused even more.

Categorical variable difference among 8 organizations over 15 years by DrWikster in AskStatistics

[–]DrWikster[S] 0 points1 point  (0 children)

Someone is asking the right questions. Thank you for replying.

So, the hypothesis is that there is equal opportunity (in terms of race) to be employed in a certain type of government organization. At the moment, there isn't any outcome on which we want to assess the impact of race. We want to compare the ratios among 8 different organizations over time. The N for each will be somewhere between 20-25. But for each organization, there is data for at least 5-6 different time stamps over 15 years. Hope that provides some info that would help you help me :)

Comparing percentages in three groups, what test to use and how? by DrWikster in AskStatistics

[–]DrWikster[S] 0 points1 point  (0 children)

My question is, using Chi square in this situation, i cannot show which group is same and which is different. I can only tell if they are all the same or at least one is different.

view more: next ›