DATA Step, Macro, Functions and more

Need to map 2 datasets

Reply
Super Contributor
Posts: 266

Need to map 2 datasets

 

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

 

 

 

Super User
Posts: 19,870

Re: Need to map 2 datasets

Use a CAT function to create the variable. 

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

 

Trusted Advisor
Posts: 1,137

Re: Need to map 2 datasets

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;
Thanks,
Jag
Ask a Question
Discussion stats
  • 2 replies
  • 162 views
  • 0 likes
  • 3 in conversation