Active refers to any site that was open during that month (open is between start date and end date), new would be a site that had a start date during that month, and closed would be a site that had an end date during that month. 'n' is the number of participants for the total program (not date based). This is an example data-set, but the real one is much larger. The 'want' report is something that people would read, and would not require further manipulation. I've already done other data cleaning and manipulation for this data set in SAS, so I was hoping to be able to produce the finished product there too. Unfortunately, I'm having trouble finding a proc that allows for a table with so many computed rows... Honestly I'm still learning what SAS is capable of doing, and what I should continue to do in excel.
... View more