Thank you! Let me provide more details Each sample type has a its own distribution and a specfic percentile I am interested in. For example, I want to know 90th percentile for sample A and 80th percentile for Sample B. The numbers "80", "90" are stored as a variable called "pct". Whan I calculate the percentiles, I want to point to that variable instead of directly typing those numbers. Is it possible to do that? @ballardw wrote: PCTLPTS is the option to tell which percentiles you are interested in for all of the VAR variables and all values of the BY variables. If you want the the 10th, 15th and 60th percentiles in your output you use pctlpts= 10 15 60, the PCTLPRE and PCTLNAME are the bits you use to NAME the output variables. You should post some example data, in the form of a datastep, and what you want for output for a small sample. Your example data should include enough values to calculate some of the desired percentiles and include at least 2 of your sample_type values. It almost looks to me as if you may actually want to calculate a whole bunch of percentiles but only keep some of them which would require post processing the result. Do you have different PCT values for the same Sample_type? IF your PCT values were restricted to 1, 5, 10, 25, 50, 75, 90, 95 and 99 this might be practical in a single call to Proc tabulate but that procedure only does a limited set of percentiles.
... View more