Yes, provided that the sample sizes are much much smaller than the total population. And you still need an estimate for the standard deviation.   The Getting Started example in the documentation analyzes a problem very similar to yours.   I don't understand the "mean loss rate" or the values of the "bps difference", but it looks like you might want to use the MEANDIFF option to specify all those rates. Here is an example that has fake values:   proc power; twosamplemeans meandiff = 0.02 0.03 0.04 0.05 0.1 groupweights = (3 2) /* 60-40 ratio */ stddev = 0.04 power = 0.8 alpha = 0.05 ntotal = . sides = 2; run;     ... View more

Or test it on a SQL server first if you have access, the errors there should be more descriptive. ... View more

@ivyc wrote: This is the code : %macro runit(no); title 'BeaconScr'; proc ttest data=stacked2 cochran ci=equal umpu ; class cell_ind; var beacon_scr; /*** change this ****/ where beacon_scr>350 and cell_ind in ("CELL&no.","CELL&mo") ; /*** change this ***/ run; %mend; %macro repull; %do i = 00 %to 99; %let I = &i; %runit(&i); %end; %mend; %repull; I need to write macro to define cell&mo.So if cell&no has value of lets say 2 ,I am testing it against allother 99 values of Cell&mo.So cell&mo. has all values other than 2.To me that is a tricky part to define in macros.Thanks I think that you may need to provide to us at least the explicit values you need. The value of &I you are attempting to use is not what I think you need. Consider: %macro dummy; %do i = 00 %to 10; %put i is &i.; %end; %mend; %dummy Examine the log to see the values. The value of &I is not 00, it is 0. And if you were expecting to generate something like 01 02 etc then you need to show us because the code you have now is not doing it. Instead of hiding things with macro code, show the EXACT Proc ttest code you need to generate for a few values of &no, &mo. No macro variables anywhere. Complete Proc Ttest code from Proc statement to Run statement. ... View more

Not sure whether your request is so simple as the below coz like @Astounding pointed out, we do not know the bigger picture.    /*vyc's request i think*/ %let start= '01jan2014'd; %let end= '01aug2018'd; data wvyc; do j=0 to intck('month',&start, &end); base=intnx('month', &start,j); array m(6); do i=1 to dim(m); m(i)=intnx('month',base,i) ; end; output; end; format base m: yymmd.; drop i; run; If the above is not your requirement, i'll follow the thread tomorrow as i'm gonna sleep. Good night from Chicago! ... View more