topic Re: Creating text string using numeric values in proc sql in SAS Programming

Creating text string using numeric values in proc sql

apolitical — Wed, 25 Jul 2018 20:42:49 GMT

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

Re: Creating text string using numeric values in proc sql

novinosrin — Wed, 25 Jul 2018 20:28:43 GMT

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;

Re: Creating text string using numeric values in proc sql

novinosrin — Wed, 25 Jul 2018 20:31:04 GMT

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

Re: Creating text string using numeric values in proc sql

apolitical — Wed, 25 Jul 2018 20:43:28 GMT

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

Re: Creating text string using numeric values in proc sql

Reeza — Wed, 25 Jul 2018 20:45:29 GMT

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;

Re: Creating text string using numeric values in proc sql

apolitical — Wed, 25 Jul 2018 20:49:14 GMT

That works. Thank you!