Hi community
Could u pls help me to resolve a correct format of UPDATE query... the given code perfectly works on SQL.. but i have no idea about a update JOIN in SAS.
proc sql;
update ss_typ
set ht = b.Height
FROM ss_typ a JOIN anthropometry b
ON a.mno = b.patient_id and diabcat = 'normal' and height <> 0 and
b.record_date between Diab_date-3 and Diab_date+3;
quit;