## Histogram on qualitative data

Solved
Regular Contributor
Posts: 218

# Histogram on qualitative data

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:

Accepted Solutions
Solution
‎06-22-2015 12:42 PM
Community Manager
Posts: 3,183

## Re: Histogram on qualitative data

Try something like this:

proc sgplot data=pnl;
vbar date / stat=freq

groupdisplay=cluster group=Outcome;
run;

Chris

All Replies
Solution
‎06-22-2015 12:42 PM
Community Manager
Posts: 3,183

## Re: Histogram on qualitative data

Try something like this:

proc sgplot data=pnl;
vbar date / stat=freq

groupdisplay=cluster group=Outcome;
run;

Chris

Regular Contributor
Posts: 218

## Re: Histogram on qualitative data

Thanks Chris, It worked!!!

Regular Contributor
Posts: 218

## Re: Histogram on qualitative data

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,

Community Manager
Posts: 3,183

## Re: Histogram on qualitative data

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

Regular Contributor
Posts: 218

## Re: Histogram on qualitative data

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?

Community Manager
Posts: 3,183

## Re: Histogram on qualitative data

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

Regular Contributor
Posts: 218

## Re: Histogram on qualitative data

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;

🔒 This topic is solved and locked.