For each subject, one observation (or row) is kept based on the following:
if var2=c and var3=B
then keep that observation.
if not, check if var2=c and var3=S
and keep that observation.
if not, then then check if var2=L and var3=B
,
finally, check if var2=L and var3=S
, if not put 0.
Any help would be appreciated.
My data looks like this:
id var1 var2 var3
1 100 L S
1 100 L B
1 2 C B
1 2 C S
2 5 C S
2 10 L S
2 NA L B
2 NA C B
My desired result is:
id var1 var2 var3
1 2 C B
2 5 C S