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)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.