Experts,
Below is the output result of proc compare which compares two data sets and tells whether observations have matching values for variables. It the values are matching it gives the difference as 0 otherwise the calculated value.
Now I want to limit this data to only those "C_name" for which all "_OBS_" are having "Value"=0 .
Kindly see c_name "onn" is having one zero for its set of data and I dont want data relating to ONN to be in my new dataset. I only want those C_name for which all obs have 0 values; so the condition need to check whether the "value" is 0 for all the unique "C_names" .
One more thing the _OBS_ reference may change i.e here I have posted only 6 but originally this number may be huge so its better if we have something which is dynamic and automatically COUNTS the number of _OBS_ for unique c_names which will be same for all c_name.
| _TYPE_ | _OBS_ | C_name | metric | value |
| DIF | 1 | hero | ar_y1 | 88 |
| DIF | 2 | hero | ar_y2 | -22 |
| DIF | 3 | hero | ar_y3 | -22 |
| DIF | 4 | hero | cash_y1 | 79 |
| DIF | 5 | hero | cash_y2 | -10 |
| DIF | 6 | hero | cash_y3 | -10 |
| DIF | 1 | onn | ar_y1 | 0 |
| DIF | 2 | onn | ar_y2 | -20 |
| DIF | 3 | onn | ar_y3 | -20 |
| DIF | 4 | onn | cash_y1 | 0 |
| DIF | 5 | onn | cash_y2 | -22 |
| DIF | 6 | onn | cash_y3 | 75 |
| DIF | 1 | yu | ar_y1 | 0 |
| DIF | 2 | yu | ar_y2 | 0 |
| DIF | 3 | yu | ar_y3 | 0 |
| DIF | 4 | yu | cash_y1 | 0 |
| DIF | 5 | yu | cash_y2 | 0 |
| DIF | 6 | yu | cash_y3 | 0 |
Requirement in NUTSHELL:
ALL the C_names which have all the values zero for all the obs (here we have only one C_name which fits our criteria and that is "YU").
Thanks a lot...!
