In report col lead generated instead of "Total OCC A&C" , I want "Total Digital" But In a program how to edit the macro variables to get "Total Digital".
Hello,
as in the attached document , it is the value of column "how" which is adding after each category .
Its like Total &category. , if the category value equals "Digital" then dynamically it will allocate the value as "Total Digital" otherwise you may need to hard code the value which will appear after all categories.
Thanks
Vish
Hi:
I don't see any macro variables in your code, although your screen shot was VERY hard to read. To get Total Digital, at the summary line, you'd have to change your program logic. Right now, you're using PRETEXT as a style override, which is putting the string 'Total' in front of the group value. But if you want it to be some OTHER string, then you need to use a different technique, something like this:
Hope this helps,
Cynthia
@kuppusamy wrote:
In report col lead generated instead of "Total OCC A&C" , I want "Total Digital" But In a program how to edit the macro variables to get "Total Digital".
Please do not post pictures of CODE or Log results. Copy from the text from the editor or Log and paste into a code box opened on the forum using the {I} or "running man" icons. One issue with your specific image is that you have code that runs past the margins of the image. So we don't even have the complete code that you attempted to show.
If you are using macro variables, ensure to include the place that you set the variables as well as how you are attempting to use them.
Also post complete procedure code not just snippets from the middle of a procedure. From the partial code you show we cannot tell:
1) which variable or column you are referencing
2) what the current label might be for the variable (likely default value in a column heading)
3) why you think you need any macro variable to set a heading: the define statement will do that without any macro code needed
4) what you may have attempted that would have changed the displayed heading
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 16. 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: