Creat group

[kotey dzanie]

Have dataset with four variable and i am interested in grouping the variable increaspolicyskills ( which is in percentage) in the first column. I want to group the percentages into the following categories. Need help with the coding please.

increaspolicyskills Frequency

100%

90-99%

80-89%

70-79%

60-69%

50-59%

Below 50%

input str4 increaspolicyskills str3 dev_guidelines str20 PolicyArenas str3 trainee_advocacy
"100" "Yes" "Local,State" "Yes"
"43" "Yes" "Local,National,State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "No" "" "Yes"
"100" "Yes" "State,National" "Yes"
"100" "Yes" "State,National" "Yes"
"12" "Yes" "Local,State,National" "Yes"
"80" "Yes" "Local,State,National" "Yes"
"100" "Yes" "State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"95" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,National,State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,National,State" "Yes"
"88" "Yes" "State" "Yes"
"75" "Yes" "State" "Yes"
"30" "Yes" "State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "State" "Yes"
"85" "Yes" "State" "Yes"
"50" "Yes" "Local,State,National" "Yes"
"70" "Yes" "Local,National,State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"78" "Yes" "State,National" "Yes"
"88" "Yes" "Local,State,National" "Yes"
"85" "Yes" "National" "Yes"
"100" "No" "" "Yes"
"90" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State" "Yes"
"100" "Yes" "Local,State" "Yes"
"80" "Yes" "Local,State" "Yes"
"100" "Yes" "State,National" "Yes"
"80" "Yes" "State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State" "Yes"
"94" "Yes" "Local,State,National" "Yes"
"50" "Yes" "Local,State,National" "Yes"
"100" "Yes" "State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"26" "Yes" "Local,State,National" "Yes"
"75" "Yes" "State,National" "Yes"
"100" "Yes" "State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State" "Yes"
"100" "Yes" "Local,State" "Yes"
end
[/CODE]

[Nick Cox]

Here is one way to do it.

clear 
input str4 increaspolicyskills str3 dev_guidelines str20 PolicyArenas str3 trainee_advocacy
"100" "Yes" "Local,State" "Yes"
"43" "Yes" "Local,National,State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "No" "" "Yes"
"100" "Yes" "State,National" "Yes"
"100" "Yes" "State,National" "Yes"
"12" "Yes" "Local,State,National" "Yes"
"80" "Yes" "Local,State,National" "Yes"
"100" "Yes" "State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"95" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,National,State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,National,State" "Yes"
"88" "Yes" "State" "Yes"
"75" "Yes" "State" "Yes"
"30" "Yes" "State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "State" "Yes"
"85" "Yes" "State" "Yes"
"50" "Yes" "Local,State,National" "Yes"
"70" "Yes" "Local,National,State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"78" "Yes" "State,National" "Yes"
"88" "Yes" "Local,State,National" "Yes"
"85" "Yes" "National" "Yes"
"100" "No" "" "Yes"
"90" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State" "Yes"
"100" "Yes" "Local,State" "Yes"
"80" "Yes" "Local,State" "Yes"
"100" "Yes" "State,National" "Yes"
"80" "Yes" "State,National" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State" "Yes"
"94" "Yes" "Local,State,National" "Yes"
"50" "Yes" "Local,State,National" "Yes"
"100" "Yes" "State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"26" "Yes" "Local,State,National" "Yes"
"75" "Yes" "State,National" "Yes"
"100" "Yes" "State" "Yes"
"100" "Yes" "Local,State,National" "Yes"
"100" "Yes" "Local,State" "Yes"
"100" "Yes" "Local,State" "Yes"
end

destring increaspolicyskills, gen(work)

gen wanted = 7 if work < 50 
replace wanted = 6 if work >= 50 
replace wanted = 5 if work >= 60 
replace wanted = 4 if work >= 70 
replace wanted = 3 if work >= 80 
replace wanted = 2 if work >= 90 
replace wanted = 1 if work >= 100 & work < . 

label def wanted 1 "100%" 2 "90-99%" 3 "80-89%" 4 "70-79%" 5 "60-69%" 6 "50-59%" 7 "Below 50%"
label val wanted wanted 

tab wanted 

     wanted |      Freq.     Percent        Cum.
------------+-----------------------------------
       100% |         28       37.84       37.84
     90-99% |         29       39.19       77.03
     80-89% |          7        9.46       86.49
     70-79% |          4        5.41       91.89
     50-59% |          2        2.70       94.59
  Below 50% |          4        5.41      100.00
------------+-----------------------------------
      Total |         74      100.00

[kotey dzanie]

Thank you Nick, it worked.