Good day , I have a question related to possible solution on how to work with values collected from one multi picklist variable. The spssinc trans function with split formula is great solution, however it creates a problem, unless i am not aware of the solution. Please see below my example.
In the System , the values with semicolon listed initially in one field for each client.
|
Source of Income
|
Client
|
|
Benefit ; EI ; CERB
|
1
|
|
EI ; Support ; Benefit
|
2
|
|
Support; CERB; EI
|
3
|
Applied spssinc trans syntax , created 3 Variables from one main variable as below.
|
Source 1
|
Source 2
|
Source 3
|
Client
|
|
Benefit
|
EI
|
CERB
|
1
|
|
EI
|
Support
|
Benefit
|
2
|
|
Support
|
CERB
|
EI
|
3
|
As you could see from table 2 above, Source 1 and Source 2 and Source 3 might contain the same value responses. What will be the solution, while creating new variable name it as picklist and then populate the responses into variables created as in example below
|
Source Benefit
|
Source EI
|
Source CERB
|
Source Support
|
Client
|
|
1
|
1
|
1
|
0
|
1
|
|
1
|
1
|
0
|
1
|
2
|
|
0
|
1
|
1
|
1
|
3
|
Or if there is an alternative way to evaluate the variable Source 1 , Source 2, Source 3
Your input is highly appreciated
Thanks
------------------------------
Kamal
------------------------------
#SPSSStatistics