Suppose I have used PROC SQL to find the number of individuals each year, in the time period 2000 - 2013, having an income .above 100000, like this: proc sql create table nr_of_ind as select year, count(ind) as noi from my_table group by year having income > 100000; quit; If the number of individuals is zero any year, PROC SQL doesn't give any record with thar year and the number 0. What's the best way to add records with YEAR data, and NOI = 0 to the table nr_of_ind, in such cases?
... View more