SAS Query duplicate records

hi,
I am running simple SAS query with inner join. I am getting duplicate records. I don't know why?
any help please.
cheers
P
premkripalaniAsked:
Who is Participating?
 
Aloysius LowConnect With a Mentor Commented:
no it shouldn't matter.

i'm not doubting when you said staff_id is unique, but have you checked for all tables, that if there are 10 records, for example, you can see 10 different staff_id, and not less?

given that this is a key field, there should be no blanks, but have you confirmed there are no blanks?

try running queries for the 3 tables individually on staff id to get a count of each staff id, group by staff id, sort by count descending
0
 
Aloysius LowCommented:
are the values in the field or combination of fields you are using for the join unique? do they contain blanks?
0
 
premkripalaniAuthor Commented:
the join is on staff_Id. which is unique value. however, there are two tables. table 1 staff_id has 12 char and table 2 staff_if has 10 char. actual staff id is only 8 char. and the output query has 12 char.
does it matters?
0
 
premkripalaniAuthor Commented:
all good,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.