Hi everyone,
Is anyone can help me to remove a special character from a variable regardless of its order in the variable.
here is the example:
what I have:
id Mesure
10/5201 0.012
10/6522 0.452
306/312 1.003
AC115/9 0.855
what I want (just delete the slash)
id Mesure
105201 0.012
106522 0.452
306312 1.003
AC1159 0.855
My database contains more than a million ids that contain special characters (/, -,*,.) that I just want to search for and remove them by keeping the other characters.
Thank you for your help.
Use the COMPRESS function
As I understand I have to put this code:
data want;set have;
id=compress(id, '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', 'k');
run;
is this true?
No. Read the documentation, all you need is:
id=compress(id, '/');
Yes, it works well. tank you.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.