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
Check if a group of variables exists before running a series of commandsHi I have other two questions for you all. I have a number of datasets (about 250) and I want to cr…
Equation not found after gsem + ImputationDear all, using Stata 15.1, I want to run a gsem model after Multiple Imputation. First I impute usi…
Replace missing values by system-missing '.' if label value is "Manquant"Hello, I have a survey where most variables have a different code for missing values, I need to uni…
Overlaying a line graph over a catplot or tabplot graphDear Statalisters, First time statalist user here. I am studying the supply and demand of fishing p…
Store regression results of a loop in a new datasetHello everybody, I am new in this forum and I hope that I will get some advice from you. I would l…
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel with twoway tab with summary
Post a Comment