How to read NULL values in flat file (HEX '00' on mainframe)

[FollinLane]

Hi,

I am trying to process a flatfile on the mainframe (z/os) and would like to know how I can read the NULL values so I can delete unwanted data lines. 

EX:

DATA TEMP;

  SET TEMP;

  IF SUBSTR(STRING,60,1) = "NULL" then delete;

Thank you.

[BrunoMueller]

Hi Use a hex constant like so "00"x

See also SAS Constants in Expressions

Bruno

[FollinLane]

Bruno,

Thank you for your quick response.

I will look up this definition and then try it.

Regards,

[FollinLane · Accepted solution]

Bruno,

It seemed to have worked.  Thanks again!