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,'.','#');
RTFM. You have the syntax wrong.
street=upcase(compress(street,'.#');
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,'.#');
Excellent. Thank you.
Cool. That's good to know.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.