Coonvert PD to Julian date format in SAS

piglet · New User Joined: 05 Sep 2006 Posts: 6

Is there a way to convert a packed decimal format date into Julian Date?

I need to convert the value below 20061208 into a date format that SAS can understand.

Alan Voss · Posted: Fri Dec 15, 2006 1:11 am

data dates;
infile dates;
input @1 pd_dt pd5.;
sas_dt = input(put(pd_dt,z8.),yymm8.);
format sas_dt yymmdd10.;
diff = today()-sas_dt;
run;

proc print data=dates;
run;

piglet · New User Joined: 05 Sep 2006 Posts: 6

Thanks for your help!

This worked beautifully!