Hi stata experts,
I'm trying to export a tabstat table into excel sheet and have tried multiple commands including tabout, putexcel, and export but none have been successful thus far. Additionally if I simply copy/paste the output to excel it populates the table with the correct number of rows but only one column, which would require me to manually transpose the data. The tabstat command I'm using is:
tabstat age ///
bmi blunt iss edarrivalgcs ///
edadmittemp ///
hr0_basedefexc ///
hr0_inr hr0_ptt hr0_plts hr0_fibrinogen_rlab ///
icu_0to24h_blood_units icu_0to24h_ffp_units icu_0to24h_plt_units ///
icu_0to6h_blood_units icu_7to12h_blood_units icu_13to24h_blood_units ///
icu_25to48h_blood_units icu_49to72h_blood_units icu_0to6h_ffp_units ///
icu_7to12h_ffp_units icu_13to24h_ffp_units icu_25to48h_ffp_units ///
icu_49to72h_ffp_units icu_0to6h_plts_units icu_7to12h_plts_units ///
icu_13to24h_plts_units icu_25to48h_plts_units icu_49to72h_plts_units ///
totalhospitaldays icu_days_to28days ventfreedaysat28days ///
vap ali mof mortalityat28days ///
sample0h_ck_alpha ///
sample0h_adp sample0h_col sample0h_trap sample0h_aspi sample0h_risto ///
iss ///
transfusedin24h ///
transfusedpltsin24h ///
delta6h_plts hr6_plts hr0_plts ///
sample6h_ck_alpha sample0h_ck_alpha sample6h_adp sample0h_adp sample6h_col ///
sample0h_col sample6h_trap sample0h_trap sample6h_aspi sample0h_aspi ///
sample6h_risto sample0h_risto sample0h_adp_endavg sample0h_adp_baseavg ///
sample0h_col_endavg sample0h_col_baseavg sample0h_trap_endavg ///
sample0h_trap_baseavg sample0h_aspi_endavg sample0h_aspi_baseavg ///
sample0h_risto_endavg sample0h_risto_baseavg ///
hr0_basedefexc ///
, s(p25 p75 n) ///
col(stat)
And the various "exporting" commands I have tried are:
1. export excel using "multiplate_clean.xlsx"
2. putexcel set "myresults.xlsx" // remember to specify the full path
putexcel A1 = matrix(T), names
3. tabout age ///.... hr0_basedefexc using multiplate_dataclean.txt, ///
c(n mean sd p50 p25 p75)
Can anyone provide some advice on ANY means to export this tabstat table to excel?
Thank you very much.
Related Posts with Exporting tabstat output to Excel file?
renaming regressors when presenting the results?In order to run a regression I named the regressors as x1 x2 x3 x3*x1 and so on (I have around 12 re…
Marginal Estimate in Binary logisticHello, I am writing my masters thesis and I am using SPSS to run binary logistic regression analysis…
Transform data set to sub-periods with corresponding averages of all other variablesDear Statalist, After been using the advices here for several years without being a member, it is n…
DID issue-----how to add industry and fixed effect to diff commandHi, Does any one know how to add year and industry fixed effect (sum of Year fixed effecti,t) as co…
STATA frequency table for categorical variables using foreach loops*** I had posted this on Stack Exchange and was directed here: I have been working with panel data …
Subscribe to:
Post Comments (Atom)
0 Response to Exporting tabstat output to Excel file?
Post a Comment