DATA Step, Macro, Functions and more

How to use Exists Keyword in Base SAS

Reply
New Contributor
Posts: 3

How to use Exists Keyword in Base SAS

Hi All,

 

I'm new to the Base SAS Concepts.

 

Can anyone help me on the below scenario

 

I'm having dataset called FINALand it has the below records

 

S.no Name   July_salary(Field1)   August_Salary(Field2)

 

1      xxxx        20000                       21000             

 

2      yyyy        34000                       30500

 

3     zzzz         89000                       --------

 

Creating two datasets by keeping FINAL datatset.

 

Data 

         Match

         Unmatch;

    SET

          FINAL;

................. ?????????

 

I need to report if the Field1 is exists or >0 and Field2 is exists or >0 then output to Match Dataset else output to UnMatch Dataset

 

So Match dataset should contain 1 & 2 row  and Unmatch dataset should contain 3 row.

 

Could you please share your ideas on how to proceed with this ?

 

Thanks

Super User
Posts: 19,770

Re: How to use Exists Keyword in Base SAS

You question is still unclear, what do you mean "exists"? That it's not missing? if so you can use the n or nmiss() function.

data match unlatch;
set final;
if nmiss(field1, field2)>0 then output unmatch;
else output match;
run;
Ask a Question
Discussion stats
  • 1 reply
  • 159 views
  • 0 likes
  • 2 in conversation