topic Re: SAS Enterprise guide 7.1: advanced Expression error (Case When) in SAS Enterprise Guide

SAS Enterprise guide 7.1: advanced Expression error (Case When)

drawerder — Mon, 15 Apr 2019 05:21:20 GMT

Hello, Am trying to do a new computed column by advanced expression after doing an outer join:

" case when t1.'Claim No'n = "" then t2.'Claim No'n else t1.'Claim No'n end " where am asking it to find the value from the first table and if it is blank then take it from the second table.

The thing is it works for variable types that are string, once i tried to use it for Dates or numbers it gave the error message:

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

Please Advice, thanks

Re: SAS Enterprise guide 7.1: advanced Expression error (Case When)

SASKiwi — Mon, 15 Apr 2019 05:36:57 GMT

Try a dot instead of quotes - dot is a missing numeric constant, quotes mean a missing character constant:

case when t1.'Claim No'n = .

Re: SAS Enterprise guide 7.1: advanced Expression error (Case When)

drawerder — Mon, 15 Apr 2019 06:00:42 GMT

Dear SASKIWI,

Thanks for your reply, it worked fine with the numeric type. can u advise on what should i use for a date instead of the ( " " or . )

regards,

Re: SAS Enterprise guide 7.1: advanced Expression error (Case When)

SASKiwi — Mon, 15 Apr 2019 07:08:27 GMT

Dates in SAS are stored as numbers - the number of days after 1 Jan 1960. So a dot works equally well as a constant for checking missing dates.

Re: SAS Enterprise guide 7.1: advanced Expression error (Case When)

FredrikE — Mon, 15 Apr 2019 07:14:04 GMT

I have begun to use function missing() instead:

case when missing(t1.'Claim No'n) then t2.'Claim No'n else t1.'Claim No'n end

//Fredrik