WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..!

HarshadMadhamshettiwar — Sat, 20 Dec 2014 05:37:43 GMT

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...!

Re: WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..!

art297 — Sat, 20 Dec 2014 05:57:22 GMT

You appear to have posted this question twice. I gave an answer in the other thread that has the same name.

Re: WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..!

AnnaBrown — Mon, 22 Dec 2014 14:31:20 GMT

Thanks for answering this art297.

For reference, the other thread can be found here:

topic WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..! in SAS Data Management

WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..!

Re: WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..!

Re: WOW I didn't know SAS does not have Function for this...Do YOU have any IDEA..!