topic Re: Repace Empty Dates with hardcore date in SAS Programming

Repace Empty Dates with hardcore date

Son_Of_Krypton — Thu, 13 Aug 2020 10:48:09 GMT

i have below table with dates

3	1	3/1/2017	3/1/2017
3	2	3/2/2017	3/2/2017
3	3	3/3/2017
3	4	3/4/2017
3	5	3/5/2017	3/5/2017
3	6	3/6/2017

i want to replace the empty dates with hardcore constant date as '31DEC9999'd

Anyone will help me out there

Re: Repace Empty Dates with hardcore date

PaigeMiller — Thu, 13 Aug 2020 11:03:52 GMT

if missing(date2) then date2='31DEC9999'd;

Re: Repace Empty Dates with hardcore date

Oligolas — Thu, 08 Oct 2020 09:51:43 GMT

Hi,

I think a good hardcore date could be 27th of March 2021 😉

if missing(date2) then date2='27MAR2021'd;

But it could be difficult to justify in clinical trials.

If it's hardcode that you mean then please refer to @PaigeMiller 's answer.

Re: Repace Empty Dates with hardcore date

Kurt_Bremser — Thu, 13 Aug 2020 11:36:40 GMT

Use the COALESCE function:

data have;
input date yymmdd10.;
format date yymmdd10.;
datalines;
2020-08-12
.
;

data want;
set have;
date = coalesce(date,'31dec9999'd);
run;

Re: Repace Empty Dates with hardcore date

ballardw — Thu, 13 Aug 2020 15:19:27 GMT

If the purpose of showing a date of 31DEC9999 is to indicate "missing date" then leave it alone.

What is the complete reason for using a valid date instead of leaving them missing?

You can't model anything with that value, graphs are problematic and statistics like just counting the number of valid dates in your data impossible.

Re: Repace Empty Dates with hardcore date

Kurt_Bremser — Thu, 08 Oct 2020 07:59:33 GMT

Note that if this is to create an artificial "end" date that lies in a far future, SAS functions do not need that if you need to calculate a "real end":

data test;
end_date = .;
real_end_date = min(today(),end_date);
format end_date real_end_date yymmdd10.;
run;