TO_CHAR in SAS proc SQL

[nicnad]

Hi,

let say I have the following query where minboundary and maxboundary are numeric :

proc sql;

create table mytest.test

to_char(mydata.minboundary) || " to " || to_char(mydata.maxboundary) as CRITERIA_VALUE

from mylib.mydata as mydata

;quit;

The function to_char is not located by SAS EG. How can I perform this query?

Thank you for your help.

[Reeza · Accepted solution]

to_char is not a SAS SQL function but an Oracle or MS SQL function.

The similar function in sas would be put or putc

[nicnad]

put works great in proc sql.

Thank you for the quick reply.