<div>
are the values in the field or combination of fields you are using for the join unique? do they contain blanks?
</div>


are the values in the field or combination of fields you are using for the join unique? do they contain blanks?

<div>
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. <br />
does it matters?<br />

</div>


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?


<div>
<div class="content wysiwyg-content">
hi,<br />
I am running simple SAS query with inner join. I am getting duplicate records. I don't know why?<br />
any help please.<br />
cheers<br />
P
</div>
</div>


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

SAS Query duplicate records

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.