topic Re: Sort Mean in Ascending order without Proc Sort in SAS Enterprise Guide

Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 15:30:37 GMT

Hi,
If I have a list of saleprice, but I need to get the mean of it (in ascending order) and categories under One variable FloorAreaCat. How do I write the code in Single Proc means step? (p/s I do not want to use Proc sort step in this case)
Appreciate if can help.

Thanks!

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 15:36:55 GMT

AFAIK this isn't possible, without an additional step. If you're working with a single variable consider using PROC SQL instead.

Re: Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 15:39:24 GMT

What if under the FloorAreaCat consist of "None", "Equal" or "Type" variables, can we do it?

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 15:49:03 GMT

AFAIK there's no way to sort based on the value of the MEAN. I'm not sure what the values of FloorAreaCat have to do with that.

Re: Sort Mean in Ascending order without Proc Sort

KachiM — Tue, 22 Aug 2017 15:53:40 GMT

Do you want like:
TYPE 30.52
NONE 25.20
EQUAL 10.45

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 15:58:11 GMT

proc sql;
create table want as
select make, mean(msrp) as avg_msrp format=8.1
from sashelp.cars
group by make /*BY or CLASS variables go here and in the SELECT statement*/
order by calculated avg_msrp ;
quit;

Re: Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 16:00:31 GMT

How about the below? Can I sort the Mean in ascending order? I have already found the Mean value of my saleprice, and group it under the FlorrAreaCat but I can't seem to sort the Mean value. Can it be done under the same Proc Means Step?

FloorAreaCat N Obs Mean (SalePrice)

Equal 200 200000

None 800 150000

Small 90 340000

Re: Sort Mean in Ascending order without Proc Sort

ballardw — Tue, 22 Aug 2017 15:58:52 GMT

Provide a small example data set and what the result needs to look like.

Write a data step to provide the example data or Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Any artificial restriction of "cannot use Proc sort" is similar to "I want to eat canned food without opening the can".

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 15:59:27 GMT

@BabyWS2001 wrote:

How about the below? Can I sort the Mean in ascending order? I have already found the Mean value of my saleprice, and group it under the FlorrAreaCat but I can't seem to sort the Mean value. Can it be done under the same Proc Means Step?

FloorAreaCat   N Obs    Mean (SalePrice)

Equal                200       200000

None                800       150000

Small                 90        34000

That's DESCENDING order......

Re: Sort Mean in Ascending order without Proc Sort

PaigeMiller — Tue, 22 Aug 2017 16:08:11 GMT

Any problem that says you can't use PROC SORT to get things properly sorted seems like it's a made up problem.

Re: Sort Mean in Ascending order without Proc Sort

KachiM — Tue, 22 Aug 2017 16:19:38 GMT

For your special requirements, entire thing can be done in a data step. No need for Proc Sort, Proc Means.

Do you like a data step?

Re: Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 16:29:38 GMT

Is ok, cause this is my Uni SAS programing assignment question. Will try to find a way out if there no way to solve this question.

Thanks.

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 16:35:00 GMT

Post the exact question then, there's the possibility you're misinterpreting the question.

Re: Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 17:03:01 GMT

Here the question

(q) list down in ascending order the mean sale price, categories under variable of FloorAreaCat. Use single Proc Means step to answer this question.

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 17:07:47 GMT

A single PROC MEANS doesn't mean you can't use SORT in my opinion. Or maybe there is a way...I would check your class notes.

@BabyWS2001 wrote:

Here the question

(q) list down in ascending order the mean sale price, categories under variable of FloorAreaCat. Use single Proc Means step to answer this question.

Re: Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 17:16:48 GMT

Thanks,so if use sort do you use the Proc Sort or Order statement? Cause I can't seem to sort the mean once i use Class statement code as stated below...

I can't use Class SalePrice/Ascending as it will show all the mean saleprice and not group by the FloorAreaCat....

Proc Mean data=work.analysis mean;

Class FloorAreaCat;

var SalePrice;

Run;

Re: Sort Mean in Ascending order without Proc Sort

Reeza — Tue, 22 Aug 2017 17:19:35 GMT

You need to first store your data in a data set then you sort that data set.

Re: Sort Mean in Ascending order without Proc Sort

BabyWS2001 — Tue, 22 Aug 2017 17:21:50 GMT

Ok, I will sort that dataset first. Thanks.