topic SAS date in SAS Programming

SAS date

bbortey — Wed, 05 Sep 2018 19:20:32 GMT

Hi guys,

I have converted a character variable to sas date for calculation.

After conversion I realized some future dates for instance '2Oct2027' is being converted to '2Oct 1927' instead. Please how do I correct such an error to reflect the correct sas date of '2Oct2027'.

thank you.

Re: SAS date

PeterClemmensen — Wed, 05 Sep 2018 19:29:28 GMT

Are you sure you converted the character expression to an actual SAS date? Show us your code.

Re: SAS date

bbortey — Wed, 05 Sep 2018 19:36:16 GMT

Format CO_BORR_DOB $10.

CO_BORR_DOB1=input(CO_BORR_DOB ,date9.)

format CO_BORR_DOB1 date9.

the above is the code. The 'CO_BORR_DOB is character variable converted to numeric variable in step 2.

Re: SAS date

PeterClemmensen — Wed, 05 Sep 2018 19:42:17 GMT

Works for me?

data test;
   CO_BORR_DOB='2Oct2027';
   CO_BORR_DOB1=input(CO_BORR_DOB ,date9.);
   format CO_BORR_DOB1 date9.;
run;

proc print data=test;
run;

Re: SAS date

ballardw — Wed, 05 Sep 2018 21:12:02 GMT

@bbortey wrote:

Hi guys,

I have converted a character variable to sas date for calculation.

After conversion I realized some future dates for instance '2Oct2027' is being converted to '2Oct 1927' instead. Please how do I correct such an error to reflect the correct sas date of '2Oct2027'.

thank you.

What you say is quite likely related to the use of two-digit years some where. Depending on the value of your option YEARCUTOFF a two-digit year is assumed to be in 1900's if the value is less.

Run this code snippet:

proc options option=yearcutoff;run;

and see if the log shows something like:

 YEARCUTOFF=1926   Specifies the first year of a 100-year span that is used by date informats and
                   functions to read a two-digit year.

or any value smaller than 1927.

The solution, depending on your range of dates may be to set the YEARCUTOFF later than your problem year.

OR provide examples of the actual original character values and the code you used to do the conversion.

For instance when I run this code:

data example;
   x='02OCT27';
   /* my yearcutoff is 1926 which I believe is the current default for 
   SAS 9.4*/
   y=input(x,date7.);
   format y date9.;
run;

The Y value is 02OCT1927.