Hi Expert, I am not getting correct output when testing this code in huge data. The programming is running with zero output.    I want all records from child sheet when country, product and dosage matches between two datasets.              or country-product matches between two dataset only when dosage values is null for child dataset   Product data column should be considered as pattern matching. Can you please help me where I have done the mistake or is there any altenative approach to retrieve data in a faster way.   data Child; input pid country $ product & $25. dosage $; cards; 101 France Atorvastatin Oral 102 France PaRacetamol . 103 Russia Nimusulide injection sc 104 China DIovan Tablet 105 Japan Gelusil Tablet 106 India Codeine Tablet ; run; data Parent; input country $ product & $25. dosage $; cards; JapaN Atorvastatin calcium Oral China Atorvastatin Oral France Atorvastatin calcium Oral Russia Paracetamol Oral India Paracetamol Oral France Paracetamol Oral RusSia Nimusulide sc China diovan Syrup . China diovan . China Gelusil . india Codeine . Japan Gelusil Tablet . ; run; proc sql; create table match_country_prod_dos as select c.* from child c, parent p where upper(compress(c.country)) in (select upper(compress(p.country)) from parent) and (upper(compress(c.product)) like '%' || upper(compress(p.product)) || '%' or upper(compress(p.product)) like '%' ||upper(compress(c.product))|| '%') and upper(compress(c.dosage)) in (select upper(compress(p.dosage)) from parent); quit; proc sql; create table match_country_prod_dosagenull as select c.* from child c, parent p where c.dosage is null and upper(compress(c.country)) in (select upper(compress(p.country)) from parent) and (upper(compress(c.product)) like '%' || upper(compress(p.product)) || '%' or upper(compress(p.product)) like '%' ||upper(compress(c.product))|| '%') ; quit; data final; set match_country_prod_dos match_country_prod_dosagenull; run;     ... View more