I have the following cancersitecategories in the "Cancersitecat" variable.
How do I create a new subcategory of variable called Breast total to sum both the breast categories?
Cancersitecat
breastinsitu female
breast invasive female
Colorectal
Lung and bronchus
Prostate
Total
Explain in more detail. What are we summing? Show us a small part of this data set so we can grasp the problem.
You could create a super category (CancerType) and get totals within each super category. With proc Tabulate as a summarizing procedure, it would be something like
data myNewData;
set myData;
if CancerSiteCat in ("breast insitu female", "breast invasive female") then
CancerType = "breast";
else CancerType = "other";
run;
proc tabulate data=myNewData;
class CancerType CancerSiteCat;
table CancerType*(CancerSiteCat all="Total") all="Grand Total", n;
run;
(untested)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.