Sas Format Date

FORMATTING DATE

The Calendar Dates can be written in various formats .The different operations with dates require conversion of calendar date to sasdate and vice versa.

Calendar Date : Usual date formats (05/14/2005 , May 14,2005 , 14MAY2005 etc. )

Sasdate : Number of days between 01JAN1960 and a specified date.

CONVERT SASDATE TO CALENDAR DATE :

Case I:

Dates are given in this format:

John, 1-Jan-60

Mary, 11-Jul-55

Kate, 12-Nov-62

Mark, 8-Jun-59

SASCODE :

libname trial 'D:DateFormat';

data bdays;

infile 'D:DateFormatsampdata.csv' dsd missover lrecl=20;

input name : $4.

bday : $char12.;

data newdt;

set bdays;

sasdate1=compress(bday,'-');

newdate=input(sasdate1,date9.); /* CREATE SASDATE */

proc print data=newdt;

run;

OUTPUT

Obs name bday sasdate1 newdate

1 John 1-Jan-60 1Jan60 0

2 Mary 11-Jul-55 11Jul55 -1635

3 Kate 12-Nov-62 12Nov62 1046

4 Mark 8-Jun-59 8Jun59 -207

If you don't mention the first two places of the year, by default it takes the nearest one to 1960.

The sasdate ‘newdate' can be converted to different forms of calendar date.

Case II:

SASCODE :

data newdt1;

set newdt;

ndt1=put(newdate,mmddyy8.);

ndt2=put(newdate,mmddyy10.);

ndt3=put(newdate,mmddyy6.);

ndt4=put(newdate,mmddyy7.);

ndt5=put(newdate,date9.);