Date:         Wed, 16 Nov 2005 18:16:11 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: help with date
Comments: To: raan67@YAHOO.COM
In-Reply-To:  <200511161808.jAGGs1na008405@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

try :

data one (drop = _temp i) ;

do i = 0 to 11 ;
  _temp   = intnx('Month','01jan2005'd,i,'e') ;
   month  = month(_temp) ;
   LastDay = day(_temp)    ;

  output ;
end ;

run ;



Toby Dunn





From: Ran S <raan67@YAHOO.COM>
Reply-To: Ran S <raan67@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: help with date
Date: Wed, 16 Nov 2005 13:08:57 -0500


Toby,
I see that lastday is created and displayed in the log. How can I have
lastday variable created for each month in the table like from jan to dec
something like this:

month lastday
1     30
2     28
3     31
...and so on..