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)
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.