How to append two datasets when there are non-unique columns?

Question

I have two datasets, A and B.

Dataset A has 2000 variables, and Dataset B has 2500. Both A and B have common variables.

How do I append the two datasets?

Below you can find a toy example:

Dataset A:

Name    Age    Sex    Occupation
a        10     M      Engineer

Dataset B:

Name    Age    Sex     Children    Income
b        33     F         Y          50

I need to append such that the final dataset looks as follows:

Name    Age    Sex    Occupation   Children    Income
a        10     M      Engineer       .          . 
b        33     F          .          Y          50

Missing values get generated for lack of observations.

score 1 · Accepted Answer · 2018-11-17 19:57:36Z

1

The following works for me:

clear

input str1 Name Age str1 Sex str10 Occupation
a 10 M Engineer
end

save one, replace

clear

input str1 Name Age str1 Sex str1 Children Income
b 33 F Y 50
end

save two, replace

use one, clear
append using two

list, abbreviate(10)

     +---------------------------------------------------+
     | Name   Age   Sex   Occupation   Children   Income |
     |---------------------------------------------------|
  1. |    a    10     M     Engineer                   . |
  2. |    b    33     F                       Y       50 |
     +---------------------------------------------------+

Note that Stata generates a . only for missing values in numeric variables. For strings, a space is generated instead.

Collectives™ on Stack Overflow

How to append two datasets when there are non-unique columns?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related