Hi , Please can you refer any document to details  1 and 2 ... View more

This is a known SAS limitation, with a recent discussion here: https://communities.sas.com/thread/48679 Good luck. ... View more

I believe that you can get the display in SampleReport1 by opening the Properties for the bar chart, selecting the Bar tab, and specifying "Stacked" under "Subgroup". (Note that this option is only available if a data item is assigned to the Bar Subgroup role.) ... View more

You could try using the export wizard from SAS Management Console to export the report. Then, re-import the report, specifying your new data source. Make sure you have a back-up of the report before trying this. ... View more

Have you investigated Proc Rank?  It is designed to do this job for you. Richard ... View more