Advanced Search

Return to Snippet

Revision: 14250
at May 26, 2009 15:43 by statsplank
Initial Code 
/* original data set */
data firm; input category size @@;
datalines;
1 93458934 1 8467489 1 8679 2 56757 3 57850
1 456794 2 697058 2 59876 3 687957 3 698879
3 598679 1 8756356 1 356396 1 65365 2 56385
2 4686 2 469674967 2 49679674 3 4686 3 47696
3 76946794 3 64868
;

/* sort by category and then by size within each category in descending order */
proc sort data=firm;
by category DESCENDING size;
run;

/* create rank variable within each category */
data firm1; set firm;
by category;
rank+1;
if first.category then rank=1;
run;

/* data set that contains 5 biggest firms within each category */
data firm2; set firm1(where=(rank<6));
run;
Initial URL 
http://support.sas.com/forums/message.jspa?messageID=21083#21083
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Selecting 5 max observations per category

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
data

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SAS