topic Re: I want to strip special characters from SAS data in SAS Programming

I want to strip special characters from SAS data

deleted_user — Fri, 08 May 2009 19:16:20 GMT

I have a SAS dataset that has a variable that contains carriage returns, line feeds, and form feeds. I want to remove these without affecting any other data. I tried the COMPRESS function with the "s" modifier but I also removed blanks.....which is not good. Any ideas on how to remove just the three types of characters I mentioned? Thanks in advance.

Re: I want to strip special characters from SAS data

sbb — Fri, 08 May 2009 19:58:11 GMT

Suggest you share the exact SAS code used with COMPRESS - I would expect you might check TRANSLATE as well. Post the code and the related SAS log output info to your post with a pasted reply - consider adding some PUTLOG command logic with a hex-format output display to confirm the BEFORE / AFTER (new variable assignment) -- should help with your self-diagnosis desk checking.

Scott Barry
SBBWorks, Inc.

Re: I want to strip special characters from SAS data

sfleming — Mon, 11 May 2009 16:52:11 GMT

I think you might need the 'c' modifier instead of the 's' modifier. See http://www2.sas.com/proceedings/sugi31/028-31.pdf for more on using the compress function.

Re: I want to strip special characters from SAS data

deleted_user — Mon, 11 May 2009 18:53:11 GMT

Thanks to both of you. I'm deciding between both of these options. I just need to determine if I want remove the characters or replace them with something else....like a space for ease of readability.

Re: I want to strip special characters from SAS data

agdesilva — Tue, 12 May 2009 23:40:03 GMT

I would also suggest rank() and byte() functions.