TOP 1

Reply
Contributor
Posts: 21

TOP 1

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

Super User
Super User
Posts: 6,502

Re: TOP 1

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;

Ask a Question
Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation