How to use Exists Keyword in Base SAS

[AshokD]

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

[Reeza]

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;