topic Re: How to remove all text before or after a specific character, e.g., all text after a comma in SAS Programming

How to remove all text before or after a specific character, e.g., all text after a comma

Emma_at_SAS — Thu, 22 Dec 2022 17:49:27 GMT

For a variable, I want to remove all text after a question mark (?) and for another variable, I want to remove all text before a space ( ). I know how to do it in Excel like the following note for a comma, for example. But I do not know that in SAS. Thanks for your help

https://www.extendoffice.com/documents/excel/1783-excel-remove-text-before-character.html

Re: How to remove all text before or after a specific character, e.g., all text after a comma

PaigeMiller — Thu, 22 Dec 2022 18:11:51 GMT

What SAS interface are you talking about? Base SAS? SAS Enterprise Guide? Something else?

Re: How to remove all text before or after a specific character, e.g., all text after a comma

Emma_at_SAS — Thu, 22 Dec 2022 18:33:50 GMT

I use SAS 9.4 for windows. Does this answer your question?

Re: How to remove all text before or after a specific character, e.g., all text after a comma

PaigeMiller — Thu, 22 Dec 2022 18:48:42 GMT

Yes, that's it. But now I'm confused, I don't think the Find and Replace dialog box in SAS 9.4 matches what is shown at that link, so I still don't know how to answer the question.

Re: How to remove all text before or after a specific character, e.g., all text after a comma

Emma_at_SAS — Thu, 22 Dec 2022 18:51:16 GMT

I am looking for a line of code or SAS syntax that can do a similar data cleaning for me in SAS. Currently, I have to send my data to Excel, do this step, and read it again in SAS. I want to be able to do this in SAS. Thanks

Re: How to remove all text before or after a specific character, e.g., all text after a comma

PaigeMiller — Thu, 22 Dec 2022 19:07:25 GMT

@Emma_at_SAS wrote:

I am looking for a line of code or SAS syntax that can do a similar data cleaning for me in SAS.

To remove text before a blank space

want1 = substr(text_string1, find(text_string1,' ')+1);

Remove text after a question mark

want2 = scan(tex_string2,1,'?');

Re: How to remove all text before or after a specific character, e.g., all text after a comma

Tom — Thu, 22 Dec 2022 19:50:23 GMT

Are you asking about how to edit your program? If so then what is the use case where it makes any sense to try to automatic modifying code in that way?

If not then why are you talking about a GUI tool like the find/replace tool of Excel?

If you are talking about modifying data then just use CODE to make the changes.

SCAN() is useful for finding text up to particular character.

beginning=scan(string,1,',');

Note that if the string does not have any commas then you get the whole string.

For finding text after a character you probably want to use FIND() or INDEX() to locate the first occurence of the character and then use SUBSTR().

ending=substr(string,index(string,',')+1);

Again if there are no commas then it will return the whole string.

Re: How to remove all text before or after a specific character, e.g., all text after a comma

Emma_at_SAS — Thu, 22 Dec 2022 19:59:34 GMT

Thank you @PaigeMiller and @Tom for taking the time to check my question. Your suggestions for using substr and scan does exactly what I was looking for. Thanks!