Formatting a column in Teradata might differ in results with the $BIDI format, depending on where the formatting occurs


Trying to format a column in a Teradata table using the $BIDI format might generate different results. The results vary depending on whether the formatting is done by SAS using the PUT function or done in Teradata using the SAS_PUT function. Some of the known characters that result in a difference include the following:

 

CharacterHEX

PUT

SAS_PUT
<0x3C><
=0x3D=>
>0x3E<=
null0x00blankÿ

 

There is no workaround for the issue.