local j=0
foreach x in 00 01 02 03 04 05 06 07 08 09 10 11 12 {
foreach var of varlist s503_1 s503_2 s503_3 s503_4 s503_5 s503_6 s503_7 s503_8 s503_9{
gen `var'_`j'=regexm(`var',"`x'")
recode `var'_`j' (0=.)
la val `var'_`j' YN
}
local j = `j'+1
}
forvalues i=1/9{
qui: order s503_`i'_*, after(s503_`i') sequential
}
It will extract 0102 as 01 02 and 10 instead of 01 and 02. any help.
data below for advice.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str24(s503_1 s503_2 s503_3 s503_4 s503_5 s503_6 s503_7 s503_8 s503_9) "010910" "0106" "" "" "" "0102040506070811" "" "00" "0102030405060708091011" "010203040607081112" "00" "" "08" "00" "01020304050607081112" "01020304050607081112" "" "" "010203040612" "010203040612" "" "010203040612" "010203040612" "010203040612" "010203040612" "" "" "0910" "00" "" "010203040506070812" "00" "0102030405060712" "00" "00" "" "0910" "00" "05" "08" "00" "010203040506070812" "00" "00" "" "080910" "00" "" "00" "00" "010203040506071112" "00" "00" "00" "080910" "00" "" "08" "00" "01020304050607" "00" "00" "" "0910" "00" "010203040506071112" "05060708" "00" "01020304050607" "00" "00" "" "0107080910" "00" "01020304050611" "01020405060708" "" "01020405060711" "" "00" "" "0910" "00" "01020304050607081112" "01020304050607081112" "00" "010203040506071112" "00" "00" "" "01080910" "00" "01" "010203040506070809101112" "00" "010203040506071112" "010203040506" "00" "" "0910" "00" "01020304050607081112" "00" "00" "010203040506071112" "00" "00" "" "01020304050607081112" "" "010203040506071112" "0102030405060708" "" "" "00" "" "" "0910" "" "" "0102040506070811" "" "" "" "" "" "0910" "00" "" "01020405060708" "00" "010204050607" "00" "00" "0910" "0102030405060708091012" "00" "" "0102030408" "00" "010203040506071112" "00" "00" "" "0109" "" "01020405060711" "08" "00" "0102030405060711" "00" "00" "" "0910" "00" "" "0108" "00" "0102030405060712" "00" "00" "" "01020304050607" "01020304050607" "01020304050607" "01020304050607" "01020304050607" "01020304050607" "01020304050607" "01020304050607" "" "0910" "00" "" "0102040506070812" "00" "0102030405060712" "00" "00" "" "010809" "" "" "0406" "0406" "00" "" "00" "" "010203040506071112" "00" "" "" "" "010203040506071112" "010203040506071112" "00" "" "01020406070809" "" "01020406" "010206" "01020406" "" "" "00" "00" "0109" "01" "" "0104060711" "00" "0104060712" "00" "00" "" "0910" "00" "" "0108" "00" "010203040506071112" "00" "00" "" end
0 Response to Help on regexm
Post a Comment