Date:         Tue, 9 Sep 2008 13:01:15 -0400
Reply-To:     sudip chatterjee <sudip.memphis@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sudip chatterjee <sudip.memphis@GMAIL.COM>
Subject:      DATA join with same column :
Content-Type: text/plain; charset=ISO-8859-1

Users :

 I have 10 data tables each have same variables or column name: but of
different year

say :  I have  table_1990, table_1991, table_1992

all have same column name

 So table_1990 look like this

          ID    year       number1   number2
          1      1990        23           24
          2      1990        24           22

         45      1990        11            11


 table_1991 look like this

ID    year       number1   number2
1      1991      33           34
 2      1991        14           12

45      1991        11            11


    Now I want to join all these tables such that it look like

     id     year    number1   number2
     1     1990      23          24
     1    1991      33          34
    & so on

 I was trying insert function insert into but could not get hold of it,
 any suggestion will be appreciated