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!
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...)
Example row would be Subject ID: 001, Disease Severity: Moderate, AE Number: 1. Need this row before every AE that a subject has.
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.
This makes the gray row that I want but the sev and aenum are not showing up. they are in the dataset though.
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.
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
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.
Ready to level-up your skills? Choose your own adventure.