topic Re: keeping only one value in SAS Programming

keeping only one value

kindbe17 — Mon, 08 May 2023 07:48:03 GMT

Could you please help me to keep only first value "David" from the data, using if last if first,

data readin;
input ID Name $ Score;
cards;
1 David 45
1 David 74

1 David 77
;
run;

PeterClemmensen — Mon, 08 May 2023 07:53:58 GMT

data readin;
input ID Name $ Score;
cards;
1 David 45
1 David 74
1 David 77
;
run;


data want;
   set readin;
   by Name;
   if first.Name;
run;