Hello:
I have a relatively large data set (around 100,000 rows), I used the following code to calculate the 5th and 95th percentile,
proc means data=fulldata3;
VAR DV;
CLASS GROUP TREA CMT STIM;
output out=percentiles2 mean=mean P5=P5 P95=P95;
run;
The data have 30 GROUPs, each GROUP has 4 TREAs, each TREA have 4 CMTs, every CMTs have the same STIM (scheduled time). But the above code cannot calculate the 2.5 and 97.5 percentile, since proc means does not have P2.5 and P97.5
I was trying to use
proc univariate data=fulldata3;
VAR DV;
CLASS GROUP TREA CMT STIM;
output out=percentiles1 mean=mean pctlpts=2.5 97.5 pctlpre=P;
run;
The error message is "ERROR: Cannot specify more than two CLASS variables"
Then, I tried to use
proc univariate data=fulldata3;
VAR DV;
By GROUP TREA CMT STIM;
output out=percentiles1 mean=mean pctlpts=2.5 97.5 pctlpre=P;
run;
It pumped out "windows is full and must be cleared select" and after I made a selection, it keeps doing that. I have stay there and click "C to clear windows without saving ". After a while I got the output, but the title was like the following,
"the 2.5000 percentile, DV", this name is not recognized as a variable which I will further process.
I hope to get some help about this issue.
Thank you