topic Re: Warning message in SAS Programming https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131442#M26780 <HTML><HEAD></HEAD><BODY><P>but the warning is related to input function.</P></BODY></HTML> Wed, 21 Nov 2012 11:38:35 GMT SASPhile 2012-11-21T11:38:35Z Warning message https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131440#M26778 <HTML><HEAD></HEAD><BODY><P>Why is this warnng message displayed?&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>&nbsp;&nbsp;&nbsp; create table cell_phone<BR />79&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as<BR />80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select<BR />81&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a.GALC_ACCT_NO as acct_no<BR />82&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,compress(a.GALC_ALRT_PHONE_NO,'-') as cell_nbr<BR />83&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from outdata.DMGADR_171212 a<BR />84&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join (<BR />85&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select<BR />86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b.GALC_ACCT_NO<BR />87&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,max(GALC_LST_UPDT_TS) as last_updt_dt<BR />88&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from outdata.DMGADR_171212 b<BR />89&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where coalesce(b.GALC_ADDR_TYPE_CD,'')='PHN'<BR />90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and b.GALC_ALRT_PHONE_NO is not null<BR />91&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and input(compress(b.GALC_ALRT_PHONE_NO,'-'),10.) &gt; 0<BR />92&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; group by b.GALC_ACCT_NO<BR />93&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) b on a.GALC_ACCT_NO=b.GALC_ACCT_NO and a.GALC_LST_UPDT_TS=b.last_updt_dt<BR />94&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where coalesce(a.GALC_ADDR_TYPE_CD)='PHN'<BR />95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and a.GALC_ALRT_PHONE_NO is not null<BR />96&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and input(compress(a.GALC_ALRT_PHONE_NO,'-'),10.) &gt; 0<BR />97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;<BR />WARNING: INPUT function reported 'WARNING: Illegal first argument to function' while processing WHERE clause.<BR />WARNING: INPUT function reported 'WARNING: Illegal first argument to function' while processing WHERE clause.<BR />WARNING: INPUT function reported 'WARNING: Illegal first argument to function' while processing WHERE clause.</P></BODY></HTML> Wed, 21 Nov 2012 04:32:35 GMT https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131440#M26778 SASPhile 2012-11-21T04:32:35Z Re: Warning message https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131441#M26779 <HTML><HEAD></HEAD><BODY><P>You should use coalesce<STRONG>c</STRONG>( ) for character variable, coalesce() is for numeric variable.</P></BODY></HTML> Wed, 21 Nov 2012 05:01:55 GMT https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131441#M26779 Ksharp 2012-11-21T05:01:55Z Re: Warning message https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131442#M26780 <HTML><HEAD></HEAD><BODY><P>but the warning is related to input function.</P></BODY></HTML> Wed, 21 Nov 2012 11:38:35 GMT https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131442#M26780 SASPhile 2012-11-21T11:38:35Z Re: Warning message https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131443#M26781 <HTML><HEAD></HEAD><BODY><P>Have you tried input(compress(b.GALC_ALRT_PHONE_NO,'','KD')) ?&nbsp; 'KD' will keep only numeric characters.&nbsp; There may be other delimiters in your phone data.</P><P></P><P>Richard in Oz</P></BODY></HTML> Wed, 21 Nov 2012 14:06:29 GMT https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131443#M26781 RichardinOz 2012-11-21T14:06:29Z Re: Warning message https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131444#M26782 <HTML><HEAD></HEAD><BODY><P>Will try that!</P><P>Thanks.</P></BODY></HTML> Wed, 21 Nov 2012 14:44:55 GMT https://communities.sas.com/t5/SAS-Programming/Warning-message/m-p/131444#M26782 SASPhile 2012-11-21T14:44:55Z