I want to extract coefficients and pvalues from the second table command and append to the first table command as columns by the right side of the tabulated values but my efforts have been to no avail. Extracting the values firstly is not working as only one value is being extracted instead. Your assistance is much appreciated. Thanks.
Code:
table (p800ind) (p203 studyphase), statistic(freq) statistic(percent, across(p800ind)) totals(p203#studyphase) nformat(%5.1f) sformat("(%s%%)" freq percent) collect layout (p800ind) (p203#studyphase#result) table (result) , command( exp(r(table)[1,2]) r(table)[4,2]:xtgee p800ind i.did i.p203 i.time, family(binomial 1) link(logit) corr(independent) robust eform) nformat(%5.2f)
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float p800ind byte(did p203) float time byte studyphase 0 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 1 0 1 0 1 0 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 0 1 1 1 2 1 1 1 1 2 1 1 1 1 2 0 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 0 1 1 1 2 0 1 1 1 2 1 1 1 1 2 1 1 1 1 2 0 0 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 0 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 1 1 1 1 2 0 0 1 0 1 0 0 1 0 1 0 0 1 0 1 0 0 1 0 1 0 0 1 0 1 0 0 1 0 1 0 0 1 0 1 0 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 1 0 1 0 1 0 1 1 1 2 0 1 1 1 2 1 1 1 1 2 0 1 1 1 2 0 1 1 1 2 0 1 1 1 2 0 1 1 1 2 end label values p800ind p800ind label def p800ind 0 "No", modify label def p800ind 1 "Yes", modify label values p203 p203 label def p203 1 "Intervention", modify label values time time label def time 0 "Endline", modify label def time 1 "Baseline", modify label values studyphase studyphase label def studyphase 1 "Baseline", modify label def studyphase 2 "Endline", modify
Comment