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?
data want;
set us4 (obs=500);
run;
or
data want;
set us4;
if _n_>500 then stop;
run;
data want;
set us4 (obs=500);
run;
or
data want;
set us4;
if _n_>500 then stop;
run;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.