Export fre table from Stata to Excel Word

fre is a community-contributed package written by Ben Jann. It generates univariate frequency tables for specified variables, including counts, overall percent, percent based on non-missing observations, and cumulative percent. Due to requests from asdocx users, support for fre has been added to asdocx. A slightly modified version of fre is available on the asdocx website, which is automatically downloaded when a user first uses fre with asdocx. The modification is done to extract only the output matrix from fre and send it to asdocx, no other changes are made. Using fre with asdocx is simple; simply add asdocx as a prefix to the fre command. To export fre table from Stata to Excel, Word, or LaTeX, see the following examples.

  * Load auto dataset
 sysuse auto , clear
 asdocx fre foreign
foreign — Car origin
Freq. Percent Valid Cum.
Valid 0 Domestic 52 70.27 70.27 70.27
1 Foreign 22 29.73 29.73 100.00
Total 74 100.00 100.00
⠀ 
  * Using the subpop option
 asdocx fre rep78, subpop(foreign)
rep78 — Repair record 1978
Freq. Percent Valid Cum.
Valid 1 0 0.00 0.00 0.00
2 0 0.00 0.00 0.00
3 3 13.64 14.29 14.29
4 9 40.91 42.86 57.14
5 9 40.91 42.86 100.00
Total 21 95.45 100.00
Missing . 1 4.55
Total 22 100.00
⠀

 

  See also

  • tabmany – Table of multiple coded answers
  • mrtab – One- and two-way tables of multiple responses
  • tab3way – Three way table of frequencies and percentages
  • tabcount – Tabulates frequencies for up to 7 variables
  • missings – Various utilities for managing missing values
  • tabulate, tab1, tab2
  • pctab – Percentage over a grouping variable

 

  Order asdocx

Yearly license of asdocx is available at $9.99. Its life-time license is available at $49.99. With the asdocx membership, you get :

  • Life-time license to use
  • All future updates
  • All premium templates / plugins.

 

Order asdocx