topic Re: How to create a dummy variable based on if the value in one column can be found in another one? in SAS Data Management

How to create a dummy variable based on if the value in one column can be found in another one?

tomtom09 — Wed, 23 Sep 2015 02:57:15 GMT

Hi guys. I have two columns value1 and value2, in value1, say, I have three observations a, b, c, in value2, I have 4 observations a, a, b,m, I want to create a dummy variable match for each row in value1, if the value can be found in value 2, then match=1 otherwise it is 0. So for this dataset, it should be 1,1,0. Can anyone help me with this? Thanks a lot!

Re: How to create a dummy variable based on if the value in one column can be found in another one?

user24feb — Wed, 23 Sep 2015 07:36:39 GMT

Data A;
Input value1 $ value2 $;
Datalines;
a a
b a
c b
. m
;
Run;

Data B;
If _N_ eq 1 Then Do;
Declare Hash H (Dataset:'A (Drop=value1 Rename=(value2=value1)');
H.Definekey('value1');
H.Definedone();
If 0 Then Set A (Drop=value1 Rename=(value2=value1));
End;
Set A;
dummy=1-Min(H.Find(),1);
Run;

Re: How to create a dummy variable based on if the value in one column can be found in another one?

PaigeMiller — Wed, 23 Sep 2015 12:07:03 GMT

Use PROC GLMMOD to create dummy variables.

Re: How to create a dummy variable based on if the value in one column can be found in another one?

tomtom09 — Wed, 23 Sep 2015 18:31:58 GMT

Thanks so much! It works very well!

Re: How to create a dummy variable based on if the value in one column can be found in another one?

tomtom09 — Wed, 23 Sep 2015 18:32:25 GMT

Thanks PaigeMiller!