Hi,
If I have a program like this that runs every month.
DATA HAVE;
INPUT CATEGORY$ TYPE MONTH ;
CARDS;
A 100 1
B 200 2
B 100 3
B 200 1
A 100 2
A 200 1
B 200 1
A 100 1
A 200 2
A 200 3
A 100 5
A 200 9
B 200 10
A 100 1
A 200 11
A 200 11
;
RUN;
PROC SQL;
CREATE TABLE INVENTORY AS
SELECT CATEGORY,
TYPE,
COUNT (CASE WHEN MONTH = 1 THEN TYPE END) AS JANUARY,
COUNT (CASE WHEN MONTH = 2 THEN TYPE END) AS FEBRUARY,
COUNT (CASE WHEN MONTH = 3 THEN TYPE END) AS MARCH,
COUNT (CASE WHEN MONTH = 4 THEN TYPE END) AS APRIL,
COUNT (CASE WHEN MONTH = 5 THEN TYPE END) AS MAY,
COUNT (CASE WHEN MONTH = 6 THEN TYPE END) AS JUNE,
COUNT (CASE WHEN MONTH = 7 THEN TYPE END) AS JULY,
COUNT (CASE WHEN MONTH = 8 THEN TYPE END) AS AUGUST,
COUNT (CASE WHEN MONTH = 9 THEN TYPE END) AS SEPTEMBER,
COUNT (CASE WHEN MONTH = 10 THEN TYPE END) AS OCTOBER,
COUNT (CASE WHEN MONTH = 11 THEN TYPE END) AS NOVEMBER,
COUNT (CASE WHEN MONTH = 12 THEN TYPE END) AS DECEMBER
FROM HAVE
GROUP BY CATEGORY, TYPE;
RUN;
But I don't want months without data to appear in the report. I want to get this:
How should I proceed ?
... View more