BookmarkSubscribeRSS Feed
Q1983
Lapis Lazuli | Level 10
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??

2 REPLIES 2
Reeza
Super User
I think you applied it to the specific label, not the full header column as you seem to intend to do.
ballardw
Super User

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. 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 867 views
  • 0 likes
  • 3 in conversation