Hello I'm trying to calculate the 98th percentil of a data in a colum by two variables. I'm doing this in SAS guide, so building a small programm could be the solution. This is what 've donne base in sas code: PROC SORT DATA=WORK.TABLE_1 (KEEP=Cost Class) OUT=WORK.SORTTempTableSorted ; BY Class; RUN; PROC MEANS DATA=WORK.SORTTempTableSorted P99 ; (here I would like to be able to chose pe 87%) VAR Cust; BY Class; RUN; But this is not in I table were a can resuse the values. I also tried to do directly in a query with a calculaed field PCTL(87%, Cost) but the result is a table with one colum and as may lines as the original tabel. Does someone knows how to get this values? Thanks, Ana
... View more