Example-3: Merging Unbalanced Generation Map with Analysis Data

Example-3: Merging Unbalanced Generation Map with Analysis Data.

Definition: A generation map with missing data from third (grandparent) or higher generations is called an unbalanced generation map. Table-0d below is an example.

The following example shows how to construct an analysis file by merging data from an unbalanced inter-generation map and an individual attribute data file. A third generation unbalanced map is used to merge individual data from different generations.

In the tables below, except table-1, individual data are presented in red, parents data are presented in green, and grandparents data are presented blue colors.

Table-0v and Table-0d are meta and data of "individual to grandparent" inter-generation map. Each row in the table is a set of individuals from three generations. An individual's id from each generation is a pair of variables labeled as: "1968 INTERVIEW # OF ..." and "PERSON # OF ...".

"Civility Index @ Age 25" (CVI) is a composite measure of individual attributes. It is a constructed variable and ranges between 0 and 1. The meta and data are given in Table-1v and Table-1d.

Using information from Table-0d and Table-1d, create three tables (Table-2d, Table-3d and Table-4d) as shown below. Table-2d is CVI data of individuals (ID68, PN CVI). Table-3d is CVI data of parents (ID68P, PNP CVIP). Table-4d is CVI data of grandparents (ID68GP, PNGP CVIGP). Variables from Table-3d and Table-4d are renamed for a successful merge.

Merge data from:
a) Table-0d and Table-2d using (ID68, PN) as key; and
b) Result table from a) and Table-3d using (ID68P, PNP) as key; and
b) Result table from b) and Table-4d using (ID68GP, PNGP)
Final data and meta are described in Table-5d and Table-5v below.

Example-2 Data Tables:


Table-0v:- Generation ID Custom Map Data File: Variable Meta
           Map Type: Individual to Grandparent

     Name     Label                                       Type  Width
     ID68     "1968 INTERVIEW # OF INDIVIDUAL          "  num    4.0
     PN       "PERSON # OF INDIVIDUAL                  "  num    3.0
     ID68P    "1968 INTERVIEW # OF PARENT              "  num    4.0
     PNP      "PERSON # OF PARENT                      "  num    3.0
     PTYPE    "PARENT TYPE                             "  char   2
     ID68GP   "1968 INTERVIEW # OF GRAND-PARENT        "  num    4.0
     PNGP     "PERSON # OF GRAND-PARENT                "  num    3.0
     GPTYPE   "GRAND-PARENT TYPE                       "  char   2

     VARIABLE CODES

          PTYPE, GPTYPE, GGPTYPE
                    M = MOTHER
                   AM = ADOPTIVE-MOTHER
                    F = FATHER
                   AF = ADOPTIVE-FATHER


Table-0d:- Generation ID Custom Map Data File: Values

    #    ID68   PN    ID68P   PNP  PTYPE    ID68GP   PNGP  GPTYPE
    1    2069  002     2069   176  M             -      -   
    2    2069  003     2069   001  F             -      -   
    3    2069  003     2069   002  M          2069    176  M
    4    2069  005     2069   004  M             -      -   
    5    2069  030     2069   002  M          2069    176  M
    6    2069  030     2069   171  F             -      -   
    7    2069  031     2069   003  M          2069    001  F
    8    2069  031     2069   003  M          2069    002  M
    9    2069  031     2069   175  F             -      -   
   10    2069  172     2069   170  M             -      -   
   11    2069  173     2069   170  M             -      -   
   12    2069  174     2069   171  F             -      -   

Table-1v: Analysis Data File: Variable Meta

     Name    Label                                         W.D
     ID68    "1968 Family Number of Individual        "    4.0
     PN      "Person Number of Number                 "    3.0
     CVI     "Civility Index @ Age=25                 "    4.2

