DanielManiel
New Member
- Joined
- May 29, 2017
- Messages
- 2
How can I get a pivot table telling me which observations with certain variable values have another variable value. All my variables are binary.
Since that might be a little hard to understand, here is an example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employement[/TD]
[TD]Black[/TD]
[TD]College[/TD]
[TD]Citizen[/TD]
[/TR]
[TR]
[TD]TRUE[/TD]
[TD]75%[/TD]
[TD]95%[/TD]
[TD]85%[/TD]
[/TR]
[TR]
[TD]FALSE[/TD]
[TD]25%[/TD]
[TD]5%[/TD]
[TD]15%[/TD]
[/TR]
</tbody>[/TABLE]
My data uses more variables and they aren't these variables but this is a fitting example.
I want my final table to tell me what percentage of people who have College = 1 also have Employement =1. I want to do this in one table because I have about a dozen variables.
Since that might be a little hard to understand, here is an example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employement[/TD]
[TD]Black[/TD]
[TD]College[/TD]
[TD]Citizen[/TD]
[/TR]
[TR]
[TD]TRUE[/TD]
[TD]75%[/TD]
[TD]95%[/TD]
[TD]85%[/TD]
[/TR]
[TR]
[TD]FALSE[/TD]
[TD]25%[/TD]
[TD]5%[/TD]
[TD]15%[/TD]
[/TR]
</tbody>[/TABLE]
My data uses more variables and they aren't these variables but this is a fitting example.
I want my final table to tell me what percentage of people who have College = 1 also have Employement =1. I want to do this in one table because I have about a dozen variables.