topic Re: proc report summarize in ODS and Base Reporting

proc report summarize

kuppusamy — Wed, 08 May 2019 13:48:31 GMT

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".

Re: proc report summarize

Vish33 — Wed, 08 May 2019 14:06:53 GMT

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

Re: proc report summarize

Cynthia_sas — Wed, 08 May 2019 14:09:12 GMT

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

Re: proc report summarize

ballardw — Wed, 08 May 2019 15:05:17 GMT

@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