topic is this below code crt as per the question in SAS Programming

is this below code crt as per the question

username12 — Thu, 22 Apr 2021 08:49:22 GMT

sort the input12dataset .First by number in ascending and second by income in descending order.Using input12 dataset with by group processing create test data from the input12 dataset

test 2 dataset must contain only one observation with highest income from each group of distint number value

MY CODE:

proc sort data=input12 out=test;

by number descending income;

run;

data test;

set test;

by number;

if first.number;

run;

Re: is this below code crt as per the question

Oligolas — Thu, 22 Apr 2021 13:45:17 GMT

Works, but I would specify the sorting order in want to make sure

data have;
infile datalines;
input number income;
datalines;
1 100
1 130
1 120
1 110
2 250
2 200
3 300
4 420
4 410
4 430
4 440
4 450
5 530
5 520
5 510
5 500
8 800
;
run;

proc sort data=have out=haves;
   by number descending income;
run;

data want;
set haves;
by number descending income;
if first.number;
run;