Disappearing Row After Proc Report

[angeliquec]

 Hi, I want to get the grand totals and subtotals of my HAVE dataset depending on the levels of my fields.

But let's say my HAVE dataset have null values for the other sublevels. After I execute the PROC REPORT, the level with incomplete sublevels disappear. 

In the dataset below, the first row disappears after running PROC REPORT. I'd like to know how can I retain this level (Level_1 = Grandfather) with missing sublevels. Thank you! 

/*Disappearing Row*/

data have;
input Group_Name :$20. Level_1 :$20. Level_2 :$20. Level_3 :$20. num;
datalines;
Group_a Grandfather . . 10
Group_a Grandmother Mother Daughter 90
Group_a Grandmother Father Daughter 80
;
run;

/*Get Subtotals For Each Report Level and Grand Total*/
ods select none;
proc report data=have out=dontwant nowd;
column group_name level_1 level_2
  level_3 num;

define group_name /group;
define level_1/group;
define level_2/group;

compute before group_name;
 Member=group_name;
endcomp;

compute before level_1;
 Member= level_1;
endcomp;

compute before level_2;
 Member= level_2;
endcomp;

break before level_1/summarize;

rbreak before/summarize;
run;
ods select all;

[andreas_lds · Accepted solution]

Please post code using running-man icon to increase readability.

Have you tried using the option "missing" in proc report statement?

[angeliquec]

Thanks. The MISSING option works.