Help using Base SAS procedures

how many i keep top 500 observations

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 102
Accepted Solution

how many i keep top 500 observations

i have a variable mktcapitalisation in a dataset

i sorted them and found 4886 observations

proc sort data=us3 out= us4;

  key mktcapitalisation/descending;

run;*/4886 obs;

how do i keep the top 500?


Accepted Solutions
Solution
‎04-17-2014 11:44 AM
Respected Advisor
Posts: 3,124

Re: how many i keep top 500 observations

data want;

   set us4 (obs=500);

run;

or

data want;

   set us4;

if  _n_>500 then stop;

run;

View solution in original post


All Replies
Solution
‎04-17-2014 11:44 AM
Respected Advisor
Posts: 3,124

Re: how many i keep top 500 observations

data want;

   set us4 (obs=500);

run;

or

data want;

   set us4;

if  _n_>500 then stop;

run;

Regular Contributor
Posts: 217

Re: how many i keep top 500 observations

What is your definition of top 500?.  You sorted the file.  Do you want the first 500 in each sort group?  Do you want the top 500 sort groups in terms of frequency or percentage of the total?      A proc freq can tell you which sorted values are more frequent than others.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 336 views
  • 3 likes
  • 3 in conversation