That's great, thank you so much Ksharp!!
That heatmap looks great, I really want to try it with my data but I was having problems when inputting my data in the first data step. One of my variables is ' Ethnicity' (7 levels) and the other one is 'overall1' which is a score that goes from 1 to 9 (1 2 3 4 5 6 7 8 9). I put it like this in Col but it didn't work out. I highlighted the statement "do" and "count" because I'm not sure what to include in them. Count should be the numbers I have after each ethnicity level which is the freq of each score for every level of ethnicity. I hope it makes sense. I would greatly appreciate if you could help me.
data one(drop=f: i); input Row $ 1-7 f1-f9; array f[9]; do i = 0 to 5; Col = 1 2 3 4 5 6 7 8 9; Count = i; output; end; datalines; Asian 0 0 0 1 4 3 6 4 0 African American 0 1 7 16 8 37 57 44 8 Caucasian 0 1 4 13 6 24 51 38 9 Hispanic 0 0 0 0 0 0 0 0 0 Native American 5 1 12 24 24 82 108 90 12 Middle Eastern 0 1 2 10 15 24 31 27 6 Pacific Islander 0 0 1 0 0 3 0 0 0 ;
... View more
