How to get only the last row

[timppap]

How I can get only the last from A and B or several more ?

Name Dateperiod
A 200301
A 200901
A 201001
B 200801
B 200901
B 201001


I want only
A 201001
B 201001

Thanks!

 

[kdt82]

Try using last.

data have ;
   input name :$1. dateperiod :$6. ;
cards ;
A    200301
A    200901
A    201001
B    200801
B    200901
B    201001
;;;;;

data want ;
   set have ;
   by name notsorted ;
   if last.name ;
   run; 
proc print;run;

 

[sasbobi]

try to use @ Column option to read 201001 or # to read the observation wise

 

[timppap]

Hi ! Would You give an examble so I understand !

Thanks !