What function can fill the partial date and partial datetime

[HannaZhang]

Dears,

   I have a partial date like "2002" ,Is there any function that can fill in "2002" as "2002-01-01"?  And there are similar ones,fill in "2002-01-01T01" as "2002-01-01T01:00"

Thanks

[andreas_lds]

Afaik no such function exists. You could use mdy to create a date when you have the year, only.

[PeterClemmensen · Accepted solution]

For the partial date question, use the B8601DA Informat 

data _null_;
   dt1 = "2002";
   dt2 = input(dt1, B8601DA.);
   put dt2 yymmdd10.;
run;

For the partial datetime question, use the B8601DT informat

data _null_;
   dt1 = "2002-01-01";
   dt2 = input(dt1, B8601DT.);
   put dt2 E8601DT.;
run;

[HannaZhang]

Your solution is very helpful THX!

[PeterClemmensen]

Anytime 🙂

[blueskyxyz]

is there an informat to treat '2017' as '2017-12-31', and treat '2017-06' as '2017-06-30', , and treat '2017-05' as '2017-05-31'?

[Kurt_Bremser]

No. You need to use the INTNX function to get the end date of the respective period.

[blueskyxyz]

ok, thanks, I didn't find such an informat in the book 'The Essential Guide to SAS® Dates and Times, Second Edition'. wish have one informat to impute partial date using different methods in the future...

[HannaZhang]

THX , Draycut found mea way out