Disappearing Row After Proc Report

angeliquec — Fri, 18 Jan 2019 08:11:57 GMT

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;

Re: Disappearing Row After Proc Report

andreas_lds — Fri, 18 Jan 2019 08:32:52 GMT

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

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

Re: Disappearing Row After Proc Report

angeliquec — Fri, 18 Jan 2019 09:01:51 GMT

Thanks. The MISSING option works.

topic Re: Disappearing Row After Proc Report in SAS Programming

Disappearing Row After Proc Report

Re: Disappearing Row After Proc Report

Re: Disappearing Row After Proc Report