Hi Guys,   I have two columns of observations, and the numbers of observations are different, what I want to do is to test whether the difference between their average value are different from zero, (using t test) how could i do it? For example, a        b 1        3 2        7  3        8 8        6 5       10 9         8 10 15 1 7 ... View more

Hello guys,   I'm working on estimating capm and FF-3-factor model alphas and betas. I downloaded data over 40-year period, and divided all data into ten deciles. I need to estimate the two models in every deciles. My codes are as follow, but the coefficients are all zeros in two models and intercept are the same. I dont know how to fix that problems, could anybody help me out? proc sort data=aa03; by myrank date ; run; proc reg noprint data=aa03 outest=ff; by myrank date; model exret= mkt_rf smb hml/sse; quit; proc means data=ff n mean t probt; where 1972<=year(date)<=2017; class myrank; var intercept; run; proc sort data=aa03; by myrank date ; run; data aa03; set aa03; where 1972<=year(date)<=2017; run; proc reg noprint data=aa03 outest=capm; model exret= mkt_rf / sse ; by myrank date; quit; proc means data=capm n mean t probt; where 1972<=year(date)<=2017; class myrank; var intercept; run; ... View more

Hello Guys,   I'm trying to merge two tables by cusip number and date, there are no empty values in every column, but the merged table has empty columns, what are the possible reasons?   Thank YOU proc sql; create table aa as select a.*, b.* from temp04 as a left join temp05 as b on a.cusip=b.cusip and a.datadate=b.date; quit; ... View more