topic Re: how to do merge in SAS Procedures

how to do merge

Ravikumarkummari — Wed, 09 Nov 2016 04:34:45 GMT

Hi all,

I have a dataset of ds1.

data ds1;
infile datalines;
input name1 $ name2 $;
datalines;
G A
A B
I C
B D
;
RUN;

I need output like

NAME1 NAME2
G A
A A
I A
B A
G B
A B
I B
B B
G C
A C
I C
B C
G D
A D
I D
B D

I follow in proc sql cartesian join but this output not getting.

Can anyone suggest how it can be done.

Thanks in advance.

Re: how to do merge

Reeza — Wed, 09 Nov 2016 04:42:28 GMT

A cartesian join is correct. Post your code/log and explain how it does not match your desired output.

Re: how to do merge

Ravikumarkummari — Wed, 09 Nov 2016 06:15:47 GMT

proc sql;
create table ds_final as
select a.name2, b.name1 from ds1 a cross join ds1 b ;
quit;

Solved thank u

Actually i not mentioning the variables and follow cross join.

select * from ds1 cross join ds1;

Re: how to do merge

Ksharp — Wed, 09 Nov 2016 07:08:28 GMT

data ds1;
infile datalines;
input name1 $ name2 $;
datalines;
G A
A B
I C
B D
;
RUN;
proc sql;
select *
 from ds1(keep=name1),ds1(keep=name2) order by 2;
quit;