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
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
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
Thanks again Cynthia! Those were the two steps I was missing.
Lori
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.