If the existence of a comma always means that the word on the left of the comma is the lastname and the word on its right side is the first name, than it is easy to extract first- and lastname.
untested:
if index(raw, ",") > 0 then do;
Forename = scan(raw, 2, ",");
Surname = scan(raw, 1, ",");
end;
else do;
Forename = scan(raw, 1, " ");
Surname = scan(raw, 2, " ");
end;
... View more
