topic Re: How do I Identify/Sum the THREE highest values in SAS Programming

How do I Identify/Sum the THREE highest values

Bree_Anderson — Tue, 11 Oct 2016 07:07:58 GMT

Reeza — Sat, 08 Oct 2016 23:07:24 GMT

Are you summing based on rows or columns? It's not clear. Please post what your output would be for sample data and the code you have so far.

Bree_Anderson — Tue, 11 Oct 2016 07:08:23 GMT

Reeza — Sat, 08 Oct 2016 23:49:21 GMT

You need some basic array processing.

1. Declare an array

array ais(*) abd_ais ext_ais .... ; *list of ais vars;

2. Set to 75 if necessary.

If max(of ais(*))>5 then iss=75;

3. Else sure the 3 largest values - Use LARGEST() function.

else iss = largest(1, of ais(*))**2 + largest(2, of ais(*))**2 + largest(3, of ais(*))**2;