turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- Base SAS Programming
- /
- sas functions

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

a month ago

Dear

I am trying to find a function that i can be used in the second 'if' statement. Please suggest.Thank you

in the second if statement, i am trying to find if all three variables missing or all three variables ='UNKNOWN' then set the 'd' variable missing.

my code;

data two;

set one;

if a="NEGATIVE" and b="NEGATIVE" and c="NEGATIVE" then=d='yes';

if cmiss(a,b,c) =3 or (a='UNKNOWN' and b='UNKNOWN' and c='UNKNOWN' ) then d='missing';

else d='no';

data one; input a $1-8 b $10-17 c $19-26; datalines; NEGATIVE NEGATIVE NEGATIVE UNKNOWN UNKNOWN UNKNOWN UNKNOWN NEGATIVE ;

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to knveraraju91

a month ago

@knveraraju91 wrote:

Dear

I am trying to find a function that i can be used in the second 'if' statement. Please suggest.Thank you

in the second if statement, i am trying to find if all three variables missing or all three variables ='UNKNOWN' then set the 'd' variable missing.

It's not clear to me what the question is. You haven't actually asked a question.

--

Paige Miller

Paige Miller

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to knveraraju91

a month ago

I suspect that what you mean to do is :

```
data two;
set one;
if a="NEGATIVE" and b="NEGATIVE" and c="NEGATIVE" then d='yes';
else if cmiss(a,b,c) =3 or (a='UNKNOWN' and b='UNKNOWN' and c='UNKNOWN' ) then d='missing';
else d='no';
run;
```

PG

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to knveraraju91

a month ago

I'm not sure you meant to re-use the variable name D all the time. But here is an approach you can use.

if a=b=c then do;

if a in (' ', 'NEGATIVE') then d='yes';

else d='no';

end;