topic Re: Create a flag variable whose value is missing when multiple variables are not missing. in SAS Data Management

Create a flag variable whose value is missing when multiple variables are not missing.

pmpradhan — Thu, 14 Jun 2018 23:18:41 GMT

My data is

A B C

1 0 1

0 0 0

1 1 0

0 0 1

1 1 1

What to create a flag variable which is missing when A or B or C have 1 and flag variable should be . when all three of them have 0

WANT dataset like

A B C nmiss

1 0 1 .

0 0 0 1

1 1 0 .

0 0 1 .

1 1 1 .

Any quick way to do this?

pau13rown — Thu, 14 Jun 2018 23:47:54 GMT

if sum(a,b,c)=0 then flag=1;

else flag=.;

pmpradhan — Fri, 15 Jun 2018 00:08:08 GMT

Thank you!