I was given this code for making turnip graphs. Can you make sense of this code?     ... View more

Your Blog post with code is interesting.   I would like to adapt the code you posted to my data, but was unable to make it work. Perhaps, the way my dataset is formatted is problematic, or the code needs to be modified to reflect the characteristics of my data.   I have attached an excell file that was created by exporting the SAS data set, MEDDISCH93TO13.   Can the graphics shown in your blog post be created using MEDDISCH93TO13? I suspect I have missed something simple   Jack Mohr Asheville, NC   ... View more

There is a reference to jitterwidth, but I was unable to find an example or an explaination of how to use  it.   Note: The Turnip Charts in the Dartmouth Atlas are produced using SAS. They have 306 observations which is the same number I have in my data for each year.  There must be a way to set parameters in SAS to disperse the points in the Turnip Chart   Even when I plot data for just one year, the dots overlap and are not spread out much   Here is the SAS code I used:   /* This program requires SAS 9.4 TS Level 1M1 or later */ %let gpath='.'; %let dpi=100;   proc template;   define style styles.blueBG;     parent = Styles.htmlblue;     style graphbackground  from graphbackground       "Abstract colors used in graph styles" /       color   = cxf0f0f7;   end; run;   /*--Medical Discharges 1993 to 2013--*/ data meddisch;   set WORK.MEDDISCH93TO13;     where Year = 2013;     run;   ods html close;   /*--Discrete X Axis--*/ ods listing style=styles.blueBG image_dpi=&dpi gpath=&gpath; ods graphics / reset width=10in height=7.5in imagename='Jitter_94'; title 'Bacterial Pneumonia Discharges per 1000 Medicare Enrollees for Hospital Referral Regions'; footnote j=l h=0.9 'This graphs uses jitter on discrete X axis'; proc sgplot data=meddisch noautolegend;   scatter x=Year y=BacterialPneumoniaDisch1k9313 / jitter     markerattrs=graphdata1(size=9 symbol=circlefilled)     filledoutlinedmarkers markeroutlineattrs=(thickness=0)     markerfillattrs=graphdata1 dataskin=sheen;   vbox BacterialPneumoniaDisch1k9313 / category=Year fillattrs=(transparency=0.5) nooutliers;   xaxis display=(nolabel) type=discrete;   /*xaxis display=(nolabel);*/   yaxis grid;   run;   title; footnote; ... View more

That looks better (see attached file) Ideally the dots would not overlap. I will try running the program for just one or two years worth of data to make room for scattering the dots.   I like the graphic with the box and whiskers overlay, but this was not my origional goal. My goal was to produce turnip charts that look like those in the Dartmouth Atlas of Healthcare (see attched file) where the dots are nicely distributed with minimal overlap ... View more

How do I make the numeric SAS variable, Year, a discrete variable? Can you point me to any documentation?   Here is the code I used to produced the attached graphic:   /* This program requires SAS 9.4 TS Level 1M1 or later */ %let gpath='.'; %let dpi=100;   proc template;   define style styles.blueBG;     parent = Styles.htmlblue;     style graphbackground  from graphbackground       "Abstract colors used in graph styles" /       color   = cxf0f0f7;   end; run;   /*--Orthopedic Hospital Dischares H--*/ data orthosurg;   set WORK.ORTHOSURGX; run;   ods html close;   /*--Discrete X Axis--*/ ods listing style=styles.blueBG image_dpi=&dpi gpath=&gpath; ods graphics / reset width=10in height=6.5in imagename='Jitter_94'; title 'Hip Replacement Surgeries per 1000 Medicare Enrollees for Hospital Referral Regions'; footnote j=l h=0.9 'This graphs uses jitter on discrete X axis'; proc sgplot data=orthosurg noautolegend;   scatter x=Year y=HipReplacementper1K9313/ jitter     markerattrs=graphdata1(size=9 symbol=circlefilled)     filledoutlinedmarkers markeroutlineattrs=(thickness=0)     markerfillattrs=graphdata1 dataskin=sheen;   vbox HipReplacementper1K9313 / category=Year fillattrs=(transparency=0.5) nooutliers;   xaxis display=(nolabel);   yaxis grid;   run;   title; footnote; ... View more

