treating '-' as part of the word

[SAS_inquisitive]

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]

RTM.

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

http://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#p0jshdjy2z9...

[mohamed_zaki · Accepted solution]

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

[Reeza]

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]

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

[Reeza]

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