sas dataflux query

[sne7189]

hi all i have a name column where there are names of people who have opened a account in the respective bank.i would like to add a column where if people have added two names separated by comma or & to recognise them as joint account holders

please guide me to do this in sas dataflux

[skillman]

You can do this in an expression node. Assuming the account name field is named input_name:

/*Pre Expression */

string account_name_1

string account_name_2

hidden integer cnt

cnt = 0

/*Expression*/

if instr(`input_name`, ',') > 0 or instr(`input_name`, '&') > 0

  begin

  if instr(`input_name`, ',') > 0

  cnt = parse(`input_name`, ',', account_name_1, account_name_2)

  else

  cnt = parse(`input_name`, '&', account_name_1, account_name_2)

  end

else

begin

  account_name_1 = `input_name`

  account_name_2 = null

end

account_name_1 = trim(account_name_1)

account_name_2 = trim(account_name_2)