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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.