topic treating '-' as part of the word in SAS Programming

treating '-' as part of the word

SAS_inquisitive — Thu, 28 Jan 2016 16:32:48 GMT

The last name from following code is only "Anne". I want "Anne-marie" as last name.

data test;
  name='Jen Anne-marie';
  first_name=scan(name,1);
  last_name=scan(name,2);
run;

Reeza — Thu, 28 Jan 2016 16:35:19 GMT

RTM.

What's the third parameter to the SCAN() function?

mohamed_zaki — Thu, 28 Jan 2016 16:36:25 GMT

data test;
  name='Jen Anne-marie';
  first_name=scan(name,1);
  last_name=scan(name,2," ");
run;

Reeza — Thu, 28 Jan 2016 16:49:35 GMT

Or the 4th parameter.

data test;
  name='Jen Anne-marie';
  first_name=scan(name,1);
  last_name=scan(name,2,,'s');
run;

proc print; run;

SAS_inquisitive — Thu, 28 Jan 2016 17:01:20 GMT

@ Reeza, I wrongly thought space as one of the default delimiters, that's why I did not provide third parameter.

Reeza — Thu, 28 Jan 2016 17:02:29 GMT

It is the default delimiter, but only one of them.