topic Pull unique value from a dataset in SAS/IML Software and Matrix Computations

Pull unique value from a dataset

shubhodasgupta — Fri, 04 Dec 2020 13:14:20 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?

Re: Pull unique value from a dataset

Ksharp — Fri, 04 Dec 2020 13:48:50 GMT

Hard to understand what you are trying to do ?

data have;
input STOCKNAME $ MEAN STD;
cards;
A 0.003 0.034
B 0.006 0.05
;

proc iml;
use have ;
read all var{STOCKNAME MEAN STD} ;
close;
Mean = MEAN[1];
SD = STD[1];

print mean sd;
quit;

Re: Pull unique value from a dataset

shubhodasgupta — Fri, 04 Dec 2020 13:57:36 GMT

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;

Re: Pull unique value from a dataset

Ksharp — Fri, 04 Dec 2020 14:03:36 GMT

data have;
input STOCKNAME $ MEAN STD;
cards;
A 0.003 0.034
B 0.006 0.05
;

proc iml;
use have ;
read all var{STOCKNAME MEAN STD} ;
close;

NumWalks = 100;
NumSteps = 52;
Mean = MEAN[1];
SD = STD[1];

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;

Re: Pull unique value from a dataset

PaigeMiller — Fri, 04 Dec 2020 14:04:18 GMT

Please explain further. Show us examples of the input table(s) and the desired output.

Re: Pull unique value from a dataset

shubhodasgupta — Fri, 04 Dec 2020 14:07:39 GMT

Thank you. Got my final result.