Hi,
to the existing table like this:
Grade | Arm A | Arm B | |
System organ class | Overall | 10 (100%) | 20 (100%) |
Grade 2 | 7 (70%) | 10 (50%) | |
Grade 4 | 3 (30%) | 10 (50%) |
i would like to add more subcategories for grade (Grade 1, Grade 3) and show for Arm A, Arm B 0 (0) as their values. The table should look like this
Grade | Arm A | Arm B | |
System organ class | Overall | 10 (100%) | 20 (100%) |
Grade 1 | 0 (0) | 0 (0) | |
Grade 2 | 7 (70%) | 10 (50%) | |
Grade 3 | 0 (0) | 0 (0) | |
Grade 4 | 3 (30%) | 10 (50%) |
is there an easy way how to do it ?
Thank you in advance.
Sorry, but I'm issing the context here.
Is this a report, and how do you creatre it now?
How does your source data look like?
Generally speaking, if you source data have new values it will pop up in report automatically (unless there is an active filter).
Is this a report table? If so, show the code used to create the report.
If not, how is the data set created?
Since you are attempting to display data that does not exist then you have to provide the missing information for the Grade variable somehow. One of the approaches relies on an option PRELOADFMT but that is only available to some procedures and requires you to create a custom format for all the values of the variables.
Or you merge in some values to your data set so that the value Grade appear and use options to force the likely missing values for ArmA and ArmB to calculate.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.