merge

  1. E

    How to create 1 (continuous) variable by using two (continuous) variables (and ignore the missing) in SPSS?

    Hi there, I am currently busy with my master thesis and I have the following question. I want to create a variable called applicant credential (appl_credent), by combining the following two variables: western applicant credential and nonwestern applicant credential. a participant either has a...
  2. A

    Merging PISA waves in Stata

    I am running into trouble trying to merge multiple PISA waves into one Stata file for running some hierarchical models. So far, I have combined the student and school files, but do not know the best way for merging 2000 through 2012. The problem is further complicated by the fact that...
  3. K

    problem merging 1:1

    Hello all, I'm trying to merge two data sets. Data 1 contains the following variables: interview date, household longitude and latitude, cortisone level. (each row is a respondent). Data 2 contains: longitude and latitude for entire country, rain levels by geographical coordinate from 2009...
  4. J

    Merging with unique personids but not sorted as unique in datasets

    Hi Everyone- First, long time viewer of the forum but first time posting. Thank you so much for any advice, this site has helped get me back on track with several assignments in the past, and I really appreciate all of the comments and time spent by contributors. I am attempting to merge...
  5. W

    Merging data in STATA, Panel Data problem. A real challenge!

    Hy! I have one database with companies who did a specific event on a specific date. I also have their company codes. Some of these companies are twice or more in this database because they did this event more then once during the observed period. In my second database I have other company...
  6. M

    Merge base on a inconsistent string variable

    I have two datasets. Dataset 1 has many more variables and has an unique ID for each observation (articles I found in a lit review). Dataset 2 does not have an ID variable but it has similar variables than dataset 1 such as Article_Name Year_Publications etc also dataset 2 has a variable that...
  7. M

    Reshaping/collpasing institution level data

    I have data for lets say 10 health centers. There are a series of variables that ask for number of clients serve by age group. For example. var1= provide emergency contraception to 12-14 years old. var2 = provide emergency contraception to 15-17 years old. var3= provide emergency...
  8. J

    avoiding double counting from merged datasets

    Hi there, I have merged two client datasets. The first dataset contains demographic information about the individuals, the second contains those same individuals stock purchases over time. When I merge them using the unique person identifier number I obviously have several rows now for...
  9. L

    How can you merge two files in SPSS when the cases are not perfectly the same?

    For one of our replication projects, we have two SPSS datasets. As they are part of a follow up study (we have wave 1 and wave 3), they principally include the same cases. However, the second dataset contains some extra cases and others went missing. All cases have an identifier. We want to...
  10. M

    Merging datasets - no unique ID for individuals, only for households

    My thesis data has over 1000 households from a 70 page survey with multiple datasets. It is quite large so I cannot do this in Excel. I am trying to merge the datasets (by variable). However, I am having difficultly, because my data has unique identifiers for households... but in every...
  11. M

    Add price information based on reference number to different observation

    Hi I have a large dataset that includes some observatios that are identified as either E or A. Observation A and E have a common reference ID number. Observation A incudes price information whereas E does not. However based on the reference number I would like to add the price information...
  12. S

    Stata - Merging 2 datasets

    Hi all, How can I merge Dataset1 and Dataset2 to create Dataset3? Merge m:m Group doesn't provide the result expected... Thanks for your help. StdDev. Dataset1 Group Elt A 01 A 02 A 03 B 04 B 05 C 06 C 07 Dataset2 Group Type A CP A CM B CB B TD C CA...
  13. K

    merging datasets with population weights in STATA

    I would like to compare means and percentages from a small sample dataset to a large population national dataset. The population dataset has population weights. I have stset the population dataset but I need to merge the two datasets in order to run analyses. I am wondering how I can...
  14. S

    "lag" command in merging files

    I am in the process of merging two data sets. The one that I am trying to merge into my original file has multiple lines of data, each representing a different event that happened to the person/case. I have successfully been able to merge the first of each line of data, but now need to...
  15. X

    Stata Project Help (10-12 hour Job)

    Dear All, I need your help regarding one of my projects of Stata software. You must be familiar with dates formatting, system variables and lagging and merging and transposing of data. I understand you would be busy in your job and studies, and that is why I am happy to pay you reasonable...
  16. D

    merging files in a challenging situation. *ideas?*

    :) hi all! I'm working on my master thesis and I think I need some expert advice here :) what I need to do is basically match two data files. from what I understand normally you need to have either exactly the same variables or exactly the same cases to merge files. unluckily this is not my...
  17. S

    Doublecheck: MMerge on Three Variables?

    Thanks for taking the time to read this! The Situation I want to merge two datasets together. For the sake of example, the datasets contain the following info.. Master: SpecificStockPicks, Player, CompanyName, TickerSymbol, StartMonth Using: CompanyName, TickerSymbol, S&PMonth, StartMonth...
  18. S

    Merging Datasets

    Merging Datasets: Should I use a Many-to-Many Merge? Intro Thank you for taking the time to read this! I think my problem is complicated so I'll be detailed. Also, I do not know exactly what the solution will be, so the structure of my question might be convoluted. The Situation (in...