Assign value in proc iml variable from another dataset

shubhodasgupta · Posted 12-04-2020 08:16 AM

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?

PaigeMiller · Posted 12-04-2020 08:25 AM

PROC IML allows you to read values from a data set into a matrix. Example:

More details

Although the way you have described the problem, there's no need for PROC IML, when DATA steps ought to get the job done.

--
Paige Miller

shubhodasgupta · Posted 12-04-2020 08:45 AM

Thank you.

How will I be able to assign the value of Mean to a specific value from the other dataset?

Re: Assign value in proc iml variable from another dataset