The SAS Output Delivery System and reporting techniques

Having trouble adding a variable to the title

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 83
Accepted Solution

Having trouble adding a variable to the title

I am having a problem adding "pay_period" variable to a title using Proc Report. I am trying to use #byval.  This is a stored process.

I have attached the code.

Thanks

Lori

Attachment

Accepted Solutions
Solution
‎06-30-2011 12:40 PM
SAS Super FREQ
Posts: 8,862

Re: Having trouble adding a variable to the title

Really simple things to check:

  1) the use of #byval reuires that you have a BY statement in your code. So even if you have PAY_PERIOD in your COLUMN and even if you have the reference to #BYVAL in your TITLE statement, you still need to use a BY statement  inside the PROC REPORT code, such as:

BY PAY_PERIOD;

also in your PROC REPORT step in order for the reference in the title statement to work.

   

  2) Usually, in order to use #BYVAL/#BYLINE/etc, you also need:

OPTIONS NOBYLINE; before the step that contains the special by variable reference.

  

Generally, the use of the BY variable special strings works very well with ODS -- so even in a stored process, you should see the use of the information (do note that in order to use a BY statement in PROC REPORT, the data must be sorted, by PAY_PERIOD). If you have checked #1 and #2 and your BY reference still does not work, you should open a track with Tech Support on this matter.

cynthia

View solution in original post


All Replies
Solution
‎06-30-2011 12:40 PM
SAS Super FREQ
Posts: 8,862

Re: Having trouble adding a variable to the title

Really simple things to check:

  1) the use of #byval reuires that you have a BY statement in your code. So even if you have PAY_PERIOD in your COLUMN and even if you have the reference to #BYVAL in your TITLE statement, you still need to use a BY statement  inside the PROC REPORT code, such as:

BY PAY_PERIOD;

also in your PROC REPORT step in order for the reference in the title statement to work.

   

  2) Usually, in order to use #BYVAL/#BYLINE/etc, you also need:

OPTIONS NOBYLINE; before the step that contains the special by variable reference.

  

Generally, the use of the BY variable special strings works very well with ODS -- so even in a stored process, you should see the use of the information (do note that in order to use a BY statement in PROC REPORT, the data must be sorted, by PAY_PERIOD). If you have checked #1 and #2 and your BY reference still does not work, you should open a track with Tech Support on this matter.

cynthia

Frequent Contributor
Posts: 83

Having trouble adding a variable to the title

Posted in reply to Cynthia_sas

Thanks again Cynthia!  Those were the two steps I was missing.

Lori

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 147 views
  • 0 likes
  • 2 in conversation