topic Re: rank procedure by total in SAS Programming

rank procedure by total

pavank — Tue, 27 Jul 2021 06:33:16 GMT

data olympics;
infile datalines dlm='/';
input Team/NOC:& $26.  Gold 29 Silver 31  Bronze 34;
datalines;
United States of America	 8	3	8
Japan						 8	2	3
People's Republic of China	 7	5	7
ROC							 5	7	3
Great Britain				 4	5	1
Australia					 3	1	3
Republic of Korea			 3	0	4
Kosovo						 2	0	0
Italy						 1	4	4
Canada						 1	3	1
France						 1	2	2
Hungary						 1	1	0
Tunisia						 1	1	0
Croatia						 1	0	1
Slovenia					 1	0	1
Austria						 1	0	0
Bermuda						 1	0	0
Ecuador						 1	0	0
Hong Kong, China			 1	0	0
Islamic Republic of Iran	 1	0	0
Norway						 1	0	0
Philippines					 1	0	0
Thailand					 1	0	0
Uzbekistan					 1	0	0
Netherlands					 0	3	0
Brazil						 0	2	2
Chinese Taipei				 0	2	2
Georgia						 0	2	0
Czech Republic				 0	1	1
Spain						 0	1	1
Indonesia					 0	1	1
Serbia						 0	1	1
Switzerland					 0	1	1
Belgium						 0	1	0
Bulgaria					 0	1	0
Colombia					 0	1	0
Denmark						 0	1	0
India						 0	1	0
Jordan						 0	1	0
Romania						 0	1	0
South Africa				 0	1	0
Germany						 0	0	3
Kazakhstan					 0	0	3
Ukraine						 0	0	3
Egypt						 0	0	2
Mongolia					 0	0	2
Turkey						 0	0	2
Côte d'Ivoire				 0	0	1
Estonia						 0	0	1
Israel						 0	0	1
Kuwait						 0	0	1
Mexico						 0	0	1
New Zealand					 0	0	1
;
run;


proc rank data=olympics_ranks out=ran ties=low;
var silver ;
ranks rankposition;
by Team/NOC notsorted;
run;

Required Output:

Rank	Team/NOC	Gold	Silver	Bronze	Total	Rank by Total
1	United States of America	8	3	8	19	1
2	Japan	8	2	3	13	4
3	People's Republic of China	7	5	7	19	1
4	ROC	5	7	3	15	3
5	Great Britain	4	5	1	10	5
6	Australia	3	1	3	7	7
7	Republic of Korea	3	0	4	7	7
8	Kosovo	2	0	0	2	17
9	Italy	1	4	4	9	6
10	Canada	1	3	1	5	9
11	France	1	2	2	5	9
12	Hungary	1	1	0	2	17
12	Tunisia	1	1	0	2	17
14	Croatia	1	0	1	2	17
14	Slovenia	1	0	1	2	17
16	Austria	1	0	0	1	31
16	Bermuda	1	0	0	1	31
16	Ecuador	1	0	0	1	31
16	Hong Kong, China	1	0	0	1	31
16	Islamic Republic of Iran	1	0	0	1	31
16	Norway	1	0	0	1	31
16	Philippines	1	0	0	1	31
16	Thailand	1	0	0	1	31
16	Uzbekistan	1	0	0	1	31
25	Netherlands	0	3	0	3	13
26	Brazil	0	2	2	4	11
26	Chinese Taipei	0	2	2	4	11
28	Georgia	0	2	0	2	17
29	Czech Republic	0	1	1	2	17
29	Spain	0	1	1	2	17
29	Indonesia	0	1	1	2	17
29	Serbia	0	1	1	2	17
29	Switzerland	0	1	1	2	17
34	Belgium	0	1	0	1	31
34	Bulgaria	0	1	0	1	31
34	Colombia	0	1	0	1	31
34	Denmark	0	1	0	1	31
34	India	0	1	0	1	31
34	Jordan	0	1	0	1	31
34	Romania	0	1	0	1	31
34	South Africa	0	1	0	1	31
42	Germany	0	0	3	3	13
42	Kazakhstan	0	0	3	3	13
42	Ukraine	0	0	3	3	13
45	Egypt	0	0	2	2	17
45	Mongolia	0	0	2	2	17
45	Turkey	0	0	2	2	17
48	Côte d'Ivoire	0	0	1	1	31
48	Estonia	0	0	1	1	31
48	Israel	0	0	1	1	31
48	Kuwait	0	0	1	1	31
48	Mexico	0	0	1	1	31
48	New Zealand	0	0	1	1	31

