topic Re: Keep date9. format during if else statement in SAS in SAS Procedures

Keep date9. format during if else statement in SAS

richart — Fri, 04 Feb 2022 22:28:19 GMT

There has to be a simpler solution to this and I am not sure why I'm having so much difficulty. I have two date vars, with date9. format. I simply want to create a new date variable in the same data step based on these two variables, but can't without it converting to numeric (or character if I try and use 'put' statements but then my 'format new_date date9.' step doesn't work . help?

I'm trying:

data data1;
set data;
if date1^='' and date2^='' then new_date=date1;
else if date2='' then new_date=date1;
run;

Re: Keep date9. format during if else statement in SAS

Reeza — Fri, 04 Feb 2022 22:33:13 GMT

What does ' my 'format new_date date9.' step doesn't work' mean?

Post the log.

Since you're using "" to check for missing, that would imply that your date variables are character not numeric and you cannot apply a numeric format to a character variable. In this case you need to also convert the dates to numerics variables.

Is your first condition correct? It checks that both date1 and date2 are not missing and then assigns date1. Then the ELSE checks if DATE2 is missing and assigns Date1? Both essentially assign the Date1 value to DATE.

Also, is this homework? If not use COALESCE/COALESCEC instead.

Re: Keep date9. format during if else statement in SAS

richart — Fri, 04 Feb 2022 22:41:29 GMT

sorry and thanks... I think me forgetting to use . instead of '' for the date vars messed everything up. I now do this and it works:

data data1;
set data;
if date1^=. and date2^=. then new_date=date1;
else if date2=. then new_date=date1;
format new_date date9.;
run;

Re: Keep date9. format during if else statement in SAS

Reeza — Fri, 04 Feb 2022 22:47:55 GMT

Glad it worked and hope that logic is correct.