clear
input int id str20 x
1 "A,C,CSR,F"
2 "A, C, Ex, F,G,N"
3 "A,F"
4 "Ex"
end
compress
gen xx = subinstr(x, ", ", " ", .)
replace xx = subinstr(x, "," , " ", .)
local N = _N
local aa ""
forvalues i = 1/`N'{
local a = xx[`i']
local aa `aa' `a'
*dis "`aa'"
}
foreach c of local aa{
cap gen `c' = strmatch(xx, "*`c'*")
}
*-results
list
browse