Help using Base SAS procedures

TO_CHAR in SAS proc SQL

Accepted Solution Solved
Reply
Regular Contributor
Posts: 186
Accepted Solution

TO_CHAR in SAS proc SQL

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.


Accepted Solutions
Solution
‎05-15-2013 03:07 PM
Super User
Posts: 17,905

Re: TO_CHAR in SAS proc SQL

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

View solution in original post


All Replies
Solution
‎05-15-2013 03:07 PM
Super User
Posts: 17,905

Re: TO_CHAR in SAS proc SQL

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

Regular Contributor
Posts: 186

Re: TO_CHAR in SAS proc SQL

put works great in proc sql.

Thank you for the quick reply.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 6024 views
  • 1 like
  • 2 in conversation