I have this dataset that i need to calculate the totals for each program. So, for example, i want to count the number of total number of trainings for the program LDO and lead. The sample applies to the other string variables in the data dataset.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str4 Program str19(Variable1 Variable2) str9 Variable3 str19 Variable4 str9(Variable5 Variable6) "lead" "" "" "" "" "" "" "lead" "Product Development" "" "Training" "" "" "Training" "lead" "Quality" "Product Development" "" "Product Development" "" "" "lead" "Quality" "" "" "Product Development" "" "" "lead" "" "Product Development" "" "" "" "" "LDO" "Training" "" "" "" "Training" "Training" "LDO" "Technical" "Technical" "Technical" "Training" "" "" "LDO" "" "Training" "Training" "" "" "" "LDO" "Product Development" "" "" "" "Technical" "Technical" "LDO" "" "" "" "" "" "" "LDO" "" "Technical" "" "Technical" "" "Technical" "LDO" "Training" "Technical" "" "" "" "" end
Listed 12 out of 12 observations
i want it to be presented in this format,
LDO | LEAD | |
Product Development | ||
Technical | ||
Training |
My plan was to calculate the totals for each column but thats taking too much time. Is there an easy to do this? Please I need help
0 Response to Finding the totals of string variables
Post a Comment