topic Re: do the flags in New SAS User

do the flags

Smitha9 — Tue, 16 Mar 2021 14:58:53 GMT

Hi,

I need help in flagging the ID's.

dataset1 dataset2

ID ID

1 1

2 3

3 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 — Tue, 16 Mar 2021 15:08:51 GMT

data flaged;

merge dataset1(in=in1)

dataset2(in=in2);

by ID;

if in1;

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

run;

ballardw — Tue, 16 Mar 2021 15:10:22 GMT

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?