Add mutiltple observation to multiple obervations ( 1 to multiple)

[raja777pharma]

Hi,

I would like add one obervation to multiple obsevations like below ;

data visit ;

visits $100;

cards;

visit1

visit2

visit3;

run;

data sujects;

  subjects $200;

  cards;

001

002

004

005

006

007

008

009

010;

run;

woud like to add for each subject 3 visit records from vistis data.

 so totla 30 obs in subjects data set with visit information.

Thnk you,

Raja.

[Astounding · Accepted solution]

SQL is best for many to many matches:

proc sql;
   create table want as select * from visit, subjects;
quit;

[Reeza]

FYI - this is called a cartesian product or cross join.