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
Exclude certain observations only in one variable?Hello Code: gen gift_group_test = 0 if gift_total < . & gift_received == 1 replace gift_gr…
Creating a loop to generate a new variables in a panel datasetI would be be grateful for any help with my query. I have the following variables chd002_9 chd002_0…
AFT or Cox survival analysis for buy-build strategies in private equity duration analysesHi there, For my research project I am analysing the duration of private equity buy-and-build strat…
How to invert the order of rows in a matrixDear Statalisters Apologies in advance for the simplicity of my question. I am sure the is already …
multi-level/mixed effects vs clustered robust standard errors - which is more appropriate if many of the clusters have 1 individual?Hi. I have a dataset of psychological measures from carers (n=254) of people with mental health pat…
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel with twoway tab with summary
Post a Comment