topic Re: How to read NULL values in flat file (HEX '00' on mainframe) in SAS Programming

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

FollinLane — Fri, 29 Apr 2016 14:32:52 GMT

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 — Fri, 29 Apr 2016 14:38:09 GMT

Hi Use a hex constant like so "00"x

FollinLane — Fri, 29 Apr 2016 14:42:27 GMT

Bruno,

Thank you for your quick response.

I will look up this definition and then try it.

Regards,

FollinLane — Fri, 29 Apr 2016 14:49:32 GMT

Bruno,

It seemed to have worked. Thanks again!