topic Re: Histogram on qualitative data in Graphics Programming

Histogram on qualitative data

mlogan — Mon, 22 Jun 2015 02:19:24 GMT

Hi All,

I would appreciate if anyone can tell me the code to draw a histogram from the following qualitative data.

Thanks,

Date	Outcome
01-Mar-2014	Loss
27-Feb-2015	Profit
27-Feb-2014	Loss
24-Feb-2014	Profit
01-Mar-2015	Loss
26-Feb-2015	Loss
01-Mar-2015	Loss
01-Mar-2015	Loss
01-Mar-2015	Loss
01-Mar-2015	Profit
01-Mar-2014	Profit
01-Mar-2014	Profit
01-Mar-2014	Profit
25-Feb-2014	Profit

OUTPUT:

Re: Histogram on qualitative data

ChrisHemedinger — Mon, 22 Jun 2015 16:42:51 GMT

Try something like this:

proc sgplot data=pnl;
vbar date / stat=freq 
  groupdisplay=cluster group=Outcome;
run;

Chris

Re: Histogram on qualitative data

mlogan — Mon, 22 Jun 2015 17:40:11 GMT

Thanks Chris, It worked!!!

Re: Histogram on qualitative data

mlogan — Mon, 22 Jun 2015 17:56:21 GMT

Hi Chris,

Do you know by any chance if there is a way to plot the days in the X axis only. I mean Instead of putting all dates, I want to put the days (Monday to Sunday) only. I am not sure if SAS can extract days from dates.

Thanks,

Re: Histogram on qualitative data

ChrisHemedinger — Mon, 22 Jun 2015 18:04:00 GMT

Of course SAS can do that -- that's the power of SAS formats!

proc sgplot data=pnl;
format Date weekdate10.; 
vbar date / stat=freq 
  groupdisplay=cluster group=Outcome;
run; 

Chris

Re: Histogram on qualitative data

mlogan — Mon, 22 Jun 2015 18:20:47 GMT

Thanks Chris, I just changes my data and uploaded a new pic, can you please tell me what would be the code for creating a run chart on 2 different year?

I much appreciate your help.

Re: Histogram on qualitative data

ChrisHemedinger — Mon, 22 Jun 2015 19:23:41 GMT

You new drawing looks like a Series plot. Series plots need two numeric variables: the date for the X axis and then -- in your case -- the frequency/day for the Y axis? You can use PROC FREQ or PROC SQL to calculate those frequencies, then feed that into a SERIES plot (using PROC SGPLOT and the SERIES statement), grouping it by YEAR.

You can find an index of great samples here:

Graphically Speaking Blog, Visual Index

Chris

Re: Histogram on qualitative data

mlogan — Wed, 24 Jun 2015 02:16:27 GMT

Hi Chris,

Your instruction is working, but I have both year data for the month of February and March only. When I plot them with the following code it leaves a huge gap in the middle (from apr 2014 to jan 2015) of the X axis. Can you please help?

proc template;

define statgraph tes1;

begingraph / subpixel=on;

entrytitle 'test title';

layout overlay / xaxisopts=(display=(ticks tickvalues))

yaxisopts=(griddisplay=on);

seriesplot x=Start_date y=count / group=Visit_concern name='a' lineattrs=(thickness=1) smoothconnect=true;

scatterplot x=Start_date y=count / group=Visit_concern markerattrs=(symbol=circlefilled color=white size=1);

/*scatterplot x=Start_date y=count / group=Visit_concern markercharacter=label; --- this brings the circular data points*/

discretelegend 'a' / title='Legend' itemsize=(linelength=10px) location=inside across=1 halign=right valign=top;

endlayout;

endgraph;

end;

run;