Highlight field name matching current month

Reply
Contributor
Posts: 31

Highlight field name matching current month

Based on the code below I am labeling my field names.  I now want to highlight the entire column if it is the current month, how can I accomplish this?

select distinct

     catt('WORK.AllTotals(where=(Month="',Month,'")

     rename=(Open_Dollars_rd=',Month,'_Open_Dollars_rd Shipped_Dollars_rd=',Month,'_Shipped_Dollars_rd Project_Dlrs_rd=',Month,'_Project_Dlrs_rd))')

          into : list separated by ' '

from WORK.AllTotals

Super User
Posts: 19,052

Re: Highlight field name matching current month

What proc are you using to do you reporting, Report, Tabulate, Print?

I'm assuming you're not on SAS VA

Contributor
Posts: 31

Re: Highlight field name matching current month

I'm very new to SAS (< 5 months!)  I'm using SAS REPORT

Super User
Posts: 9,865

Re: Highlight field name matching current month

Post some data and the output you need.

And you'd better post it at ODS and Report Forum, Cynthia is there, since it is a proc report Question;

Contributor
Posts: 31

Re: Highlight field name matching current month

Thank you, I went ahead and did that.

Ask a Question
Discussion stats
  • 4 replies
  • 237 views
  • 0 likes
  • 3 in conversation