Date:         Fri, 5 Dec 2008 10:25:40 +0000
Reply-To:     karma <dorjetarap@GOOGLEMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         karma <dorjetarap@GOOGLEMAIL.COM>
Subject:      Re: manipulating data
Comments: To: hd <heenagd@gmail.com>
In-Reply-To:  <67e970e3-ecb5-41de-982c-2fb13990fd37@t26g2000prh.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Here's another sugestion, if the last date also happens to be the max
date of the group

proc sql;
   create table want as
      select max(date) format=mmddyy10.
      from have group by month(date);
   quit;

2008/12/4 hd <heenagd@gmail.com>:
> Does anyone know how I can pick out the last date in a month from a
> table?
>
> example:
> I have the column date
> date
> 01/15/2008
> 01/17/2008
> 01/26/2008
> 02/01/2008
> 02/05/2008
> 02/25/2008
>
> It should pick out
> newdates
> 01/26/2008
> 02/25/2008
>
> Thanks for your help
>