Stata

<Test>

Yi-Hsi Lee

References

Google Search
Books (Amazon)

input data: xls / xlsx

Google Search by Keywords: Import Excel Stata
By GUI:

http://www.stata.com/stata12/excel-import-export/

By CMD:

http://www.ats.ucla.edu/stat/stata/faq/read_excel.htm

imput data: csv / txt

By CMD:

http://einstein.library.emory.edu/Stata_import_insheet.shtml

By CMD:

insheet using "filename"

Example:

insheet using "C:/patrons/username/wdi-example.txt"

input & Output data: dta (stata)

By CMD:

http://www.ats.ucla.edu/stat/stata/modules/usesave.htm
use

sysuse

sysuse auto

save

OLS estimation by matrix algebra

By CMD:

http://www.stata.com/statalist/archive/2004-04/msg00102.html

OLS ESTIMATION BY built-in function

By CMD:

http://www.stata.com/help.cgi?regress

Memo:

r(): r-class command summarize
e(): e-class command summarize
scalar range = r(max) - r(min)

Do file

Ref:

http://www.stata.com/support/faqs/programming/passing-arguments-to-do-files/

Advanced Example:

clear // 清除變數記憶體空間
version 12 // 註記 Stata 適用的版本
cd c:/myfolder // 切換工作路徑
capture log close // 關閉輸出文文件
log off // 關閉結果記錄功能

assignment

下載櫃檯買賣中心網站的近五年債券殖利率檔案

http://www.otc.org.tw/ch/bond_trading_info/gov_bond/daily/GovBondDaily.php#

將所有檔案載入 Stata 並進行合併

Stata (1)

By ecleetw

Stata (1)

1,628

ecleetw