I am using -tabsplit- to try and create dummy variables from a multi-selection string variable, "features". The variable "features" lists up to 11 features separated by commas (e.g. "P2P, Bill payment, Merchant payment, Link to other banking products, Other bulk payment, Airtime top up"). I am using the following code to try and create the dummy variables:
tabsplit features, sort p(,) gen(feature_)
The output is the following:
Parts Freq. Percent Cum.
P2P 268 17.54 17.54
Airtime top up 240 15.71 33.25
Bill payment 219 14.33 47.58
Merchant payment 166 10.86 58.44
Cash out 157 10.27 68.72
Cash in 153 10.01 78.73
Other bulk payment 128 8.38 87.11
International remittances 89 5.82 92.93
Link to other banking products 53 3.47 96.40
Loan disbursement or repayment 24 1.57 97.97
G2P 20 1.31 99.28
Mobile microinsurance 11 0.72 100.00
Total 1,528 100.00
11 variables are created: feature_1 - feature_11. Unfortunately, feature_1 - feature_11 are empty string variables. I would have expected feature_1 - feature_11 to be filled with the respective spring 'splits'.
Thanks for your help!
-Kyle
tabsplit features, sort p(,) gen(feature_)
The output is the following:
Parts Freq. Percent Cum.
P2P 268 17.54 17.54
Airtime top up 240 15.71 33.25
Bill payment 219 14.33 47.58
Merchant payment 166 10.86 58.44
Cash out 157 10.27 68.72
Cash in 153 10.01 78.73
Other bulk payment 128 8.38 87.11
International remittances 89 5.82 92.93
Link to other banking products 53 3.47 96.40
Loan disbursement or repayment 24 1.57 97.97
G2P 20 1.31 99.28
Mobile microinsurance 11 0.72 100.00
Total 1,528 100.00
11 variables are created: feature_1 - feature_11. Unfortunately, feature_1 - feature_11 are empty string variables. I would have expected feature_1 - feature_11 to be filled with the respective spring 'splits'.
Thanks for your help!
-Kyle
Comment