topic Re: Assign value in proc iml variable from another dataset in New SAS User

Assign value in proc iml variable from another dataset

shubhodasgupta — Fri, 04 Dec 2020 13:16:39 GMT

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 — Fri, 04 Dec 2020 13:26:23 GMT

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.

shubhodasgupta — Fri, 04 Dec 2020 13:45:47 GMT

Thank you.

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