Hn
The data set "test" contains two cloums return and RESQ each column has a 1000 values.
I need to access these 1000 values of RESQ in the do loop given in the program(sig2 = resq + b*sig*sig;).
Can someone please help me with this. (data set test is attached)
Thanks.
data test;
infile "F:\data\test.csv" DSD MISSOVER;
input return resq;
run;
data sim;
a=0.3;
sig = 1.0;
do j = 1 to 1000;
v = rannor(123457);
z = v;
epsi = z*sig;
sig2 = resq + a*sig*sig;
sig = sqrt(sig2);
output ;
end;
what is rannor?
data test;
infile "F:\data\test.csv" DSD MISSOVER;
input return resq;
run;
data sim;
set test;
a=0.3;
sig = 1.0;
z = rannor(123457);
epsi = z*sig;
sig2 = resq + a*sig*sig;
sig = sqrt(sig2);
run;
Maybe you need:
data sim;
set test;
a=0.3;
retain sig 1.0;
z = rannor(123457);
epsi = z*sig;
sig2 = resq + a*sig*sig;
sig = sqrt(sig2);
run;
it is a random number generator. just give a random number
Thanks.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.