Date: Tue, 4 Aug 1998 11:47:25 -0400
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
Subject: Re: Character to date (Thanks)
First, thanks to all who responded to me privately or on the list.
Very helpful answers (though diverse.) Just FYI, the way I approached
NewYr = Substr(My yyyymmdd Varible,3,2) ;
NewMo = Substr(My yyyymmdd Varible,5,2) ;
NewDy = Substr(My yyyymmdd Varible,7,2) ;
***days since yyyymmdd upto 8/4/98*****;
Days = 365*(98 - NewYr) + 30*(8 - NewMo) + (4 - NewDy) ;
I thought there ought to be a more efficient way as your messages
proved that. I'm not sure which one will be more accurate (with some
months 28,29,30,or 31 days.)
I hope someone will help me woth this.
I have a variable which is character of the form yyyymmdd where yyyy
is the year, mm is the month and dd is the day (e.g. 19970603 for June
3, 1997.) I want to calculate the time between that date and today's
date. What is the best way to do that? How to convert that character
variable to date of the form yymmdd (or other format: ddmmyy)?
Thanks for your help.