topic Re: Remove letter or number from string by using compress? in SAS Programming

Remove letter or number from string by using compress?

ybz12003 — Wed, 23 Feb 2022 17:58:34 GMT

Hello,

I try to use "compress" to remove the letter or number from the string. Somehow it didn't work. Please let me know how to fix it.

ID_=compress(strip(upcase(ID)),'A0'x);

Below is some sample strings:

BIPAP (BIPHASIC POSITIVE AIRWAY PRESSURE) DEPENDENCE, CHRONIC RESPIRATORY FAILURE
CHRONIC RESPIRATORY FAILURE & VENT/TRACH DEPENDENT

I expect the result is shown below.

Re: Remove letter or number from string by using compress?

PaigeMiller — Wed, 23 Feb 2022 22:23:47 GMT

This is a great situation where you should just look at the documentation. What option of the COMPRESS function removes numbers? What option of the COMPRESS function removes letters?

Documentation: https://documentation.sas.com/doc/en/pgmmvacdc/9.4/lefunctionsref/n0fcshr0ir3h73n1b845c4aq58hz.htm

I'll get you started: remove letters

ID_=compress(strip(ID), ,'a');

I assign you the homework to figure out how to remove numbers.

Re: Remove letter or number from string by using compress?

ybz12003 — Wed, 23 Feb 2022 18:05:34 GMT

The link is not working...

Re: Remove letter or number from string by using compress?

PaigeMiller — Wed, 23 Feb 2022 18:06:38 GMT

Works for me. What error do you get?

Re: Remove letter or number from string by using compress?

ybz12003 — Wed, 23 Feb 2022 18:08:08 GMT

Page Not Found

Re: Remove letter or number from string by using compress?

Tom — Wed, 23 Feb 2022 18:25:36 GMT

But you only asked it to remove that single character with the hexcode of A0.

COMPRESS(source ,< characters> ,< modifier(s)>)

Re: Remove letter or number from string by using compress?

Kurt_Bremser — Wed, 23 Feb 2022 18:27:50 GMT

Works for me also. From where are you accessing the internet? Maybe a badly configured firewall interferes.

Re: Remove letter or number from string by using compress?

ybz12003 — Wed, 23 Feb 2022 19:08:01 GMT

What's X for?

Re: Remove letter or number from string by using compress?

Tom — Wed, 23 Feb 2022 19:20:24 GMT

@ybz12003 wrote:
What's X for?

Why are you asking me? You posted the code:

ID_=compress(strip(upcase(ID)),'A0'x);

This code is requesting that any instances of the character represented by the hexadecimal code A0 be removed. That code is frequently used on Web pages as a non-breaking space so that multiple word phrases are not wrapped in the middle.

The letter X after a quoted string indicts a string literal in hexadecimal notation. Just like the letter D after a quoted string indicates a date literal in a style that the DATE informat can interpret.

Re: Remove letter or number from string by using compress?

ybz12003 — Wed, 23 Feb 2022 20:55:55 GMT

I got the code from the someone else.

Re: Remove letter or number from string by using compress?

ybz12003 — Wed, 23 Feb 2022 21:02:10 GMT

So, it seems like the code below works for the result I want, which needs to have three arguments instead of two.

ID_=compress(strip(upcase(ID_)), , 'A');

But I still don't understand why two arguments are not working.

ID_=compress(strip(upcase(ID_)), 'A');

Re: Remove letter or number from string by using compress?

Tom — Wed, 23 Feb 2022 21:18:19 GMT

The first one is using the modifier A. The second one is just asking to remove the capital letter A.

COMPRESS(source ,< characters> ,< modifier(s)>)

Re: Remove letter or number from string by using compress?

PaigeMiller — Wed, 23 Feb 2022 22:23:22 GMT

Why do you write in your original message about removing numbers, and then give no example where numbers should be removed?

Re: Remove letter or number from string by using compress?

ybz12003 — Thu, 24 Feb 2022 01:25:26 GMT

Because the actual data contain numbers and charater.

Re: Remove letter or number from string by using compress?

PaigeMiller — Thu, 24 Feb 2022 14:11:31 GMT

@ybz12003 wrote:
Because the actual data contain numbers and charater.

So to help all of us in the future, from now on, please give us representative examples that illustrate the ENTIRE problem; in this case, examples involving numbers, and examples involving characters.