topic Re: TO_CHAR in SAS proc SQL in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134256#M36456 <HTML><HEAD></HEAD><BODY><P>to_char is not a SAS SQL function but an Oracle or MS SQL function.</P><P>The similar function in sas would be put or putc</P></BODY></HTML> Wed, 15 May 2013 19:07:03 GMT Reeza 2013-05-15T19:07:03Z TO_CHAR in SAS proc SQL https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134255#M36455 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>let say I have the following query where minboundary and maxboundary are numeric :</P><P></P><P></P><P>proc sql;</P><P>create table mytest.test</P><P>to_char(mydata.minboundary) || " to " || to_char(mydata.maxboundary) as CRITERIA_VALUE</P><P>from mylib.mydata as mydata</P><P>;quit;</P><P></P><P>The function to_char is not located by SAS EG. How can I perform this query?</P><P></P><P>Thank you for your help.</P></BODY></HTML> Wed, 15 May 2013 17:38:37 GMT https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134255#M36455 nicnad 2013-05-15T17:38:37Z Re: TO_CHAR in SAS proc SQL https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134256#M36456 <HTML><HEAD></HEAD><BODY><P>to_char is not a SAS SQL function but an Oracle or MS SQL function.</P><P>The similar function in sas would be put or putc</P></BODY></HTML> Wed, 15 May 2013 19:07:03 GMT https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134256#M36456 Reeza 2013-05-15T19:07:03Z Re: TO_CHAR in SAS proc SQL https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134257#M36457 <HTML><HEAD></HEAD><BODY><P>put works great in proc sql.</P><P></P><P>Thank you for the quick reply.</P></BODY></HTML> Wed, 15 May 2013 20:27:22 GMT https://communities.sas.com/t5/SAS-Procedures/TO-CHAR-in-SAS-proc-SQL/m-p/134257#M36457 nicnad 2013-05-15T20:27:22Z