2 weeks ago
My data looks like below without the flag, I want to create a flag that has the value of 1 when B> A (0 when reverse is true)and it should be missing when either A or B has a missing value.
I have tried this;
if (A ne .) or (B ne .) and B >A then flag=1;
and didn't work.
2 weeks ago - last edited 2 weeks ago
data want; set have; if nmiss(a,b)=0 then flag=b>a; run;
EDIT: I really appreciate you self attempt and effort to get a working code. However, once you throw open a thread in the community, you are sure to get some robust solutions. But well done mate!
Need further help from the community? Please ask a new question.