topic Extracting word(s) before comma delimiter in SAS Programming

Extracting word(s) before comma delimiter

wernie — Tue, 28 Apr 2020 15:19:23 GMT

I need to extract words before a delimiter (comma) and can't figure out how to do it. In some cases it's one word and in other cases it's more than one word.

For example, I have:

Clay County, AL

Clark County, AL

La Paz County, AZ

Santa Cruz County, AZ

So for each of those, I want to extract all of the words before the comma. Thanks!

Re: Extracting word(s) before comma delimiter

novinosrin — Tue, 28 Apr 2020 15:22:30 GMT


data have;
input words $30.;
cards;
Clay County, AL
Clark County, AL
La Paz County, AZ
Santa Cruz County, AZ
;

data want;
 set have;
 want=scan(words,1,',');
run;

Re: Extracting word(s) before comma delimiter

ballardw — Tue, 28 Apr 2020 15:27:03 GMT

One way:

data example;
   set have;
   city = scan(variable,1,',');
   state= scan(variable,2,',');
run;

SCAN function will extract "words" from a variable, with the number 1,2, 3 etc indicating which "word" and the last parameter is delimiter character(s). By default the function would use space and a few other characters but you can limit to a single delimiter character by specifying in the third position.

You did not mention the name of your existing variable so...

If you know how long you want the resulting variable to be then best is to provide a LENGTH statement before extracting. Otherwise the variables are likely to inherit the length of the source variable which may lead to wasted disk space use.

Re: Extracting word(s) before comma delimiter

sdhilip — Tue, 28 Apr 2020 23:39:18 GMT


data have;
input text$30.;
datalines;
Clay County, AL
Clark County, AL
La Paz County, AZ
Santa Cruz County, AZ
;
run;

data want (drop= text);
set have;
City = scan(text, 1, ',');
State = scan(text, 2, ',');
run;