Date:         Thu, 9 Sep 2010 11:37:07 -0700
Reply-To:     Sawir Yakup <sysas00@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sawir Yakup <sysas00@YAHOO.COM>
Subject:      Data merging
In-Reply-To:  <AANLkTimu5v1+UvuUg3qAufsfAN5uDgbFvFqBee+hHP4p@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii

proc sql;
  select var1,var2 from table1,table2;
quit;





________________________________
From: yom <yomsas@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Sent: Wed, September 8, 2010 4:01:32 AM
Subject: Data merging

Dear all,

I have two tables :

var1
-----
a
b
c

var2
-----

1
2
3

I would like to get the following table :

a 1
a 2
a 3
b 1
b 2
b 3
c 1
c 2
c 3

Please what is the best way to get it?

Thank you very much in advance.

Best regards,
yom