BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
nicnad
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

2 REPLIES 2
Reeza
Super User

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
Fluorite | Level 6

put works great in proc sql.

Thank you for the quick reply.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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