Having trouble adding a variable to the title

LAtwood — Thu, 30 Jun 2011 15:54:17 GMT

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

Re: Having trouble adding a variable to the title

Cynthia_sas — Thu, 30 Jun 2011 16:40:29 GMT

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

Having trouble adding a variable to the title

LAtwood — Thu, 30 Jun 2011 16:49:43 GMT

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

Lori

topic Having trouble adding a variable to the title in ODS and Base Reporting

Having trouble adding a variable to the title

Re: Having trouble adding a variable to the title

Having trouble adding a variable to the title