Hi @abx and welcome to the SAS Support Communities!
@abx wrote:
I currently learning SAS and would like to know if anyone is able to help out on the codes ...
Actually, before we get to the code, we would need a hard and fast rule to be applied to the strings. Otherwise, we might suggest something like this ...
data have;
input name $80.;
cards;
John Smith John Smith
Jane Foster Jane Foste
Happy Garden Management Corporation Happy Garden Management C
ABC Car Workshop ABC Car Worksho
;
data want(keep=name);
set have;
do i=2 to countw(name, ' ');
call scan(name, i, pos, len, ' ');
if trim(substr(name, pos)) =: name then do;
name=substr(name, 1, pos-1);
leave;
end;
end;
run;
... and then you come up with example strings like "KSU, Manhattan, KS" where you don't want to cut off the abbreviation at the end.
But maybe there is no such problematic case in your data and the code above works for you.
