Thank you. I am trying to create a table where the mean and SD will vary as per the input table. proc iml; NumWalks = 100; NumSteps = 52; Mean = 0.003 (want to pull this value from have for next steps); SD = 0.03 (want to pull this value from have for next steps); x = j(NumSteps, NumWalks); call randseed(1234); call randgen(x, "Normal", Mean, SD); y = j(NumSteps, NumWalks); z = x + y; do i = 1 to NumWalks; z[,i] = cuprod(z[,i]); end; create t1 from z[colname='COL']; append from z; quit; data t2; WEEK = _N_; set t1; run;
... View more