Dataset A has 1000 observations and dataset B has 50 observations and they have no common variables. Is there a way I can combine the 2 datasets such that the same 50 observations of dataset B gets repeated for every 50 observations of dataset A? I also want to label the first 50 observations of the new dataset as 1, the next 50 observations as 2 and so on. Thanks!
This should do it:
data want;
set a;
recno = mod(_n_, 50);
if recno = 1 then group + 1;
else if recno=0 then recno=50;
set b point=recno;
drop recno;
run;
This should do it:
data want;
set a;
recno = mod(_n_, 50);
if recno = 1 then group + 1;
else if recno=0 then recno=50;
set b point=recno;
drop recno;
run;
This works like a charm, thank you so much.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.