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?
Rangestat to compute market betasHi everyone, I am new to Stata and I am using it to analyze data for my Bachelor thesis. I have a da…
plotting distribution of variable with concentration at 0Hi everyone, I am trying to make a distribution plot for my variable expenditure that has a really h…
Changing probability cutoff in binary logistic regressionHello everyone? I am running binary logistic regression. After running it, I used the lstat command…
Need help calculating an "isomorphism index"Dear Stata users, I am currently working on a minor research paper about isomorphic behavior within…
Combining results from different collections and export results in excel sheetDear STATA 17 users, I am new on STATA 17 and I want to use new feature for customizable tables to e…
Subscribe to:
Post Comments (Atom)
0 Response to Exporting tabstat output to Excel file?
Post a Comment