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.
SQL is best for many to many matches:
proc sql;
create table want as select * from visit, subjects;
quit;
SQL is best for many to many matches:
proc sql;
create table want as select * from visit, subjects;
quit;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: