framerge: Merging data between frames

Abstract

We introduce a new command, framerge, based on the official Stata commands frlink and frget. Our command allows Stata users to efficiently link frames and copy variables from another frame into the current frame based on match key variables. framerge supports multiple data-matching relationships, including 1:1, m:1, 1:m, and m:m (joinby). In this article, we detail the general idea, syntax, and examples for the framerge command.

Keywords

dm0115 framerge frlink frget merge joinby merging data frames

Get full access to this article

View all access options for this article.

References

A. T. Y.

Huynh

K. P.

Jacho-Chavez

D. T.

Rojas-Baez

. 2021. Data science in Stata 16: Frames, lasso, and python integration. Journal of Statistical Software 98: Software Review 1. 10.18637/jss.v098.s01.

Mazrekaj

Wursten

. 2021. Stata tip 142: joinby is the real merge m:m. Stata Journal 21: 1065–1068. 10.1177/1536867X211063416.

Supplementary Material

Please find the following supplemental material available below.

For Open Access articles published under a Creative Commons License, all supplemental material carries the same license as the article it is associated with.

For non-Open Access articles published, all supplemental material carries a non-exclusive license, and permission requests for re-use of supplemental material or any part of supplemental material shall be sent directly to the copyright owner as specified in the copyright notice associated with the article.

0.00 MB