Having trouble adding a variable to the title

[LAtwood]

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

[Cynthia_sas · Accepted solution]

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

[LAtwood]

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

Lori