topic Re: What function can fill the partial date and partial datetime in SAS Programming

What function can fill the partial date and partial datetime

HannaZhang — Fri, 11 Dec 2020 09:52:56 GMT

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

Re: What function can fill the partial date and partial datetime

andreas_lds — Fri, 11 Dec 2020 09:59:11 GMT

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

Re: What function can fill the partial date and partial datetime

PeterClemmensen — Fri, 11 Dec 2020 10:02:31 GMT

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;

Re: What function can fill the partial date and partial datetime

HannaZhang — Fri, 11 Dec 2020 10:24:02 GMT

Your solution is very helpful THX!

Re: What function can fill the partial date and partial datetime

PeterClemmensen — Fri, 11 Dec 2020 10:25:35 GMT

Anytime 🙂

Re: What function can fill the partial date and partial datetime

HannaZhang — Fri, 11 Dec 2020 10:27:30 GMT

THX , Draycut found mea way out

Re: What function can fill the partial date and partial datetime

blueskyxyz — Sun, 13 Dec 2020 09:33:45 GMT

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'?

Re: What function can fill the partial date and partial datetime

Kurt_Bremser — Sun, 13 Dec 2020 10:02:29 GMT

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

Re: What function can fill the partial date and partial datetime

blueskyxyz — Sun, 13 Dec 2020 14:52:41 GMT

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...