Hello, I am trying to store the results of a twoway tab with summary:
tab race_code sex_code if level==0 & naics_econ_sec==0 & ethnicity_code==1 & veteran_code==1 & is_sub_race==0 & employer==1, sum(number_of_firms) nofreq nost
My end goal is to use putexcel and amend several of these tables one after the other in excel. I tried using tabout but it doesn't allow me to merge or append to the right. Using tabout will only append below. Here is what I mean:
I want to run this:
tab race_code sex_code if level==0 & naics_econ_sec==0 & ethnicity_code==1 & veteran_code==1 & is_sub_race==0 & employer==1, sum(number_of_firms) nofreq nost
[STORE THE RESULTS SOMEWHERE]
tab race_code sex_code if level==0 & naics_econ_sec==0 & ethnicity_code==1 & veteran_code==1 & is_sub_race==0 & employer==1, sum(rse_num_firms) nofreq nost
[STORE THESE SOMEWHERE]
And then use putexcel to export them side by side. Any ideas? THANK you very much!
Related Posts with Putexcel with twoway tab with summary
Interpreting stata output with log dependent variable and % independent variablesHello stata users, Hope you are doing well. I have a question regarding interpreting stata output i…
Adding fixed effects in esttab using estaddHi all, I've run a few regressions and am trying to add rows indicating the presence of fixed effec…
Graphing Medians Panel DataHello, I'd like to graph the median values of a variable. The data I have looks like this, and I wou…
re-formulate a functionHello everyone, I have this equation Code: g=exp(1.546776)*(x/(1-x)^(0.4314782)*y^(1-0.4314782)-exp…
Using substring functions in Stata 16.1Dear Statalist, I have a string variable "comment" stored as "strL" that contains a mix of numbers…
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel with twoway tab with summary
Post a Comment