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
Making the observations of a string variable as variable names after drop_allHi, I have a datasheet that has a string variable named "person" with observations like "AM", "MF",…
Error: Too many base levels specified?I am trying to compare coefficients before and after the crisis. I am using the SUEST command so I c…
To determine a discriminatory value for MUAC for risk of mortality by 12 monthsDear Experts, I want to obtain a cut-off for MUAC among infants less than 6 months of age. These a…
Estimation of CAPM (beta pricing model) with GMMI want to estimate a beta-pricing CAPM model using a portfolio of 12 assets. I want to use the GMM a…
Removing collinearity between dummy variables in difference-in-difference regressionHello all I'm doing a difference-in-difference regression to analyse the impact of removing financia…
Subscribe to:
Post Comments (Atom)
0 Response to Tabulation based on multiple categorical variables
Post a Comment