topic Re: Adding subcategories to the table in SAS Programming

Adding subcategories to the table

Jedrzej — Wed, 19 Jan 2022 11:26:20 GMT

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.

Re: Adding subcategories to the table

LinusH — Wed, 19 Jan 2022 12:38:28 GMT

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

Re: Adding subcategories to the table

ballardw — Wed, 19 Jan 2022 15:51:11 GMT

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.