How to use Exists Keyword in Base SAS

AshokD — Sat, 26 Sep 2015 18:32:12 GMT

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

Re: How to use Exists Keyword in Base SAS

Reeza — Sat, 26 Sep 2015 19:25:37 GMT

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;

topic Re: How to use Exists Keyword in Base SAS in SAS Programming

How to use Exists Keyword in Base SAS

Re: How to use Exists Keyword in Base SAS