Update on Proc SQL

[Sathish_jammy]

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;

[UdayGuntupalli]

http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#n1hz0uhw57yye2n16m...

This documentation page has some examples about performing Update using PROC SQL that might be useful