I am using Stata 17 and I’d like to produce a frequency table (tabulate one way) based on multiple variables that have been manually encoded from an open survey-question.
Since respondents have given multiple answers to that question, each person in the dataset has five variables named “encoding_t1” to “encoding_t5” that relate to that same open question. Therefore, a value like 101 encoding for example “cultural related activities”, or 102 encoding "religious related activities" can occur in every single one of these variables - same for every other value of the code scheme.
The frequency table I'd like to produce, should, however, not provide only statistics (like number of observations, percentages) on one variable (e.g. encoding_t1), but should provide information on all of these variables, since I would like to know how many respondents engage in cultural activities or religion activities overall.
Is there a way to produce a variable set where I can get statistics on responses from all these variables in one table? Or do I have to produce a dummy-variable for every possible value from encoding_t1 to encoding_t5?
Related Posts with Tabulation based on multiple categorical variables
renaming regressors when presenting the results?In order to run a regression I named the regressors as x1 x2 x3 x3*x1 and so on (I have around 12 re…
STATA frequency table for categorical variables using foreach loops*** I had posted this on Stack Exchange and was directed here: I have been working with panel data …
ROC commands with multiple variablesHello, I would like to calculate the AUC using one of the roc commands. My reference/outcome variab…
Transform data set to sub-periods with corresponding averages of all other variablesDear Statalist, After been using the advices here for several years without being a member, it is n…
Replacing observations for variables within datasetcurrently my data set looks like this: dataex: gor year p_wine_on ----------------------- copy sta…
Subscribe to:
Post Comments (Atom)
0 Response to Tabulation based on multiple categorical variables
Post a Comment