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...!
You appear to have posted this question twice. I gave an answer in the other thread that has the same name.
Thanks for answering this art297.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.