topic Add mutiltple observation to multiple obervations ( 1 to multiple) in SAS Programming

Add mutiltple observation to multiple obervations ( 1 to multiple)

raja777pharma — Wed, 30 Jun 2021 16:40:19 GMT

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 — Wed, 30 Jun 2021 16:50:11 GMT

SQL is best for many to many matches:

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

Reeza — Wed, 30 Jun 2021 16:52:37 GMT

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