topic Re: using letter case changes to delimit a string into new strings in SAS Programming

using letter case changes to delimit a string into new strings

scaldera — Thu, 30 Jan 2014 17:45:34 GMT

How can I break up a string into new string variables using the uppercase letters in the string as the delimiters? For example, I have a name variable that looks like: JohnSmith. I want to transform it into two variables -- first = John, last = Smith. I tried scan (varname, _n_, ' ', ku) but it only returns the upper case letters not the lower case letters following. Thanks!

Re: using letter case changes to delimit a string into new strings

Reeza — Thu, 30 Jan 2014 17:53:49 GMT

What about JohnMcDonald ?

Re: using letter case changes to delimit a string into new strings

Peter_C — Fri, 31 Jan 2014 16:59:13 GMT

although there are sas functions like anylower() and notlower() picking out the case changes sounds more suitable for the prx functions.

good luck

Re: using letter case changes to delimit a string into new strings

art297 — Fri, 31 Jan 2014 17:15:34 GMT

If your names are always like those shown in your example you might be able to use something as simple as:

data have;

input name $30.;

cards;

JonathanSmith

MaryMcDougal

;

data want;

set have;

first=substr(name,1,anyupper(substr(name,2)));

last=substr(name,anyupper(substr(name,2))+1);

run;