Hello, I am running a proc freq and I would like my output to include a level even if there are no values for it. I need this because I am using my output to generate a bar chart in Excel and for some levels there are no observations but I want that information to be shown in the chart. I am using this code to generate the output below. As you can see for GRAPHVAR there are no observations for level 2 but I would like the output to have a line in it where GRAPHVAR=2 AND FREQUENCY=0. Is this possible? PROC FREQ DATA=TEST NLEVELS; BY SRVC; TABLES GRAPHVAR*COST_RANGE/LIST MISSING; RUN; GRAPHVAR COST_RANGE Frequency Percent Cumulative Frequency Cumulative Percent 1 $27,350 and Below 6 4.55 6 4.55 3 $29,350-$31,350 21 15.91 27 20.45 4 $31,350-$33,350 83 62.88 110 83.33 5 $33,350-$35,350 16 12.12 126 95.45 6 $35,350-$37,350 2 1.52 128 9.97 7 Above $37,350 4 3.03 132 100.00 Number of Variable Levels Variable Levels GRAPHVAR 6 COST_RANGE 6
... View more