BookmarkSubscribeRSS Feed
Antaralib
Obsidian | Level 7

Hi,

 

E.g I have 3 variables: 

No. of schools in a state

Ranking in state level

year

 

I want to find the no. of schools in the top 25 ranks that have occured more than 3 times.

 

I guess, I need to compare it against year. its easier to match against.

 

Any clue would be helpful.

6 REPLIES 6
stat_sas
Ammonite | Level 13

Try with proc rank.

 

Antaralib
Obsidian | Level 7

I tried this:

 

proc sort;
  by group descending amount;
run;

data top3(drop=count);
  set groups;
  by group descending amount;
  if first.group then count=0;
  count+1;
  if count le 3 then output;
run;

proc print;
run;

Also proc rank. Neither worked.

Astounding
PROC Star

We're both guessing.  Perhaps this is what you want:

 

proc freq data=have order=freq;

tables no_of_schools;

where (1 <= ranking <= 25);

run;

Antaralib
Obsidian | Level 7

Thanks @Astounding.

 

When I run proc freq, it only gives me the name of the students with the frequencies. But does not show me the rank# against those and also I need only the ones that has occurred more than 3 times.

i,e in 2011 - 1

        2016 -2

        2015 - 5 

 

or 2011 - 1

   2013 - 1

  2014 -1.

 

or 2011 - 4

 

could be anything

   

Astounding
PROC Star

When you first posted the problem, the name of the student wasn't even mentioned as a variable.  If it's important to the result, you will need to illustrate some of the data coming in, and what the report should look like.

Antaralib
Obsidian | Level 7

@Astounding

Sincere apologies. It was name of students and not 'no.'

 

Here's what I am looking for :

 

THe name of the students featured in the top25 ranks of the schools that have occurred more than 3 times (i.e they have come in the top25 ranking for more than 3 times).

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1768 views
  • 0 likes
  • 3 in conversation