You understood perfectly! Do loop is the best for me. I learned a lot from this code. Thank you! One more question 🙂 How can I check the cases where there are no spaces in the string? For example : Greatdaytest
... View more
Hello! I have two tables with two columns. If the character string of table1 column contains the word in table2 coloum,then I want to delete it from the character string of table1 column. For example: Table 1 column: Table two column: Next day. Day Best day. Great Great day test. The result I would like: Next Best Test What is the best method to do this?
... View more
I have a column in which I want to check the similarity of the values. I want to delete those values whose first 10 characters are the same as the first 10 characters of some other value. I thought I could solve it with two nested loops and a Compare function. But unfortunately it doesn't work. Could someone help me?
... View more
Hello ! I would like to delete all single character (between two spaces)in a column. For example : test h text2 z In this example I would like to delete 'h' and 'z'. Thank you, if you can help me. I use SAS EG 8.2.4.
... View more