BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GreggB
Pyrite | Level 9

I'm trying to compress all special characters out of street addresses.  It won't allow me to compress #.  When  I take it out of the statement, it does allow me to compress the periods.  I have other characters such as commas and apostrophes I want to get rid of also.

street=upcase(compress(street,'.','#');

1 ACCEPTED SOLUTION

Accepted Solutions
Doc_Duke
Rhodochrosite | Level 12

RTFM.  You have the syntax wrong.

street=upcase(compress(street,'.#');

View solution in original post

5 REPLIES 5
Doc_Duke
Rhodochrosite | Level 12

RTFM.  You have the syntax wrong.

street=upcase(compress(street,'.#');

ballardw
Super User

Put all of the characters to compress within one set of quotes. The comma between them as you have is trying to interpret the # as a modifier.

street=upcase(compress(street,'.#');

GreggB
Pyrite | Level 9

Excellent.  Thank you.

art297
Opal | Level 21

You might find it even easier if you just KEEP the characters you want.  e.g.,

n or N

adds digits, the underscore character, and English letters to the list of characters.

thus street=compress(street,,'kn) might accomplish everything you want

GreggB
Pyrite | Level 9

Cool.  That's good to know.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1907 views
  • 6 likes
  • 4 in conversation