I'm try to compute the mean of a variable (A) for its joint industry (X), performance (Y) decile, where the mean excludes the obs itself. I already created deciles for variable Y within each industry X,
but can't figure out how to calculate the mean of each decile excluding the obs. Any suggestions are much appreciated!
Amanda,
I'm assuming that you already know how to compute the mean for each X/Y group, how to save the results as a SAS data set, and how to merge that back into the original data. (If not, you will have some studying ahead of you.)
Getting the mean excluding the current observation is not very different. Instead of computing the mean, compute the SUM and N statistics for each X/Y group. Save the results as a SAS data set. Merge it back onto the original data. Using the same step that merges SUM and N back onto the data, add a few statements to calculate the mean. For example:
MEAN = (SUM - A) / (N - 1);
The programming may be easy or difficult, depending on which parts you already know how to do.
Good luck.
Amanda,
I'm assuming that you already know how to compute the mean for each X/Y group, how to save the results as a SAS data set, and how to merge that back into the original data. (If not, you will have some studying ahead of you.)
Getting the mean excluding the current observation is not very different. Instead of computing the mean, compute the SUM and N statistics for each X/Y group. Save the results as a SAS data set. Merge it back onto the original data. Using the same step that merges SUM and N back onto the data, add a few statements to calculate the mean. For example:
MEAN = (SUM - A) / (N - 1);
The programming may be easy or difficult, depending on which parts you already know how to do.
Good luck.
Thanks. It works like a charm!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.