topic Proc report gray row before each group of subject, disease severity, and ae number in SAS Programming

Proc report gray row before each group of subject, disease severity, and ae number

tarheel13 — Thu, 17 Dec 2020 15:49:23 GMT

I have an adverse event dataset (AE). I am trying to create an AE listing. How can I put this gray row before each group of subject, disease severity, and ae number. Subjects can have more than 1 AE. Disease severity values are: mild, moderate, severe. Subject is the subject ID. Example: 001, etc.

There would also be other columns above like SOC, PT, relatedness, discontinued, outcome, category, etc.

Thanks!

Re: Proc report gray row before each group of subject, disease severity, and ae number

RichardDeVen — Thu, 17 Dec 2020 16:35:25 GMT

In a COMPUTE BEFORE <mygroup> block code a LINE "summary information string" statement. Show more of the data structure and actual report so additional help can be suggested regarding how the summary information string is constructed (i.e. should different fields show a list of value encountered in the group, etc...)

Re: Proc report gray row before each group of subject, disease severity, and ae number

ballardw — Thu, 17 Dec 2020 16:38:02 GMT

Please show the code you are currently using to create your proc report.

Best would be to include a small example data step to create data that we can use your report code with to test solutions. Some solutions might require adding variables to the data. If we don't have reasonable data to start with then assumptions might be made about the content of the data that do not work with your actual values.

If you are using any custom formats to display values the code for the formats needs to be included as well.

You might also consider removing style overrides and such not related to the specific question so the code is easier to follow.

Please post code in either a text box opened on the forum with either the </> or "running man" icons. The main message windows on this forum will reformat text and sometimes the result can be inserted or deleted characters that prevent the code from running as intended.

Re: Proc report gray row before each group of subject, disease severity, and ae number

tarheel13 — Thu, 17 Dec 2020 16:44:42 GMT

This makes the gray row that I want but the sev and aenum are not showing up. they are in the dataset though.

Re: Proc report gray row before each group of subject, disease severity, and ae number

ballardw — Thu, 17 Dec 2020 16:51:08 GMT

Pictures of partial code don't actually help much.

Many of the operations of Proc Report are column order dependent. Which is why I asked for the entire code.

And I can't copy a picture into my editor and test code, or make suggestions by editing text.

Re: Proc report gray row before each group of subject, disease severity, and ae number

RichardDeVen — Thu, 17 Dec 2020 16:52:34 GMT

You will need to show more (or all) of the code. The order of the variables in the COLUMNS statements and the DEFINE statements are important with regards to what goes on in a COMPUTE block

Re: Proc report gray row before each group of subject, disease severity, and ae number

tarheel13 — Thu, 17 Dec 2020 16:57:29 GMT

Example row would be Subject ID: 001, Disease Severity: Moderate, AE Number: 1. Need this row before every AE that a subject has.