Creating a bar graph when there are multiple measures

[jb9977]

Hello every one,

I have data as follows

report_dt        New  incomplete       comlete     pending       referrals          incomplete_gt_5         incomplete_lt_5

19sept2017   5000      4000                 1000        100                  60                        9000                   4500

How can create a graph similar to attached using proc sgplot

Thanks,

Jay

[Reeza]

Transpose it to a long format using PROC TRANSPOSE.

Then use PROC SGPLOT with VBARPARM statement to create a bar graph.

This example is more complicated that what you need but it should give you the idea.

Colours are controlled by the STYLE tempate, which you can change or you can explicitly set them to what you need using a STYLEATTRS statement.