topic Re: sas mainframe in SAS Programming

sas mainframe

rohitkrishna — Mon, 08 Apr 2019 14:32:48 GMT

Hi all,

I'm facing some problems while running the sas mainframe code,

{ i want to bypass the null value in exsisting sas output }

that was the major task for me get out off it kindly help me to find the solution, below i mention the code kindly go through on it

quote(trim (left(translate(state_cmts,' ','00'x) ))) || delimtr || { that was the one input sas code to be in a qoute and with pipe delimter

and the output value is ++++++++{|" Next: Short End Dated."|}+++++++++

in browsing mode it shows like this ++++++++++++{|".Next: Short End Dated."|} what i'm asking is how do i remove the dot befor the NEXT string kindly explay it

Thanks & Regards

N muralikrishna

Re: sas mainframe

Kurt_Bremser — Mon, 08 Apr 2019 15:15:20 GMT

The dot most probably means that there is a non-displayable character in the data (aside from the hex zero you already replace).

Re: sas mainframe

Shmuel — Mon, 08 Apr 2019 15:43:02 GMT

If your data is a text file (using infile ...) just browse it as hex data.

If it is a variable in sas dataset use PUT(var, $HEXdd.) where dd is at least double length of var.