Hello . I'm new to SAS EG. I have an issue that intuitively feels that it should be really easy to resolve in SAS EG, but for the life of me I can't find the solution/function to make it work. I'm sure I'll be embarrassed by the answer. How can I calculate the columns "Count of A", "Count of B" and "Count of null"? The N function only seems to work with number formats and the Count function only seems to work within one column - but I'm happy to be corrected. Incidentally in real life there could be upwards of 30 columns to check. CustomerID Product 2011_01 2011_02 2011_03 2011_04 2011_05 2011_06 Count of A Count of B Count of null 111 Widgets A A B 2 1 3 111 Gadgets A A A B 3 1 2 222 Gadgets A A 2 0 4 333 Widgets A A A 3 0 3 333 Gadgets A A A B B 3 2 1 333 Gizmos A A A 3 0 3 Thanks in advance for any tips.
... View more