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
Identify observations appeared in the previous yearDear All, I find this question here. The data set is Code: * Example generated by -dataex-. To inst…
When shoul I use the "noconstant" option in xtunitroot test?Hi I want to know how to use the "noconstant" option in xtunitroot test. According to Stata manual,…
Parallel trends assumption with continuous treatment variable - DiDHi, I have survey data on individual firms from 2008-2017. I want to test how a reform that happene…
Variable with percentile groupsHi Stata users, I have a continuous variable and would like to generate a new variable that states …
Pooling dataHi everyone. I have a question on how pooling data in stata. I am working with a repeated cross-sect…
Subscribe to:
Post Comments (Atom)
0 Response to Tabulation based on multiple categorical variables
Post a Comment