Need to map 2 datasets

[Aman4SAS]

Dear All

I need to map 2 data set ; example is below;

data A 

var1

a

b

c

d

data B

1

2

3

4

5

6

Need result like

Data Result

a1

a2

a3

a4

a5

b1

b2

b3

b4

b5

c1

c2

c3

c4

c5

d1

d2

d3

d4

d5

can not use macro variable list becaz there is lots of obs in data a and b(out of limit t macro variable)

please suggest

Thanks in advance

[Reeza]

Use a CAT function to create the variable. 

http://support.sas.com/kb/25/270.html

[Jagadishkatam]

proc sql;
create table test as select a.*,b.*, cats(a.var1,put(b.var2,best.)) as var from a as a , b as b ;
quit;