need to combine 2 datasets ANC & OTHER  pull patient ids  who received both anc (supplies) and other (drug) in above 2 datasets   id category category desc A 11 DRUG A 11 DRUG A 13 ANC A 13 ANC B 11 DRUG C 11 DRUG D 11 DRUG F 11 DRUG G 11 DRUG G 13 ANC G 13 ANC G 13 ANC G 13 ANC G 13 ANC H 11     i want id A& G  show up in the report i used below code data PTNT_both1 (keep= id categorycategory_desc) ; merge ptnt_anc_out (in=anc) ptnt_other_out (in=other); by patient_id; if anc=1 and other=1; run;  not getting all records from A & G  Please help ... View more