I am trying to find a way to create a bar graph with mutiple disease types on it, while also grouping it by race. To do so (or at least how I know how to do it), I need a data set with the frequenceies of each disease type by race. I have variables Diseasetype1-Diseasetype10 and Race. I am hoping it will be something along the lines of creating a data set after a freq statement with all the disease types by all the race types?
I did this before just looking at the disease type as followed:
ods output onewayfreqs=diseasetables;
proc freq data=Disease;
tables diseasetype1 -- diseasetype10;
run;
Anyone have a solution that would be close to that but with disease crossed with race?
Transpose your data and then try and use a graphing procedure.
Your data should be in the structure, as follows:
Race DiseaseCount Disease
race1 1 DA
race1 2 DB
race1 3 DC
....
Once your data is in this structure you should be good to use a variety of methods.
Transpose your data and then try and use a graphing procedure.
Your data should be in the structure, as follows:
Race DiseaseCount Disease
race1 1 DA
race1 2 DB
race1 3 DC
....
Once your data is in this structure you should be good to use a variety of methods.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.