BookmarkSubscribeRSS Feed
Jedrzej
Obsidian | Level 7

Hi,

 

to the existing table like this:

 GradeArm AArm B
System organ classOverall10 (100%)20 (100%)
 Grade 27 (70%)10 (50%)
 Grade 43 (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

 

 GradeArm AArm B
System organ classOverall10 (100%)20 (100%)
 Grade 10 (0)0 (0)
 Grade 27 (70%)10 (50%)
 Grade 30 (0)0 (0)
 Grade 43 (30%)10 (50%)

 

 

is there an easy way how to do it ? 

 

Thank you in advance.

2 REPLIES 2
LinusH
Tourmaline | Level 20

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

Data never sleeps
ballardw
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 319 views
  • 0 likes
  • 3 in conversation