topic Flag same number from two variables? in SAS Programming

Flag same number from two variables?

ybz12003 — Fri, 02 Jun 2017 12:01:22 GMT

Hello:

I would like to find out the same ID from two variables ID1 and ID2. Then, I created new variable "Same" to see if there is, and flag it with number 1, and count the total number of the same ID. However, the new "same" column is '.' which it is not the result I would like to. I would like to match result shown as the attachment. What is the problem?

data test1;
input ID HR Score;
cards;
1 89 60
2 69 61
3 49 62
4 85 63
5 56 64
6 75 65
7 90 66
;
run;

data test2;
input ID TR Score;
cards;
2 60 50
4 61 40
6 62 60
8 63 65
9 64 78
10 65 79
11 66 90
;
run;

data testID1;
set test1 (keep=ID);
by ID;
run;

data testID2;
set test2 (keep=ID);
by ID;
run;

data test12;

merge testID1(in=intestID1 rename=(ID=ID1))

testID2(in=intestID2 rename=(ID=ID2));

run;

data test13;

set test12;

if ID1 = ID2 then

same = 1;

by ID2;

run;

Re: Flag same number from two variables?

Reeza — Fri, 02 Jun 2017 02:34:10 GMT

There's no BY statement in your MERGE.

Re: Flag same number from two variables?

ybz12003 — Fri, 02 Jun 2017 03:15:05 GMT

Also, how to count the total number of the same ID. Please see the attachment.

Re: Flag same number from two variables?

Reeza — Fri, 02 Jun 2017 03:18:29 GMT

Is your original question answered?

If so, mark this question as solved and please ask a new one.

I won't open attachments so post everything directly into the forum.

Re: Flag same number from two variables?

ybz12003 — Fri, 02 Jun 2017 11:57:14 GMT

Hi, Reeza: I have added by on the merged dataset. It doesn't work.