append reshape || STATA || Data Management || Econometrics Melody || U/Graduate || Mphil /Phd

29 March 2021 [Monday]

In this video, we will learn about two stata commands: "append" and "reshape" command used for reorganizing or combining data.

Some of the commands used in this tutorial are as given below:

* use app1, clear
append using app2, gen(id)
append using app2, gen(id) keep(name)
append using app2, gen(id) force
append using app4, gen(id) nolabel

* use reshape1, clear
reshape wide inc sales, i(comp) j(year)
reshape long; reshape wide; [used immediately after previous reshape] reshape wide inc sales, i(year) j(comp) string
reshape wide inc sales, i(prov comp) j(year)
reshape wide sales* inc*, i(prov) j(comp) string
reshape long sales@ inc@, i(prov year) j(comp) string

We hope that you will find this useful.

Many Thanks
Econometrics Melody