Dear Team, I am new to statistics field. In my current assignment, I need to replicate the manual excel work with SAS excel output. I am facing below challenge, on getting the excel percentile value in SAS output. My dataset is having a column named Sample with below 4 values. I am trying to get the 25th and 75th percentile value for the Sample column. Presently, team is deriving the 25th percentile using Excel function PERCENTILE(A2:A5,.25), and PERCENTILE(A2:A5,.75). Tried simple PROC MEANS and PROC UNIVERATE in SAS. Please find the code and outputs below, Code and Outputs: PROC PRINT DATA=DEMO; TITLE 'Output of Demo Dataset'; RUN; PROC MEANS DATA=WORK.DEMO P25 P75 NOPRINT; VAR SAMPLE; OUTPUT OUT = C_MEANS P25 = C_P25 P75 = C_P75; RUN; PROC UNIVARIATE DATA=WORK.DEMO NOPRINT; VAR SAMPLE; OUTPUT OUT =C_UNIV PCTLPTS = 25, 75 PCTLPRE = P_; RUN; Sincere Thanks in advance. Karthik Mani.
... View more
