Update missing value using Proc SQL

deleted_user — Fri, 14 Aug 2009 15:32:33 GMT

I have a date column in the SAS dataset. The date column contains missing values. I am trying to update the missing values with a default date, see the coding below:

update vte0813_1
set dateout = input("9/30/2008",datetime20.)
where dateout = " .";

The value in the date column looks like " 24FEB2005:00:00:00" (type=numeric).

I am getting the following error message when I run the code:

"ERROR: Expression using equals (=) has components that are of different data types."

I could not figure out what went wrong?

Thank you.

Re: Update missing value using Proc SQL

Flip — Fri, 14 Aug 2009 18:21:50 GMT

set dateout = input("9/30/2008:00:00:00",datetime20.)

You just have the date.

Re: Update missing value using Proc SQL

SUN59338 — Fri, 14 Aug 2009 18:22:24 GMT

where dateout=.

Or you may like use:

where missing(dateout)

topic Re: Update missing value using Proc SQL in SAS Procedures

Update missing value using Proc SQL

Re: Update missing value using Proc SQL

Re: Update missing value using Proc SQL