I work for a lab and I have a dataset which contains lab code string with delimiter "*". I have found that only the first "*" is valid (the othres are typo or not useful) and I would like to remove the rest "*" to clean the data. For example,
I would say find where the first one is, then change them all to spaces, then put the first one back again.
loc= index(string,'*');
string=translate(string,' ','*');
if loc then substr(string,loc,1)='*';
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!