topic Re: calling data stored in an excel file in a do loop in SAS Programming

calling data stored in an excel file in a do loop

malakaext — Sun, 28 Oct 2012 00:15:19 GMT

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;

Re: calling data stored in an excel file in a do loop

Linlin — Sun, 28 Oct 2012 00:40:01 GMT

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;

Re: calling data stored in an excel file in a do loop

malakaext — Sun, 28 Oct 2012 00:42:52 GMT

it is a random number generator. just give a random number

Thanks.