Hellow all,
I want to output table header without the numbers and @ sign, but use #byval(param) in the code, sorted by param, to avoid alphabetical sorting, so customize the order using numbers to control the order
My code is as follows:
@joycefilm wrote:
param values cannot be sorted alphabetically, so I use numbers to customize the order. Now I want to output tables without numbers
If I am understanding you properly, you want to create a variable that has the value with numbers and @ sign (I think you already have that), let's call this variable PARAM, and another variable named PARAM1 which does not have the numbers and @ sign.
Then sort by both PARAM and PARAM1, set the options NOBYLINE, and in PROC REPORT use
by param param1;
Then in the title statement refer to #BYVAL2.
PROC SORT does not display printed output, so it is not going to work with #byval. Nor is there are DEFINE or BREAK statement in PROC SORT. Are you trying to do this with PROC REPORT?
Please provide code that works EXCEPT for the #byval part, then it should be really simple to add in #byval to the title.
@joycefilm wrote:
param values cannot be sorted alphabetically, so I use numbers to customize the order. Now I want to output tables without numbers
If I am understanding you properly, you want to create a variable that has the value with numbers and @ sign (I think you already have that), let's call this variable PARAM, and another variable named PARAM1 which does not have the numbers and @ sign.
Then sort by both PARAM and PARAM1, set the options NOBYLINE, and in PROC REPORT use
by param param1;
Then in the title statement refer to #BYVAL2.
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!