Date: Fri, 1 Jul 2005 20:18:49 +0000
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ian Whitlock <iw1junk@COMCAST.NET>
Subject: Re: correcting incorrect dates using sas
Assuming a mistake for 10oct2010 (otherwise give details), in version 9
intnx ( "year" , date1 , -100 , "s" )
would do the job. If you must run in version 8, I presented a
macro at SESUG 1999 that acts like a function and does the same
job. If you want the macro contact me. However, I will be going
on vacation starting tomorrow for a week, so you will have to
contact me today or wait.
Warning: In both cases 29feb2000 is converted to 28feb1900
Date: Fri, 1 Jul 2005 10:39:20 -0700
Sender: "SAS(r) Discussion"
Subject: correcting incorrect dates using sas
Comments: To: sas-l
Content-Type: text/plain; charset="iso-8859-1"
i have a dataset in which a date field exists which is off by 100
years..the month and day are correct, but what should be 1914 for
example is 2014..below please find an example...
input date1 date9.;
the result i would like to see for date1 would be
any suggestions for a simple solution to correct the dates?