I am using web report studio but i have a problem that how can i group data together for example ,
i have record#1product A amount 100
record#2 product B amount 200,
I would like to combine product A and B to see the amount of A and B, let say product AB with amount_ab=100+200 =300 . Can web report studio do it ?
This is not an ODS or BASE SAS (Print, Report or Tabulate) question. Web Report studio can only work with data sources that have information maps or can receive reports from stored processes. What you want to do is possible, but will either require the use of a format in an information map, the use of a format when you design the report in Web Report Studio or the use of a format in a stored process.
In the Enterprise Intelligence platform, formats must be defined before use and stored in a special place in the metadata. You need to contact either the SAS Administrator for your installation for more help or contact SAS Tech Support for help.
To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".