BLOG

Exporting ttest results from Stata to Word using asdoc

  asdoc installation If you have not already studied the features of asdoc, you can visit this page that lists the table of contents of what asdoc can do. You can also read this one paragraph introduction to asdoc. The following line of code will install asdoc from SSC ssc install asdochelp asdoc   Reporting t-tests with asdoc Before

Read More

asdoc: Cutomizing the regression output | MS Word from Stata | Confidence Interval, adding stars, etc.

Tags : 

  Version 2.3 of asdoc adds the following features for reporting detailed regression tables. 1. Reporting confidence interval 2. Suppressing confidence intervals 3. Suppressing the stars which are used to show significance level 4. Customization of significance level for stars These features are discussed in details below. If you have not already studied the features

Read More

Merging datasets in Stata on long strings and less precise matching criterion

The Problem Consider the following two datasets where company names are not exactly the same in both the datasets, still we want to merge them using the name variable as the merging criterion. How that can be done in Stata. name in dataset 1 name dataset 2 symbol data set2 The Pakistan General Insurance Co.

Read More

asdoc: Export Stata dta file to MS Word

Creating tables in Stata using asdoc is super-easy. In this short post, I’ll show how to use asdoc to export Stata data to MS word files. If you have not already installed asdoc, it can be installed by ssc install asdoc   For exporting values from the data files, we can use the sub-command list

Read More

ASROL Version update: calculation of geometric mean and products in a rolling window and over groups in Stata

  Description asrol calculates descriptive statistics in a user’s defined rolling-window or over a grouping variable. asrol can efficiently handle all types of data structures such as data declared as time series or panel data, undeclared data, or data with duplicate values, missing values or data having time series gaps. asrol can be used for

Read More

asreg: Get standard errors of the first stage regression of the Fama and MacBeth (1973) Procedure in Stata

Tags : 

In the following example, we shall use asreg that can be installed from SSC by typing the following line in Stata command window ssc install asreg   The problem Let’s say that we wish to report different regression statistics from Fama and MacBeth (1973) regression such the standard errors of variables. Using the fmb option,

Read More

Quick Table for Converting Different Dates to Stata Format

Daily Dates Copying data from the internet, CSV files, or other sources into Stata will record the date as a string variable, shown with red color. Before we can use the Stata time-series or panel-data capabilities, we need to convert the string date to a Stata date. In the following table, the first column shows

Read More

asdoc: Exporting customized descriptive statistics from Stata to MS Word / RTF

Osama Mahmood has asked :  If I want to report 25th and 75th percentiles for variables through asdoc, then how would I do that? And what if I do not want to report the Min and Max? Answer: In this YouTube video, I have shown various methods in which descriptive statistics can be reported using

Read More

asdoc: Export matrix to MS Word | the case of xttab command in Stata

asdoc provides a variety of ways in which results from various Stata commands can be exported to MS Word or an RTF file. In this blog post,  I show how to export a Stata matrix to MS word. Usually, Stata commands leave results in r() or e() macros and sometimes in a Stata matrix. Consider

Read More

asdoc: using option row for creating customized tables row by row in Stata | MS Word

Tags : 

Introduction Option row is a new feature in version 2.0 of asdoc. This feature allows building tables in pieces. That is good news for those who want to make highly customized tables from Stata output. This feature can be considered an advanced topic and might not be good for Stata beginners. With many other Stata

Read More