Graphing frequencies of many variables

[sasuser31]

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?

[Reeza · Accepted solution]

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.