SAS Date Issue

[BrunoD]

Hi,

I'm not familiar with DataStage, actually I'm try to solve a problem.
We have a SAS extract to a dataset that has a date column returning NULL.
This parallel task used to work fine.
Is there a way to check if SAS is generating NULL value? I've already checked to my SAS's team, they say that nothing has chanced there. I'm trying to check my locale settings too.

I'm sorry if this is a basic question, I'm pretty new to this world.

Thanks.

[chulett]

This parallel task used to work fine.

However, you haven't told us what is happening, what exactly is no longer working fine? What error are you seeing?

[qt_ky]

You can use null handling functions like IsNull() in a Transformer stage to check.

[BrunoD]

Actually it's not an error, it just a SAS' date field returning NULL where should return a value.

[ray.wurlod]

Are you performing a lookup against the SAS data set? All columns on the reference link are set to null if the row in question is not found by the lookup operator and the "failed lookup" rule is set to "Continue".