Creating text string using numeric values in proc sql

[apolitical]

In the following code, I would like to create a character variable called "range", that takes on the value of "min_price to max_price", with min and max price equal to the min and max prices of each origin continent. How should I correct it?

proc sql;
create table stats as 
select origin,
max(msrp) as max_price,
min(msrp) as min_price,
"(min_price) to (max_price)" as range
from sashelp.cars 
group by 1
;
quit;

The results I'm looking for it like the following:

Origin   max_price   min_price   range

Asia     89765           10280         10280 to 89765

Europe 192465         16999         16999 to 192465

USA      81795           10995         10995 to 81795 

[novinosrin]

Did you mean this?

proc sql;
create table stats as 
select origin,msrp,ifc(max(msrp)=msrp or min(msrp)=msrp,"(min_price) to (max_price)",' ') as range
from sashelp.cars 
group by 1
;
quit;

[novinosrin]

or you want this?

proc sql;
create table stats as 
select origin,msrp,ifc(max(msrp)=msrp or min(msrp)=msrp,"(min_price) to (max_price)",' ') as range
from sashelp.cars 
group by 1
having max(msrp)=msrp or min(msrp)=msrp
;
quit;

or something else?

I am just guessing

[apolitical]

I included the desired dataset I want in the original post. Thanks.

[Reeza · Accepted solution]

It helps if you show the desired results, I think this works. 

proc sql;
create table stats as 
select origin,
max(msrp) as max_price,
min(msrp) as min_price,
catx(' to ', put(calculated min_price, 8.1), put(calculated max_price, 8.1)) as range
from sashelp.cars 
group by 1
;
quit;

[apolitical]

That works. Thank you!