Re: rank procedure by total

jimbarbour — Wed, 28 Jul 2021 17:31:10 GMT

What are you asking? Is the code that you have posted not working? If so, can you post the contents of the log using the icon shown in the screen capture, below?

Jim

Re: rank procedure by total

Kurt_Bremser — Wed, 28 Jul 2021 17:36:30 GMT

This identical question has come up here:

https://communities.sas.com/t5/SAS-Programming/Rank-by-total/m-p/757123

Are you by any means an acquaintance of @BrahmanandaRao ?

Re: rank procedure by total

jimbarbour — Wed, 28 Jul 2021 17:50:25 GMT

For starters, you need to correct the Datastep, the one with Datalines in it. The delimiter needs to change from a '/' (forward slash) to '09'x (tab).

Also the numbers that follow the counts need to be eliminated.

input Team_NOC:& $26. Gold 30 Silver 33 Bronze 37;

Such numbers typically are used with fixed position data. You have delimited data. I added "missover" which I typically find to be a good practice -- but it's not strictly speaking necessary here.

In addition, Team/NOC is not a valid SAS V7 name. I changed it to Team_NOC.

Jim

Corrected code:

data olympics;
infile datalines
	dsd dlm='09'x
	missover
	;
/*input Team_NOC:& $26.  Gold 30 Silver 33  Bronze 37;*/
input Team_NOC:& $26.  Gold Silver  Bronze;

*---+----1----+----2----+----3----+----4;
datalines;
United States of America	 8	3	8
Japan						 8	2	3
People's Republic of China	 7	5	7
ROC							 5	7	3
Great Britain				 4	5	1
Australia					 3	1	3
Republic of Korea			 3	0	4
Kosovo						 2	0	0
Italy						 1	4	4
Canada						 1	3	1
France						 1	2	2
Hungary						 1	1	0
Tunisia						 1	1	0
Croatia						 1	0	1
Slovenia					 1	0	1
Austria						 1	0	0
Bermuda						 1	0	0
Ecuador						 1	0	0
Hong Kong, China			 1	0	0
Islamic Republic of Iran	 1	0	0
Norway						 1	0	0
Philippines					 1	0	0
Thailand					 1	0	0
Uzbekistan					 1	0	0
Netherlands					 0	3	0
Brazil						 0	2	2
Chinese Taipei				 0	2	2
Georgia						 0	2	0
Czech Republic				 0	1	1
Spain						 0	1	1
Indonesia					 0	1	1
Serbia						 0	1	1
Switzerland					 0	1	1
Belgium						 0	1	0
Bulgaria					 0	1	0
Colombia					 0	1	0
Denmark						 0	1	0
India						 0	1	0
Jordan						 0	1	0
Romania						 0	1	0
South Africa				 0	1	0
Germany						 0	0	3
Kazakhstan					 0	0	3
Ukraine						 0	0	3
Egypt						 0	0	2
Mongolia					 0	0	2
Turkey						 0	0	2
Côte d'Ivoire				 0	0	1
Estonia						 0	0	1
Israel						 0	0	1
Kuwait						 0	0	1
Mexico						 0	0	1
New Zealand					 0	0	1
;
run;

Re: rank procedure by total

PaigeMiller — Wed, 28 Jul 2021 18:11:28 GMT

@pavank

Please do not post your data using data step code that doesn't work. You can run the DATA step and see if it works. Get the data step code to work properly, and then we can help you. (Although as pointed out, the answer is already provided elsewhere, you still ought to make sure your data step code works before you post it, there's really no excuse for posting DATA step code to provide your data that doesn't work)