TOP 1

[wrosario]

Somehow hesitate to make a top Component 1 using the sas? I would like to do without having to use a proc.

example:

name         date                    value

joão          19/01/2014           35

marcos      20/01/2014          26

paulo         21/12/2013          10

roberto      10/12/2013          15

joão          11/12/2013          25

marcos      10/02/2014          15

Result

name         date                    value

joão          19/01/2014           35

paulo         21/12/2013          10

roberto      10/12/2013          15

marcos      10/02/2014          15

the top 1 would be the date, so would make an order by date and bring only the first record

Tks for all,

William

[Tom]

The normal way to do this in SAS is to use FIRST. processing.

data want ;

  set have ;

   by date ;

   if first.date ;

run;

You will need to sort the data first (or have it indexed).

Another work around is to use the NODUPKEY option on PROC SORT.

proc sort data=have out=want nodupkey ;

  by date;

run;