“pretty” p-value code<\/a> documented in this separate post. <\/p>\n\n\n\nsysuse auto, clear \n* first row\nregress mpg weight\n* save as a custom matrix\nmatrix row1=r(table)\n* second row\nregress mpg weight if foreign==0\n* save as a custom matrix\nmatrix row2=r(table)\n* third row\nregress mpg weight if foreign==1\n* save as a custom matrix\nmatrix row3=r(table)\n****\n*view the custom matrices to prove they worked\nmatrix list row1\nmatrix list row2\nmatrix list row3\n****\n*now save the beta, 95% ci, and P as macros\n*here's a loop that automates this a bit\nforeach x in 1 2 3 {\nlocal beta`x'=row`x'[1,1]\nlocal low95`x'=row`x'[5,1]\nlocal high95`x'=row`x'[6,1]\nlocal pval`x'=row`x'[4,1]\nlocal pval = r(table)[4,1] \n\nif `pval`x''>=0.056 {\n\tlocal pvalue`x' \"P=`: display %3.2f `pval`x'''\"\n}\nif `pval`x''>=0.044 & `pval'<0.056 {\n\tlocal pvalue`x' "P=`: display %5.4f `pval`x'''"\n}\nif `pval`x'' <0.044 {\n\tlocal pvalue`x' "P=`: display %4.3f `pval`x'''"\n}\nif `pval`x'' <0.001 {\n\tlocal pvalue`x' "P<0.001"\n}\nif `pval`x'' <0.0001 {\n\tlocal pvalue`x' "P<0.0001"\n}\ndi "original P is " `pval`x'' ", formatted is " "`pvalue`x''"\n}\n\npwd \/\/ this is where your CSV file is saved\n\nquietly {\ncapture log close table \/\/ always good to close any open logs\nlog using "regressiontable.csv", replace text name(table)\n*header\nnoisily di ",Weight beta (95% CI),P-value"\n*row 1\nnoisily di "All," %3.2f `beta1' " (" %3.2f `low951' " to " %3.2f `high951' ")," "`pvalue1'"\n*row 2\nnoisily di "Domestic," %3.2f `beta2' " (" %3.2f `low952' " to " %3.2f `high952' ")," "`pvalue2'"\n*row 3\nnoisily di "Foreign," %3.2f `beta3' " (" %3.2f `low953' " to " %3.2f `high953' ")," "`pvalue3'"\nlog close table\n}<\/code><\/pre>\n\n\n\nHere’s the output:<\/p>\n\n\n\n
,Weight beta (95% CI),P-value\nAll,-0.01 (-0.01 to -0.00),P<0.0001\nDomestic,-0.01 (-0.01 to -0.01),P<0.0001\nForeign,-0.01 (-0.02 to -0.01),P<0.001<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"If you make your own Stata programs and loops, you have discovered the wonders of automating output of analyses to tables. Extracting the results from regressions in Stata can be a bit cumbersome. Here’s one step-by-step approach that you might find helpful. The set-up Let’s use the classic 1978 auto dataset that comes with Stata. … Continue reading Working with Stata regression results: Matrix\/matrices, macros, oh my!<\/span><\/a><\/p>\n","protected":false},"author":4473,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[477491],"tags":[],"class_list":["post-319","post","type-post","status-publish","format-standard","hentry","category-stata-code"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts\/319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/users\/4473"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/comments?post=319"}],"version-history":[{"count":38,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":1397,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts\/319\/revisions\/1397"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/media?parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/categories?post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/tags?post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}