I am trying to merge many to many variables using proc sql. i am getting syntex error . can anyone please help what is syntex error is? please help. it's urgent BELOW IS MY CODE proc sort data=pk_dose0; by nsid date time dose; run; proc sort data=dose_poppk; by nsid date time dose; run; proc sql; create table aa as select * from pk_dose0 as a join dose_poppk as b on (a.nsid=b.nsid) (a.date=b.date) (a.time=b.time); quit; proc sql; create table both as select coalesce(a.nsid, b.nsid) as id, coalesce(a.date, b.date) as date, coalesce(a.time, b.time) as time, farm from pk_dose0 as a full join dose_poppk as b on a.id = b.id, on a.date = b.date, on a.time = b.time); quit; BELOW IS SCREENSHOT OF ERROR.
... View more