TOP 1

wrosario — Fri, 14 Feb 2014 13:23:31 GMT

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

Re: TOP 1

Tom — Sat, 15 Feb 2014 03:09:19 GMT

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;