Date: Tue, 15 Apr 1997 09:51:55 +0000
Reply-To: tpayne@SPS-UK.CO.UK
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Tony Payne <tpayne@SPS-UK.CO.UK>
Subject: SASTip: Y2K-Converting two to four figure years
Content-Type: text/plain; charset=ISO-8859-1
Rather than just using:
year=year+1900;
or similar, the formula:
year=YEAR(MDY(1,1,year));
can be used to convert two figure years into four figure years.
This uses YEARCUTOFF logic to do the conversion. Also, if your data
contains any four figure years, they are left intact.
|