do the flags

[Smitha9]

Hi,

I need help in flagging the ID's.

dataset1    dataset2

ID                  ID

1                     1

2                     3

3                     5

4

5 

I need to flag the identical ID's

in the above example I need to flag dataset1 which has same ID as dataset2. like ID's 1 3 5 needs to be flagged.

thanks in advance

[Shmuel · Accepted solution]

data flaged;

 merge dataset1(in=in1)

           dataset2(in=in2);

   by ID;

       if in1;

       if in2 then flag=1; else flag=0;

run;

[ballardw]

What does the output look like?

Is the data currently sorted by Id?

Are there duplicates of ID in either of the sets? If so which one(s)? And what would the output for duplicates look like?