Hi all, I am trying to filter down a list of all listed US companies and their dividend payouts over 10 years, to a list of all listed US companies which have at least one dividend payout over the 10 year period. I have managed to filter out any companies which do not operate over the full 10 years by doing the following; PROC SQL; CREATE TABLE DDM AS SELECT LPERMNO, datadate, fyear, csho, dvc, ni FROM work.data GROUP BY 1 HAVING COUNT(*)=12; QUIT; Which took me long enough in itself, yet this list is not all that I require as the companies must also be paying dividends. Is there a way of filtering the data subject to the above, but also subject to the criteria that AT LEAST 1 'dvc' is > 0 for each LPERMNO (Company)? I do not want to get rid of all LPERMNO's which have a 'dvc' = 0, just the LPERMNO's where no 'dvc's exist. Please let me know if more clarification is required. ... View more