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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.