11-17-2012 09:51 PM
I need to present the difference and the t-test of difference for the difference between the mean/median SIZE for the top & bottom quintiles. I first used proc ranks to create quintiles and then used proc means to obtained the means and median of size. I however don't know how to test the difference in the means and medians in SAS.
The program I used is as follows:
proc rank data=have group =5 ties=means out=want;
proc means data= want mean median;
output out =final mean=msize median=medsize;
The output I have is in the following format.
I need ttest to see if the difference in the mean and median of SIZE for top (quintile=0) and bottom (quintile=4)is significant. In other words, I want to see if 0.100 -0.065 (msize for quintile 4 - msize for quintile 0) is significant. Simialrly, 0.092-0053 (medsize for quintile 4 - medsize for quintile 0) is significant. I would appreciate if anyone could provide me with the formula for this test.
Need further help from the community? Please ask a new question.