Hi there, I really appreciate any help you can offer me.
Basically I have a relational database issue and need to merge a few csv files together in Stata but I can't seem to figure out how.
VISIT_DATA
Visit_ID
Patient_ID
SERVICE_DATA
Visit_ID
Visit_Service_ID
DISPENSATION_DATA
Visit_ID
Visit_DIspensation_ID
PATIENT_DATA
Patient_ID
Visit_ID
I started by merging PATIENT_DATA to VISIT_DATA
merge 1:m PATIENT_ID using VISIT_DATA
then PATIENT_DATA&VISIT_DATA to DISPENSATION DATA
merge 1:m VISIT_ID using DISPENSATION_DATA
So I have a database that has PATIENT DATA, VISIT_DATA, and DISPENSATION_DATA linked.
I need to also link SERVICE_DATA.
However, since for every patient there are many visits, and many services, and many dispensations - the 1:m data linkage won't work.
Any suggestions?
Thanks for any guidance you can offer.
Jeanine
Related Posts with Merging databases
Funnelplot for proportions after "metaprop"Dear, thank you in advance for the time you dedicate to me. I'm doing an extensive meta-analysis of…
Calculate the mean of simulations by groups with panel dataHello everyone, My dataset contains: - mcruns (50 Monte Carlo simulations) - lgacode (50001 to 501…
Spearman Rank CorrelationThe following code calculates average monthly cross sectional Pearson Product moment Correlations. N…
Create binary variable if string contains any of the followingHi, I have a variable "CaseDescription1". It's a string variable, with very long text description o…
State by Year Fixed Effects and Annual State ControlsIn my econometric model the identifying variation is at the state, year, and factory level. When I i…
Subscribe to:
Post Comments (Atom)
0 Response to Merging databases
Post a Comment