Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Note: For SAS 9.1 and above, see also Create a new variable whose value is unique for groups of 'linked' observations.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

data test;
  input child parent;
datalines;
23 11
99 88
77 66
72 68
88 77
66 1
68 55
69 55
70 55
55 56
;


data lineage(keep=hist1-hist5);
  /* Read in SAS data set */
  set test;

  /* Create an array with enough elements to hold the maximum number of */
  /* observations that will 'link' together.                            */
  array hist(5);
    count=1;
    /* Put the value of CHILD variable into the array HIST */
    hist(count)=child;

  /*  Process through the entire data set while the value of COUNT is less   */
  /*  than 4, i.e. the  upper boundary of the array minus 1.                 */
  do i=1 to last while (count<dim(hist)-1);

    /* Read in SAS data set again.  Rename the variables to new names so      */
    /* they can be compared with the variable names coming in with the first  */
    /* SET statement. The POINT= option allows you to access each observation */
    /* by observation number.                                                                           */
    set test(rename=(child=child1 parent=parent1)) nobs=last point=i;

    /* As you step through each observation, compare the value of PARENT to the */
    /* value of CHILD1 (which is the new name given to the CHILD variable when  */
    /* data set is brought in second time).                                     */
    if parent=child1 then do;
      count+1;
      /* populate array with value of CHILD1 */
      hist(count)=child1;
      child=child1;
      parent=parent1;
      i=1;
    end;
  end;
  /* increment COUNT */
   count+1;
   hist(count)=parent;
run;

proc print data=lineage;
run;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Obs    hist1    hist2    hist3    hist4    hist5

  1      23       11        .        .       .
  2      99       88       77       66       1
  3      77       66        1        .       .
  4      72       68       55       56       .
  5      88       77       66        1       .
  6      66        1        .        .       .
  7      68       55       56        .       .
  8      69       55       56        .       .
  9      70       55       56        .       .
 10      55       56        .        .       .

Operating System and Release Information