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
What multivariate analyses could be performed with employment tenure and temporary employment rate before and after labour reforms?I'm studying the employment tenure (the duration of contracts) and the temporary employment rate of …
Changing probability cutoff in binary logistic regressionHello everyone? I am running binary logistic regression. After running it, I used the lstat command…
Combining results from different collections and export results in excel sheetDear STATA 17 users, I am new on STATA 17 and I want to use new feature for customizable tables to e…
plotting distribution of variable with concentration at 0Hi everyone, I am trying to make a distribution plot for my variable expenditure that has a really h…
Removing third bracket from*a column which is numericHello everyone, How I can remove the third bracket from a column ( which is numeric and gives count…
Subscribe to:
Post Comments (Atom)
0 Response to Tabulation based on multiple categorical variables
Post a Comment