topic Re: Comparing 2 dataset by Age in SAS Programming

Comparing 2 dataset by Age

Shakti_Sourav — Mon, 22 Aug 2022 16:16:23 GMT

Dear Team,
I want to compare two dataset. I have mentioned below by Example,
Data 1: (Age_1 = Age - 5, Age_2= Age +5 )
NAME. AGE. Age_1. Age_2
ABC 25. 20. 30
Xyz. 20. 15. 25

Data 2:
Name. Age.
ABC. 27
XYZ. 22

Problem:
If data2.Age value is between the data1.age_1 and data1.age_2. then one flag will create. Otherwise flag 0. Like this condition I am unable to do. Please suggest how to do this type of problem ?

Re: Comparing 2 dataset by Age

PaigeMiller — Mon, 22 Aug 2022 16:21:42 GMT

proc sql;
    create table want as select
    data2.*
    ,case when data2.age between data1.age_1 and data1.age_2 then 1 else 0 end as flag
    from data1 left join data2
    on upcase(data1.name)=upcase(data2.name);
quit;

This code is untested, you need to provide data as working SAS data step code for it to be tested.