sas dataflux query

sne7189 — Thu, 05 Feb 2015 05:21:54 GMT

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

Re: sas dataflux query

skillman — Thu, 05 Feb 2015 15:39:34 GMT

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)

topic sas dataflux query in SAS Programming

sas dataflux query

Re: sas dataflux query