Hi i have two dataset. dataset a and dataset b. suppose dataset a has 10 records and data set b has 3 records.. I want to append record from dataset b after every 3 records of dataset a.
data A;
do i = 1 to 10;
c=5*i;
output;
end;
run;
data B;
c=25;i=66;output;
c=75;i=99;output;
run;
I tired following:
data temp;
set a;
output;
do i = 3 to 10 by 3;
if _n_ =i then do;
set b;
output;
end;
end;
run;
My issue in the above code is sas iteration depends on the number of records of smallest dataset. hw to over above issue.. any 1 with help plz
... View more