Thank you very much! ... View more

I understand what exactly you are saying. I am trying to learn it. I am still new to SAS. Any way I appreciate your input. Thank you very much. ... View more

all I want to do is to add a new column to that attached data set so that the new column contains 1 if the corresponding day is a Monday and zero other wise. Could you please send me a code that does this. I am still trying to understand this so its kind of hard to do it my self. Thanks ... View more

I'm still not getting the results I need. I used the following code and Used a SMALL DATA SET(attached) I need a new column added to the data set in which entry = 1 if the day is MONDAY. Can you please CORRECT the following Code. (NEW data set attached) Thanks P.S. Why does the first row of the created data set contain "." s..? data test;     infile "F:\data\ftse1.csv"  DSD MISSOVER;       input date open high low close returns; run; data test; set test; do date = '02jan90'd to '26jan90'd;    if weekday(date)=1 then flag=1; else  flag=0;    put date date9. date flag; end; run; proc print data = test; run;. ... View more

Can you please see why the following code doesnt generate what I want data test;     infile "F:\data\ftse.csv"  DSD MISSOVER;       input date open high low close returns d; run; data test; set test; do date = '01nov12'd to '20nov12'd;    if weekday(date)=2 then flag=1;    put date date9. date flag; end; run; proc print data = test; run; Thanks ... View more

Thanks. But it gives me the following error:(I'm using SAS 9.0) data test; 45 46   do date = '01nov12'd to '20nov12'd; 47 48      flag = IFN(weekday(date)=2,1,0,.);                ---                68 ERROR 68-185: The function IFN is unknown, or cannot be accessed. Malaka ... View more

Thank you very much. That is a really  good explanation. To Authur's question: I checked it but I still think I used the same file. Anyway after writing the whole program again I started to get complete answers. THANK YOU ALL FOR THE TREMENDOUS SUPPORT.. I REALLY APPRECIATE IT Malaka. ... View more

Tish is my other question. I understand why u have to retain a=0.3. But I dont understand why you have to retain sig=1. Because you use sig=1 only for the first iteration. Starting from second sig value changes according to sig 2. Can someone please explain it? ... View more

Here it is.. 1869  data test; 1870  infile "F:\data\test.csv"  firstobs=2 DSD MISSOVER; 1871  input  return resq; 1872  run; NOTE: The infile "F:\data\test.csv" is:       File Name=F:\data\test.csv,       RECFM=V,LRECL=256 NOTE: 1000 records were read from the infile "F:\data\test.csv".       The minimum record length was 9.       The maximum record length was 12. NOTE: The data set WORK.TEST has 1000 observations and 2 variables. NOTE: DATA statement used (Total process time):       real time           0.02 seconds       cpu time            0.01 seconds 1873 1874  data sim; 1875 1876    retain a 0.3 sig 1.0 ; 1877 1878    set test nobs=nobs ; 1879 1880    z = rannor(123457); 1881 1882    epsi = z*sig; 1883 1884    sig2 = resq +  a*sig*sig; 1885 1886    sig = sqrt(sig2); 1887 1888  run; NOTE: Missing values were generated as a result of performing an operation on       missing values.       Each place is given by: (Number of times) at (Line):(Column).       999 at 1882:11   1 at 1884:15     999 at 1884:19   1000 at 1886:9 NOTE: There were 1000 observations read from the data set WORK.TEST. NOTE: The data set WORK.SIM has 1000 observations and 7 variables. NOTE: DATA statement used (Total process time):       real time           0.05 seconds       cpu time            0.03 seconds ... View more

Thank you very much Linlin. your help is really appreciated. ... View more