topic Re: Need to map 2 datasets in SAS Programming

Need to map 2 datasets

Aman4SAS — Mon, 26 Dec 2016 06:07:22 GMT

Dear All

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

data A

var1

data B

Need result like

Data Result

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 — Mon, 26 Dec 2016 06:13:09 GMT

Use a CAT function to create the variable.

Jagadishkatam — Mon, 26 Dec 2016 07:50:31 GMT

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;