need help to convert  below sql query into proc sql or data set query of sas  Select x.* from yyy x inner join ( select abc, ad, min(date) as Minad from dbo.xx where xx in ('xx' ,'xx' ,'xx' ) AND Activity_Date >= 'mm/dd/yyyy' group by case_ID, Activity ) as b on a.abc = b.abc and a.ad=b.Minad where (a.ad)>= 'mm/dd/yyyy' and a.abc in ('xx' ,'xx' ,'xx' ) AND B.xx  IS NOT NULL group by a.abc,a.xx,b.xx   ... View more