BookmarkSubscribeRSS Feed
tarheel13
Rhodochrosite | Level 12

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. 

lrackley_0-1608220052434.jpeg

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

 

Thanks!

6 REPLIES 6
RichardDeVen
Barite | Level 11

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

tarheel13
Rhodochrosite | Level 12

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

lrackley_0-1608224155432.pnglrackley_1-1608224203159.png

 

ballardw
Super User

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.

tarheel13
Rhodochrosite | Level 12

lrackley_0-1608223345564.png

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

lrackley_1-1608223428136.png

 

ballardw
Super User

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.

 

 

RichardDeVen
Barite | Level 11

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1296 views
  • 0 likes
  • 3 in conversation