How to

How to #merge two #cross section #time series datasets in #stata

[@jingnanli7325]

thank u very much sir. very clear and helpful. basically that was panel dataset not time-series dataset

[@ludwengangelizwe5712]

Hey thanks for the video, there a way to use time-series variables with cross-section or survey data?

[@earningsmanagementestimati6028]

You can use merge two databasets with two key variables, like name and year

[@sadafakhtar694]

What if the two data sets have different time period? How will you combine them (assuming both have similar variables)?

[@earningsmanagementestimati6028]

It should work fine, just make the dataset which has wider time range as master(main).

[@sadafdpsjsr]

@@earningsmanagementestimati6028 what if we append instead of merging?

[@earningsmanagementestimati6028]

Save your original data and give it try

[@sadafakhtar694]

@@earningsmanagementestimati6028 variable HHID does not uniquely identify observations in the master data

[@KaptainAbidMAS]

variables time country do not uniquely identify observations in the master data
this is the error i get when i try to combine two panel datasets

[@earningsmanagementestimati6028]

You may have duplicates on those variables

[@foodology2668]

How to create isin