Table-1d:- Analysis Data File: Values

    #    ID68    PN     CVI
    1    2069   001    0.18
    2    2069   002    0.97
    3    2069   003    0.40
    4    2069   004    0.26
    5    2069   005    0.92
    6    2069   030    0.97
    7    2069   031    0.54
    8    2069   170    0.53
    9    2069   171    0.05
   10    2069   172    0.07
   11    2069   173    0.82
   12    2069   174    0.52
   13    2069   175    0.85
   14    2069   176    0.07
   15    2069   177    0.96
   16    2069   178    0.30
   17    2069   179    0.27


Table-2v: Individual Data File: Variable Meta

     Name    Label                                         W.D
     ID68    "1968 Family ID of Individual        "        4.0
     PN      "Person Number                       "        3.0
     CVI     "Civility Index @ Age=25             "        4.2

Table-2d: Individual Data File: Values

    #    ID68    PN     CVI
    1    2069   002    0.97
    2    2069   003    0.40
    3    2069   005    0.92
    4    2069   030    0.97
    5    2069   031    0.54
    6    2069   172    0.07
    7    2069   173    0.82
    8    2069   174    0.52


Table-3v: Parents Data File: Variable Meta

     Name    Label                                     W.D
     ID68P   "1968 Family ID of Parents           "    4.0
     PNP     "Person Number                       "    3.0
     CVIP    "Civility Index @ Age=25: Parents    "    4.2

Table-3d: Parents Data File: Values

    #   ID68P   PNP    CVIP
    #    ID68    PN     CVI
    1    2069   001    0.18
    2    2069   002    0.97
    3    2069   003    0.40
    4    2069   004    0.26
    5    2069   170    0.53
    6    2069   171    0.05
    7    2069   175    0.85
    8    2069   176    0.07


Table-4v: Grandparents Data File: Variable Meta

     Name    Label                                     W.D
     ID68GP  "1968 Family ID of Grandparents       "    4.0
     PNGP    "Person Number                        "    3.0
     CVIGP   "Civility Index @ Age=25: Grandparents"    4.2

Table-4d: Grandparents Data File: Values

    #  ID68GP  PNGP   CVIGP
    1    2069   001    0.18
    2    2069   002    0.97
    3    2069   176    0.07



Table-5v:- Three Generations Analysis Data File: Variable Meta
     Name     Label                                         Type    Width
     ID68     "1968 INTERVIEW # OF INDIVIDUAL          "    num      4.0
     PN       "PERSON # OF INDIVIDUAL                  "    num      3.0
     ID68P    "1968 INTERVIEW # OF PARENT              "    num      4.0
     PNP      "PERSON # OF PARENT                      "    num      3.0
     PTYPE    "PARENT TYPE                             "    char     2
     ID68GP   "1968 INTERVIEW # OF GRAND-PARENT        "    num      4.0
     PNGP     "PERSON # OF GRAND-PARENT                "    num      3.0
     GPTYPE   "GRAND-PARENT TYPE                       "    char     2
     CVI      "Civility Index @ Age=25: Individual     "    num      4.2
     CVIP     "Civility Index @ Age=25: Parents        "    num      4.2
     CVIGP    "Civility Index @ Age=25: Grandparents   "    num      4.2


Table-5d:- Three Generations Analysis Data File: Values

    #    ID68   PN    ID68P   PNP  PTYPE    ID68GP   PNGP  GPTYPE    CVI    CVIP   CVIGP
    1    2069  002     2069   176  M             .      .           0.97    0.07        
    2    2069  003     2069   001  F             .      .           0.40    0.18        
    3    2069  003     2069   002  M          2069    176  M        0.40    0.97    0.07
    4    2069  005     2069   004  M             .      .           0.92    0.26        
    5    2069  030     2069   002  M          2069    176  M        0.97    0.97    0.07
    6    2069  030     2069   171  F             .      .           0.97    0.05        
    7    2069  031     2069   003  M          2069    001  F        0.54    0.40    0.18
    8    2069  031     2069   003  M          2069    002  M        0.54    0.40    0.97
    9    2069  031     2069   175  F             .      .           0.54    0.85        
   10    2069  172     2069   170  M             .      .           0.07    0.53        
   11    2069  173     2069   170  M             .      .           0.82    0.53        
   12    2069  174     2069   171  F             .      .           0.52    0.05