topic Issue with labels in Proc Tabulate in SAS Programming

Issue with labels in Proc Tabulate

Q1983 — Mon, 09 Aug 2021 16:20:59 GMT

proc tabulate data= vendor_grp;
title 'Vendor Summary';
class Month_sort;
var tot_cnt /*list numerica variables to be analyzed*/
	cancelled	
	_dec_eom_cnt
	inb_outb_aft_cnt
;
Table Month_sort ='' all={label='Grand Total' S=[background = lightblue cellwidth=80]} 
*[STYLE=[Font_Weight=BOLD]],
tot_cnt*(sum*f=comma15. ) /*compute the variables here*/
cancelled*(sum*f=comma15. pctsum<tot_cnt>)
_dec_eom_cnt*(sum*f=comma15. pctsum<tot_cnt>)
inb_outb_aft_cnt*(sum*f=comma15. pctsum<tot_cnt>);
label Month_sort = 'FP Payment Date' 
label tot_cnt = 'Sent to NCCI for Doorknock(142)'
label cancelled = 'Cancelled Next Day ',
label ext_wait_def = 'Extended Waiting on Deferral',
label _dec_eom_cnt = 'Decision By EOM',
label inb_outb_aft_cnt = 'RPC IB/OB CONTACT AFTER DOOR KNOCK',
label tot_cnt = 'Sent to NCCI for Doorknock(142)';
/ Box='FP Payment Date';
run;

For some reason only label Month_sort = 'FP Payment Date' works properly (the word label is in blue). The remaining label entries do not turn blue. Also I want to include /Box to define the FP Payment Date. Why are the remaining label entries not turning blue as well as the "box" not turning blue??

Re: Issue with labels in Proc Tabulate

Reeza — Mon, 09 Aug 2021 16:27:54 GMT

I think you applied it to the specific label, not the full header column as you seem to intend to do.

Re: Issue with labels in Proc Tabulate

ballardw — Mon, 09 Aug 2021 16:45:16 GMT

The label statement has two basic forms:

single variable and label text, as in

Label variablename='some text';

or a single Label followed my multiple variable="text" pairs. They are not comma separated lists

Yours does not follow either of those and I expect that you log shows some interesting notes.

Instead of

label Month_sort = 'FP Payment Date' 
label tot_cnt = 'Sent to NCCI for Doorknock(142)'
label cancelled = 'Cancelled Next Day ',
label ext_wait_def = 'Extended Waiting on Deferral',
label _dec_eom_cnt = 'Decision By EOM',
label inb_outb_aft_cnt = 'RPC IB/OB CONTACT AFTER DOOR KNOCK',
label tot_cnt = 'Sent to NCCI for Doorknock(142)';

Try

label Month_sort = 'FP Payment Date' 
      tot_cnt = 'Sent to NCCI for Doorknock(142)'
      cancelled = 'Cancelled Next Day '
      ext_wait_def = 'Extended Waiting on Deferral'
     _dec_eom_cnt = 'Decision By EOM'
     inb_outb_aft_cnt = 'RPC IB/OB CONTACT AFTER DOOR KNOCK'
     tot_cnt = 'Sent to NCCI for Doorknock(142)'
;
/ Box='FP Payment Date';

The editor was not showing the word "label" in blue because it was not in a valid position in the syntax so was not recognized as the key word label.