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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.