https://communities.sas.com/t5/SAS-Programming/Update-on-Proc-SQL/m-p/478986#M123586 <P>Hi community</P><P>&nbsp;</P><P>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.</P><PRE><CODE class=" language-sas"><BR />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 &lt;&gt; 0 and b.record_date between Diab_date-3 and Diab_date+3; quit;</CODE></PRE> Wed, 18 Jul 2018 11:15:28 GMT Sathish_jammy 2018-07-18T11:15:28Z https://communities.sas.com/t5/SAS-Programming/Update-on-Proc-SQL/m-p/478986#M123586 <P>Hi community</P><P>&nbsp;</P><P>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.</P><PRE><CODE class=" language-sas"><BR />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 &lt;&gt; 0 and b.record_date between Diab_date-3 and Diab_date+3; quit;</CODE></PRE> Wed, 18 Jul 2018 11:15:28 GMT https://communities.sas.com/t5/SAS-Programming/Update-on-Proc-SQL/m-p/478986#M123586 Sathish_jammy 2018-07-18T11:15:28Z https://communities.sas.com/t5/SAS-Programming/Update-on-Proc-SQL/m-p/478989#M123589 <P><A href="http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#n1hz0uhw57yye2n16m5r103jjpjj.htm" target="_blank">http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#n1hz0uhw57yye2n16m5r103jjpjj.htm</A></P><P>&nbsp;</P><P>This documentation page has some examples about performing Update using PROC SQL that might be useful&nbsp;</P> Wed, 18 Jul 2018 11:33:32 GMT https://communities.sas.com/t5/SAS-Programming/Update-on-Proc-SQL/m-p/478989#M123589 UdayGuntupalli 2018-07-18T11:33:32Z