Hi, I am trying to assign a value to a proc iml input from my datatset.
proc iml;
NumWalks = 100;
NumSteps = 52;
Mean = 0.003;
SD = 0.03;
I want to assign mean and std from dataset of another table
STOCKNAME MEAN STD
A 0.003 0.034
B 0.006 0.05
How can I pull the mean and std value from the other dataset?
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;
Thank you. Got my final result.
Please explain further. Show us examples of the input table(s) and the desired output.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.