I want to draw a simple quadrant graph in SAS. The example of the data is:
Hospital_name death_rate_2013 diff_compare_with_2015
AA1 1.2 -0.5
AA2 1.5 0.1
AA3 0.8 0
AA4 1.0 -0.4
AA5 1.9 0.4
AA6 1.4 0.1
AA7 0.5 -0.2
I want the horizontal axis be: Low death rate (on the left) and high death rate (on the right)
Vertical axis: Low reduction (bottom) and high reduction (top)
And in the graph to show where each hospital is placed. How can I do it?
It sounds like you want a basic scatter plot with markers labeled by the hospital name:
data Have; input Hospital_name $3. death_rate_2013 diff_compare_with_2015; datalines; AA1 1.2 -0.5 AA2 1.5 0.1 AA3 0.8 0 AA4 1.0 -0.4 AA5 1.9 0.4 AA6 1.4 0.1 AA7 0.5 -0.2 ; proc sgplot data=Have; scatter x=death_rate_2013 y=diff_compare_with_2015 / datalabel=Hospital_name; run;
For more about creating simple graphs in SAS, see the SGPLOT documentation. Click the link for the SCATTER statement to learn more about options that are available for scatter plots.
It is not clear what features of that graph are important, but try the following:
data Have; input Hospital_name $3. death_rate_2013 diff_compare_with_2015; datalines; AA1 1.2 -0.5 AA2 1.5 0.1 AA3 0.8 0 AA4 1.0 -0.4 AA5 1.9 0.4 AA6 1.4 0.1 AA7 0.5 -0.2 ; proc means data=Have mean; var death_rate_2013; /* use mean value for reference line */ run; proc sgplot data=Have noborder; text x=death_rate_2013 y=diff_compare_with_2015 text=Hospital_name; refline 1.1857143 / axis=x; /* use mean value (?) */ refline 0 / axis=y; xaxis display=(noline noticks novalues); yaxis display=(noline noticks novalues); run;
I'm assuming your talking about the quandrant labels. The easiest way for you to do that is to use INSET statements. To see how this would work, take the code Rick provided and add the following to the SGPLOT procedure:
inset "TopLeft" / position=topleft;
inset "Top" / position=top;
inset "TopRight" / position=topright;
inset "Right" / position=right;
inset "BottomRight" / position=bottomright;
inset "Bottom" / position=bottom;
inset "BottomLeft" / position=Bottomleft;
inset "Left" / position=left;
If you want the text split onto multiple lines, just break the text using multiple quoted strings:
inset "Bottom" "Right" / position=bottomright;
Hope this helps!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.