topic Re: Missing Median Values in Proc Means in SAS Programming

Missing Median Values in Proc Means

psrajput — Thu, 10 Dec 2020 06:35:15 GMT

While working with let say 2-3 million records, the proc means prints missing values for Median and other stats like p5, p10, etc., although that's not the case with min, max, mean, etc.

Is there a way to overcome this limitation?

Sample Query:

proc means data=lib.data n nmiss min mean median max;

run;

Edit: I can't share the data or output. There is no error or warning. I expect there is a limitation on the number of obs, after which SAS doesn't execute these stats, although n nmiss min mean max are printed without any issue. I have used macros to take stats of few variables at once, but that is too manual and I thought someone might know any trick to force SAS to execute it.

Re: Missing Median Values in Proc Means

ballardw — Wed, 09 Dec 2020 15:17:56 GMT

Without example data and the log from running the program it isn't possible to diagnose. Do you get any "out of memory" notes or such?

Show CODE asking for those statistics plus mean max min for some of the variables. And the entire output plus the log.

Re: Missing Median Values in Proc Means

FreelanceReinh — Wed, 09 Dec 2020 15:37:03 GMT

Hi @psrajput,

One of the various suggestions in the 2019 thread "Calculating percentile for Huge data." might help in your case.