sas mainframe

[rohitkrishna]

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

[Kurt_Bremser]

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

[Shmuel]

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.