industry |
ashok industries pvt ltd |
sai industries limited |
a&b&c industries Ltd. |
x&y&z industries ltd |
chaitinya industries Pvt. Ltd. |
(sathya sai industries) Co.Ltd |
sai harsha industries (Pvt.Ltd) |
if you observe above dataset every record has one extenstion name like 'pvt ltd', 'ltd','limited' so
how can we remove that extenstion name and '%' like see beow dataset
industry |
ashok industries% |
sai industries% |
a&b&c industries% |
x&y&z industries% |
chaitinya industries% |
(sathya sai industries)% |
sai harsha industries% |
Readability of code is only one reason we have pointed out that code should be pasted into a code box opened with the forum's {I} or "running man" icon.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.