Hi Cynthia
Thanks for the response. Unfortunately, the 'Other' group was something of a red herring. However, I've managed to pinpoint the issue. If I take out the nozero option from the define statement (bbi_solus), I no longer receive the error. My next question is, are there limitations to the nozero option when used in combination with nesting variables. Some of the levels of the nesting variable are populated and some are blank. Would this cause issues when using the nozero option? I pasted below a copy of the code I'm running.
Thanks in advance.
proc report data=caps nowd split='#';
title1 "Customer Matrix: #byval(loc)";
title2 h=14pt bcolor=white color=blue underlin=1 link="#'Summary'!A4" "Return to Menu Page";
where grp in ('Sales','Installs')
and reportgrp="&&grp&i";
by loc;
column manager
name
('' grp),
('' type),
(new_cust_triple
new_cust_combo
solus
solus_bbi
solus_tel
solus_dig
new_cust_combo_wlr
new_cust_solus_wlr);
define manager / 'Manager'
style(column)={cellwidth=220}
group;
define name / 'Agent'
style(column)={cellwidth=220}
group;
define grp / ''
order=data
across;
define type / ''
across;
define new_cust_triple / 'Triple'
style(column)={cellwidth=95}
nozero
analysis sum;
define new_cust_combo / 'Combo'
style(column)={cellwidth=95}
analysis sum;
define solus / 'Solus'
nozero
style(column)={cellwidth=95}
analysis sum;
define solus_bbi / 'Solus BBI'
style(column)={cellwidth=95}
nozero
analysis sum;
define solus_tel / 'Solus Telco'
style(column)={cellwidth=95}
nozero
analysis sum;
define solus_dig / 'Solus DTV'
style(column)={cellwidth=95}
nozero
analysis sum;
define new_cust_combo_wlr / 'Combo#Line#Rental'
style(column)={cellwidth=95}
nozero
analysis sum;
define new_cust_solus_wlr / 'Solus#Line#Rental'
style(column)={cellwidth=95}
nozero
analysis sum;
run;
... View more