DATA Step, Macro, Functions and more

How to calculate mean of a variable excluding the observation itself

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

How to calculate mean of a variable excluding the observation itself

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!


Accepted Solutions
Solution
‎08-18-2014 03:17 PM
Super User
Posts: 5,081

Re: How to calculate mean of a variable excluding the observation itself

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.

View solution in original post


All Replies
Solution
‎08-18-2014 03:17 PM
Super User
Posts: 5,081

Re: How to calculate mean of a variable excluding the observation itself

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.

Occasional Contributor
Posts: 10

Re: How to calculate mean of a variable excluding the observation itself

Thanks. It works like a charm!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 658 views
  • 1 like
  • 2 in conversation