How to average duplicate target samples?

[lu_king]

Hi everybody! I would like to create an additional variable that is the average of my duplicate target levels with my main target levels. I don’t want the 0’s to average with another sample though. For example on May 6, located at EU, there are two levels for the N.GIII target…I’d like to average those together, but on May 20, located at HU, the duplicate sample is a non-zero, I don’t want to average that value, with the zero in the main sample. Any guidance would be appreciated!

[PaigeMiller]

Turn the zeros into missing values.

Also, most of us refuse to download Excel (or Microsoft Office) files as they can be a security threat. The proper way to include data is as text in working SAS data step code (examples and instructions)

[Tom · Accepted solution]

Why attach a file to share a hand full of values?

date sample tylocation target levels
6-May main EU N.GIII 32
6-May dupe EU N.GIII 456
7-May main PR CII 645465
7-May dupe PR CII 0
20-May main HU AGI 0
20-May dupe HU AGI 64875833

Can you code the rules that explain which values you want to ignore?  Use them to make a NEW variable (so your original data is not lost) which has MISSING values where you don't want to use the original value.

data for_analysis;
  set have;
  new_var = levels;
  if levels=0 then new_var=.;
run;

Now you can take the MEAN() of your new variable.