SAS Enterprise 2 Columns - using advanced expression to bring over date - Help Please

maliksmom2000 — Tue, 15 Jan 2019 06:10:39 GMT

I have two columns. One has a code for inspections, the second has the dates of the inspections. If the code is CM then I want it to return the date, if not I want it to be blank.

I don't know what to put in the "XXX" below so it returns a blank. I know it's not "" as it is a numeric expression and I know not to put a 0 or 1. I'm sorry I can't seem to get this one down.

ifn(t1.MSAI_STAT_CD="CM", t1.MSAI_STAT_DT, XXX)

Re: SAS Enterprise 2 Columns - using advanced expression to bring over date - Help Please

Reeza — Tue, 15 Jan 2019 06:44:35 GMT

A period is the symbol for numeric missing values, no quotes.

In SQL it’s more conventional to use CASE statements instead of IFN. For one, if you or someone ever needs to migrate this to a different SQL implementation this makes it much easier.

@maliksmom2000 wrote:

I have two columns. One has a code for inspections, the second has the dates of the inspections. If the code is CM then I want it to return the date, if not I want it to be blank.

I don't know what to put in the "XXX" below so it returns a blank. I know it's not "" as it is a numeric expression and I know not to put a 0 or 1. I'm sorry I can't seem to get this one down.

ifn(t1.MSAI_STAT_CD="CM", t1.MSAI_STAT_DT, XXX)

topic SAS Enterprise 2 Columns - using advanced expression to bring over date - Help Please in New SAS User

SAS Enterprise 2 Columns - using advanced expression to bring over date - Help Please

Re: SAS Enterprise 2 Columns - using advanced expression to bring over date - Help Please