Creation of new subcategory of Variable by summing existing variables

Reply
Learner
Posts: 1

Creation of new subcategory of Variable by summing existing variables

 

 

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

 

Trusted Advisor
Posts: 1,498

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

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

Respected Advisor
Posts: 4,607

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

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)

PG
Ask a Question
Discussion stats
  • 2 replies
  • 237 views
  • 0 likes
  • 3 in conversation