Break into first name, middle name, last name

Discussion in 'SAS (Statistical Analysis Software)' started by Pareen Patel, Jan 15, 2009.

  1. Pareen Patel

    Pareen Patel Guest

    I am trying to break this name in first name, middle name, last name.

    Mark shipton
    chris a chia
    d brookford
    sim e petal

    I am trying to use scan function.

    first = scan(name,1,' ');
    last name = scan(name, -1, ' ');

    what function should i use to get those middle name as 2 of name contains
    middle intials and 2 of them are blank.
     
    Pareen Patel, Jan 15, 2009
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.