Dear all, how can exclude a group of observations in terms of one observation? for example, in following observations, psn_name_cited, docdb_family_id, psn_name_citing
apple,1,pear
apple,1,apple
apple,2,orange
apple,2,banana
apple,2, pear
juice,3, bottle
orange,3,water I would like to exclude the following observations apple,1,pear
apple,1,apple by using the following codes, PROC SQL;
CREATE TABLE want AS
SELECT
*
FROM
tryy
GROUP BY psn_name_cited,docdb_family_id
Having psn_name_cited ne psn_name_citing /* exclude self_citation */
;
QUIT; However, only apple,1,apple been excluded from the sample. Could you please give me some suggestions about this? Thanks in advance.
... View more