topic Re: Please help! data management question in SAS Programming

Please help! data management question

realnewbie — Fri, 15 Feb 2013 22:37:09 GMT

So... I'm stuck at this problem. So I have dataset a, looks something like this

id1

and another dataset b,

id2

I want to merge a and b to a new dataset ab, to make it looks like this :

id1 id2

1 1

1 2

2 1

2 2

3 1

3 2

how to do this??? Thanks!!!

Linlin — Fri, 15 Feb 2013 22:54:02 GMT

data a;

input id1;

cards;

;

data b;

input d2;

cards;

;

data ab;

do j=1 to n1;

set a nobs=n1 point=j ;

do i=1 to nobs;

set b nobs=nobs point=i;

output;

end;end;

stop;

proc print;run;

ballardw — Fri, 15 Feb 2013 23:23:47 GMT

Proc sql;

Create table want as

Select a.*, b.*

From a, b

order by id1

;

quit;