topic remove bad data from a variable in New SAS User

remove bad data from a variable

animesh123 — Thu, 27 Feb 2025 13:28:34 GMT

Hi I want remove a bad data from a variable . so inthis obs between nicolas and 84989 there is a small icon am trying to remove that using sas in linux environment

I tried to do the same in sas eg using

APPLCNT_CMT_TX=compress(APPLCNT_CMT_TX,'');

this is working but in linux environement the same is now working

Re: remove bad data from a variable

Tom — Thu, 27 Feb 2025 13:47:25 GMT

In general I find it is better to write non 7-bit ASCII strings as HEX literals in the SAS code. That way the code works the same if you change the encoding setting you are running with.

So LOOK at the hex codes for the character by using the $HEX format.

Then write the code using the hexcode.

For example if that "box" is was just the hex code '0A'x (which is actually a linefeed) then you might use

APPLCNT_CMT_TX=compress(APPLCNT_CMT_TX,'0A'x);

If the goal is to only keep normal characters then use the K modifier on the COMPRESS() function call to say that the list of characters are those that should be KEPT instead the default action of removing the listed characters. You can use COLLATE() to generate all of the printable 7-bit ASCII characters.

APPLCNT_CMT_TX=compress(APPLCNT_CMT_TX,collate(32,126),'K');

Re: remove bad data from a variable

PaigeMiller — Thu, 27 Feb 2025 13:49:10 GMT

@animesh123 wrote:

Hi I want remove a bad data from a variable . so inthis obs between nicolas and 84989 there is a small icon am trying to remove that using sas in linux environment

I tried to do the same in sas eg using

APPLCNT_CMT_TX=compress(APPLCNT_CMT_TX,'');

this is working but in linux environement the same is now working

is this a one-time need to remove just one character from this string? Or in a larger data set do possibly other characters appear depending on the string that you want to remove?

Re: remove bad data from a variable

animesh123 — Thu, 27 Feb 2025 13:55:42 GMT

APPLCNT_CMT_TX=compress(APPLCNT_CMT_TX,'');
want to remove only this

Re: remove bad data from a variable

Tom — Thu, 27 Feb 2025 14:24:08 GMT

@animesh123 wrote:
APPLCNT_CMT_TX=compress(APPLCNT_CMT_TX,'');
want to remove only this

And WHAT character is that exactly?

When I try to copy and paste from your post here into SAS editor it just ends up as the '1A'x character.

Which is just what SAS puts when it does not know how to transcode a character.

If that is the actual character you have then why does this forum display it as a box with an X in it when SAS and WORD display it as just an empty box?

WORD Example: