DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

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

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.


Accepted Solutions
Solution
‎05-04-2016 09:56 AM
Occasional Contributor
Posts: 16

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

Posted in reply to FollinLane

Bruno,

 

It seemed to have worked.  Thanks again!

 

 

View solution in original post


All Replies
SAS Super FREQ
Posts: 708

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

[ Edited ]
Posted in reply to FollinLane

Hi Use a hex constant like so "00"x

 

See also SAS Constants in Expressions

 

Bruno

 

 

Occasional Contributor
Posts: 16

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

Posted in reply to Bruno_SAS

Bruno,

 

Thank you for your quick response.

 

I will look up this definition and then try it.

 

Regards,

Solution
‎05-04-2016 09:56 AM
Occasional Contributor
Posts: 16

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

Posted in reply to FollinLane

Bruno,

 

It seemed to have worked.  Thanks again!

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 488 views
  • 0 likes
  • 2 in conversation