Thank you again for your assistance.  The attached PDF file is the chart I was able to produce   Jack E Mohr ... View more

I was able to produce this ... View more

Thank you so very much! I was able to make it work. Now I will tweak refinements to the display ... View more

I appreciate the value of your time and would be grateful if you could guide me to the point of having a SAS program that produces a turnip chart for my HLTHDATA.HIPS9213 SAS dat set.     I imported qry_hips.xlsx into a SAS data set into a library, HLTHDATA.HIPS9213. The attached pdf file is the output of proc contents on HLTHDATA.HIPS9213. It lists the variable names I will need to use. I should be able to access this SAS data set using the data step:   data WORK.HIPREP;   set HLTHDATA.HIPS9213; run;   What follows this data step? Where is the code that functions as the following sections of the original demo code?   data mydata;   format percent percentn9.2;   format cum_percent percentn9.2;   input mpg freq percent cum_percent;   percent=percent/100;   cum_percent=cum_percent/100;   Cat='A';   datalines; 11.57101  2  2.70   2.70 13.88521  8 10.81  13.51 16.19941  8 10.81  24.32 18.51361 17 22.97  47.30 20.82781  8 10.81  58.11 23.14201 12 16.22  74.32 25.45621  8 10.81  85.14 27.77042  3  4.05  89.19 30.08462  4  5.41  94.59 34.71302  3  4.05  98.65 41.65562  1  1.35 100.00 ; run;   /*--Expand the data--*/ data expand;   set mydata;   do i=1 to freq;    output;   end; run;   /*--Draw Graph--*/ title; ods html close; ods listing gpath=&gpath image_dpi=&dpi; ods graphics / reset width=7in height=7in imagename='Turnip'; proc sgplot data=expand;   scatter x=cat y=mpg / jitter;   refline 20;   xaxis display=(noticks novalues nolabel); run; ... View more

It appears that some of the code in the first demo code example is missing from the code you sent along with the Turnip Chart depicting multiple years.   Instead of importing the qry_hips.xlsx could I reference a SAS data set created by importing the qry_hips.xlsx to create a SAS dataset WORK.QRY_HIPS92TO13   I have tried running the code you sent, but I get multiple error messages including that the physical file qry_hips.xlsx can not be found or does not exist   Could you please forward a copy of all code used to produce the multi year Turnip Chart.  I should be able to produce similar charts using the SAS University Edition by changing a few variable names   I am facing a publication deadline   Thanks again for your help ... View more

Here is the code I ran. The excel file was located at C:\qry_hip.xlsx   %let gpath='.'; %let dpi=150; ods html close; ods listing image_dpi=&dpi gpath=&gpath;   /*--Read datra from Excel--*/ proc import datafile="C:\qry_hip.xlsx"      dbms=xlsx out=Hip_Replacement replace; run;   /*--Add some categories--*/ data hip;   set hip_replacement;   K01='K01'; K02='K02'; K03='K03'; K04='K04'; K05='K05'; run;   /*--Plot Graph--*/ ods graphics / reset width=5in height=3in imagename='Turnip_Hip'; proc sgplot data=hip nocycleattrs noautolegend;  scatter x=k01 y=HipReplacementper1K01 / jitter;  scatter x=k02 y=HipReplacementper1K02 / jitter;  scatter x=k03 y=HipReplacementper1K03 / jitter;  scatter x=k04 y=HipReplacementper1K04 / jitter;  scatter x=k05 y=HipReplacementper1K05 / jitter;  xaxis display=(noticks nolabel);  yaxis display=(nolabel); run; ... View more

I need to produce a series of Turnip Charts for all variables in this data set. It appears that you were able to successfully produce a Turnip Chart for one of the variables. Could you share the code? I assume that with the code I will be able to simply change the variable name   In an ideal world I would be able to display a Turnip Chart Graphic for multiple variables in the same output. See attached pdf file ... View more

The hipreplacement variable you chose is good. What does the sas code look like?   My professor asked me to produce a series of turnip graphs   Thank you ... View more

How do I adapt demo code to use my sas data set and variables   Can you suggest how I can produce turnip charts of variables in qry_hipReplacement1992to2013.xlsx   Greatly appreciative, jemohr22     ... View more