Creation of new subcategory of Variable by summing existing variables

[Anushuya]

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

[PaigeMiller]

Explain in more detail. What are we summing? Show us a small part of this data set so we can grasp the problem.

[PGStats]

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)