advanced expression, want date or blank

maliksmom2000 — Mon, 14 Jan 2019 07:36:07 GMT

I am trying to return an actual date or if date is missing I want a blank or even a 0. It's returning the actual date or 1/1/1960

Here is my expression: ifn(t1.GNN_MSAI_ANCHOR_DT is missing, t1.Final_Anchor, t1.GNN_MSAI_ANCHOR_DT,0)

How do I change it so that it only returns the actual date or missing value as blank or 0?

**I should note the formula works and returns the date in sas date format (19844, etc.). I get the 1/1/1960 when I try to change the format....MMDDYYw.d.

THANK YOU!!!!!

Re: advanced expression, want date or blank

Kurt_Bremser — Mon, 14 Jan 2019 10:08:57 GMT

The raw value of 0 (zero) in a SAS date IS 1960-01-01, as that is the zero days for SAS date values. See About SAS Date, Time, and Datetime Values.

A SAS date value is never "zero"; it can be a displayable date, missing, or a non-displayable value (too far back in history or too far in the future).

topic advanced expression, want date or blank in New SAS User

advanced expression, want date or blank

Re: advanced expression, want date or blank