SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Accepted Solution Solved
Reply
Contributor
Posts: 34
Accepted Solution

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

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?


Accepted Solutions
Solution
Thursday
Frequent Contributor
Posts: 82

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

[ Edited ]
Posted in reply to pmpradhan

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

else flag=.;

 

 

--------------
blog: papersandprograms.com

View solution in original post


All Replies
Solution
Thursday
Frequent Contributor
Posts: 82

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

[ Edited ]
Posted in reply to pmpradhan

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

else flag=.;

 

 

--------------
blog: papersandprograms.com
Contributor
Posts: 34

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

Posted in reply to PaulBrownPhD

Thank you!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 102 views
  • 1 like
  • 2 in conversation