topic Creation of new subcategory of Variable by summing existing variables in SAS Programming

Creation of new subcategory of Variable by summing existing variables

Anushuya — Fri, 02 Oct 2015 20:11:01 GMT

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

Re: Creation of new subcategory of Variable by summing existing variables

PaigeMiller — Fri, 02 Oct 2015 21:12:42 GMT

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

Re: Creation of new subcategory of Variable by summing existing variables

PGStats — Sun, 04 Oct 2015 03:33:14 GMT

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)