Hey Dear members, i tried to calculate my volatility from my data entered in SAS but i front many Problems. first the date change on numerical values for example for 31.12.1997 ( Excel) to 35795 ( SAS) i don`t understand why? second the values are converted again in 100% for exampe for -0.00928714889489078% ( Excel) to -9.287148894890781E-5 (SAS) , i don't need that why my data already are in percent. for the calcul of my volatility i used first proc means but my Programm Shows me Errors, it doesn't recognize the command Rtnvol for volatility. please can someone help me to unterstand what happens on my Programm and Shows me how i can calculate the volatility and sort my data on decile Portfolios sorted on 3- years volatility. i will be very grateful for your Help. Ths. Errors showed 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc means 74 75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; _______ 22 76 ERROR 22-322: Syntaxfehler, erwartet wird eines der folgenden: ;, ALPHA, CHARTYPE, CLASSDATA, CLM, COMPLETETYPES, CSS, CV, DATA, DESCEND, DESCENDING, DESCENDTYPES, EXCLNPWGT, EXCLNPWGTS, EXCLUSIVE, FW, IDMIN, INCAS, KURTOSIS, LCLM, MAX, MAXDEC, MEAN, MEDIAN, MIN, MISSING, MODE, N, NDEC, NMISS, NOLABELS, NONOBS, NOPRINT, NOTHREADS, NOTRAP, NWAY, ORDER, P1, P10, P20, P25, P30, P40, P5, P50, P60, P70, P75, P80, P90, P95, P99, PCTLDEF, PRINT, PRINTALL, PRINTALLTYPES, PRINTIDS, PRINTIDVARS, PROBT, Q1, Q3, QMARKERS, QMETHOD, QNTLDEF, QRANGE, RANGE, SKEWNESS, STACKODS, STACKODSOUTPUT, STDDEV, STDERR, SUM, SUMSIZE, SUMWGT, T, THREADS, UCLM, USS, VAR, VARDEF. ERROR 76-322: Syntax error, statement will be ignored. 95 proc means data=rtnvol.rtnvol std; ERROR: Libref RTNVOL ist nicht zugewiesen. 96 97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 109 many thanks for your Help.
... View more