Dear SAS Users, I have data as follows: date corr1_2 corr1_3..... corr19_20 for each date, the variable corr1_2 shows the correlation between item1 and item2, ..., corr19_20 shows the correlation between item19 and item20. I have all combinations of pairwise correlations for different dates. I have macro variables that holds 18,19 and 20 (end numbers). I calculated mean correlation for each day by using a line as follows: meancorr=mean( %do i=1 %to &lastbmax2; %do j=&i+1 %to &max; corr&i._&j, %end; %end; corr&lastbmax1._&max); where lastbmax2, lastbmax1 and max are 18, 19, and 20, respectively. My question is that how can I calculate the mean of the bivariate correlations which are lower than the 5th and higher than the 95th percentiles for each day? I can identify the percentiles by using the pctl function. But how can I calculate the means as I just described? Thanks for any help in advance. J.
... View more