We are seeking some help in formatting tables in putdocx to look, well, pretty. We use Stata 15.1 on both Mac and PC.
We built the basic cross tabs here https://www.uml.edu/docs/topline-mil...m18-304486.pdf using putdocx, but i build each table individually and then copy and paste into "shells" that we build with the shading and formatting. We are seeking a freelancer to help us build the code that will
1. format the shading, text, and titles of the table
2. build the "big tables" that have several characteristics in them. This would allow us to automate our processes further.
data example here:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long(UML401 voted partlean pid3 income educnew race4 gender) float agebreak4 long ideo3 2 1 3 2 3 3 1 1 3 3 1 1 1 1 2 1 3 2 4 1 1 1 1 1 2 4 1 1 3 1 2 1 3 2 3 3 4 2 3 3 4 1 3 2 2 2 1 2 3 3 1 1 1 1 2 3 1 2 4 1 1 1 1 1 2 4 1 2 2 1 1 1 1 1 17 2 4 2 1 1 7 0 1 5 1 1 2 2 1 6 5 1 8 5 1 2 1 2 3 6 1 1 1 1 2 3 1 2 2 1 1 1 1 3 2 4 1 1 2 2 2 1 8 5 1 2 1 2 3 6 1 1 1 1 1 2 1 1 3 1 1 1 1 1 2 4 1 1 3 1 1 1 1 1 2 3 1 1 3 1 1 1 1 3 2 4 1 2 4 1 2 1 3 2 2 3 1 1 4 3 7 0 3 2 17 1 1 2 1 3 1 1 1 1 1 2 1 2 4 1 1 1 1 1 2 3 1 1 2 1 1 1 1 1 3 4 1 2 2 1 2 1 3 3 2 3 1 2 4 2 1 1 3 3 1 3 1 2 3 2 7 0 1 1 3 3 1 1 3 1 1 1 1 1 1 4 1 2 3 1 1 1 1 1 2 3 2 2 3 1 1 1 1 3 17 4 1 2 3 1 1 1 1 3 2 3 1 2 2 2 2 1 3 2 3 3 1 1 4 3 1 1 1 4 2 4 1 2 2 1 1 1 2 4 2 4 1 2 4 1 7 0 1 1 17 4 1 2 3 1 7 0 1 1 17 2 1 2 2 2 1 1 1 3 2 4 1 2 3 1 2 1 3 2 3 3 1 2 3 2 1 1 3 2 2 3 4 2 3 3 2 1 3 2 1 2 1 2 3 2 1 1 1 1 1 3 1 2 2 1 1 1 1 1 2 2 1 2 3 6 2 1 3 3 2 2 1 2 3 3 1 1 1 1 3 4 1 1 4 1 7 0 1 1 2 2 1 2 1 1 7 0 1 1 1 2 1 2 4 2 2 1 3 2 17 3 1 1 3 3 1 1 1 1 3 3 1 2 3 1 3 1 3 4 2 3 1 2 3 3 7 0 2 3 2 3 1 2 1 2 7 0 2 3 1 2 1 2 3 2 2 1 3 2 17 3 1 1 4 3 2 1 3 2 2 3 1 2 3 2 1 1 1 1 17 3 1 2 3 1 2 1 3 2 1 1 1 2 3 3 2 1 2 3 2 4 1 2 3 3 1 1 1 1 2 3 4 2 3 1 3 1 1 3 2 1 1 1 3 2 1 1 1 1 2 4 1 2 4 3 1 1 1 1 1 3 1 2 4 1 1 1 1 1 17 3 4 2 2 2 1 1 1 1 17 3 1 2 1 1 2 1 3 2 2 2 1 2 4 2 1 1 1 1 2 3 1 1 2 1 1 1 1 1 3 3 1 2 3 1 1 1 1 1 3 4 1 2 2 1 1 1 1 1 17 3 1 2 2 1 2 1 2 3 1 4 1 1 2 3 2 1 3 2 3 2 1 1 3 2 1 1 1 3 17 3 1 2 1 1 2 1 3 2 3 3 1 2 2 3 1 1 1 1 2 3 1 2 4 1 3 1 2 3 1 3 1 2 2 6 1 1 3 2 3 4 1 1 2 2 2 1 3 2 17 3 1 2 3 3 1 1 1 1 2 3 1 1 3 2 2 1 3 2 1 1 1 2 2 3 2 1 3 3 2 3 1 2 3 3 1 1 1 3 1 2 3 2 1 3 2 1 3 2 3 4 1 2 4 3 1 1 1 1 2 3 1 1 3 1 2 1 3 2 1 3 1 1 3 3 1 1 1 1 17 4 1 2 1 1 1 1 3 2 2 3 1 1 3 2 1 1 1 1 1 4 2 1 3 2 7 0 2 3 17 3 1 1 3 2 1 1 1 1 2 2 4 2 2 2 7 0 3 2 17 4 1 2 2 3 2 1 3 2 2 3 1 1 2 3 1 1 1 1 2 4 1 2 3 1 1 1 1 3 3 3 1 1 3 1 2 1 3 2 2 3 1 2 4 3 1 1 1 1 3 4 1 1 2 1 1 1 1 1 17 4 1 2 3 1 1 1 1 1 1 3 1 1 3 1 1 1 1 1 1 3 1 2 3 1 1 1 1 1 2 4 1 1 3 1 1 1 3 2 2 3 1 2 3 2 1 1 3 3 1 1 1 1 3 3 1 1 1 3 2 3 1 1 3 1 1 1 1 1 3 4 1 2 3 1 2 1 3 2 2 2 1 2 3 2 end label values UML401 UML401 label def UML401 1 "The Democratic candidate", modify label def UML401 2 "The Republican candidate", modify label def UML401 3 "Another candidate", modify label def UML401 4 "I intentionally left my ballot blank", modify label def UML401 5 "I’m not sure", modify label def UML401 7 "not asked", modify label values voted voted label def voted 0 "Did not vote", modify label def voted 1 "Voted", modify label values partlean pid7 label def pid7 1 "Democrat", modify label def pid7 2 "Independent", modify label def pid7 3 "Republican", modify label def pid7 8 "Not sure", modify label values pid3 pid3 label def pid3 1 "Democrat", modify label def pid3 2 "Republican", modify label def pid3 3 "Independent", modify label def pid3 4 "Other", modify label def pid3 5 "Not sure", modify label values income faminc_new label def faminc_new 1 "Below 50k", modify label def faminc_new 2 "50-100k", modify label def faminc_new 3 "100k+", modify label def faminc_new 17 "Prefer not to say", modify label values educnew educnew label def educnew 1 "HS or Less", modify label def educnew 2 "Some College", modify label def educnew 3 "College Degree", modify label def educnew 4 "Post-Grad", modify label values race4 race label def race 1 "White", modify label def race 2 "Black", modify label def race 3 "Hispanic", modify label def race 4 "Other", modify label values gender gender label def gender 1 "Male", modify label def gender 2 "Female", modify label values agebreak4 agebreak4 label def agebreak4 1 "18-24", modify label def agebreak4 2 "25-29", modify label def agebreak4 3 "30-34", modify label def agebreak4 4 "35+", modify label values ideo3 ideo5 label def ideo5 1 "Liberal", modify label def ideo5 2 "Moderate", modify label def ideo5 3 "Conservative", modify label def ideo5 6 "Not sure", modify
The relevant text begins on page 2 of the PDF.
We are soliciting competitive quotes for this work, but if this is a simple code fix, we'd appreciate the help as well.
0 Response to Building pretty crosstabs in putdocx
Post a Comment