topic Re: Delete Syntax Error in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Delete-Syntax-Error/m-p/144676#M2336 <HTML><HEAD></HEAD><BODY><P>Its same as <A __default_attr="194151" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/"></A></P></BODY></HTML> Fri, 17 Jan 2014 21:03:15 GMT pradeepalankar 2014-01-17T21:03:15Z Delete Syntax Error https://communities.sas.com/t5/SAS-Data-Management/Delete-Syntax-Error/m-p/144675#M2335 <HTML><HEAD></HEAD><BODY><P>An error is occurring when running the command below in SAS DI. </P><P>The SAS does not accept the IN command with more than one parameter?</P><P></P><P>&nbsp;&nbsp; proc sql;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; delete from LIB_REF1.ODS_CUSTOMER</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ODS_CUSTOMER.ID1, ODS_CUSTOMER.ID2) IN (</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select CUST.ID1,CUST.ID2 from LIB_REF2.CUST</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P><STRONG>&nbsp;&nbsp; ; </STRONG></P></BODY></HTML> Fri, 17 Jan 2014 16:23:32 GMT https://communities.sas.com/t5/SAS-Data-Management/Delete-Syntax-Error/m-p/144675#M2335 DavidCaliman 2014-01-17T16:23:32Z Re: Delete Syntax Error https://communities.sas.com/t5/SAS-Data-Management/Delete-Syntax-Error/m-p/144676#M2336 <HTML><HEAD></HEAD><BODY><P>Its same as <A __default_attr="194151" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/"></A></P></BODY></HTML> Fri, 17 Jan 2014 21:03:15 GMT https://communities.sas.com/t5/SAS-Data-Management/Delete-Syntax-Error/m-p/144676#M2336 pradeepalankar 2014-01-17T21:03:15Z