topic Re: How to convert this function from SAP BO to SAS in SAS Visual Analytics

How to convert this function from SAP BO to SAS

GS10 — Fri, 19 May 2017 14:59:43 GMT

Hi,

=Sum((If <Trans Code (num)>=XX Then <Trans Number of Trans>) ForEach <Trans Code (num)>)

I m trying to convert a report from the mentioned BI Tool, I understnad the function partially. As I can do it individually with if function, but can we do aggrgated function with boolean as we do not find the option of aggregated fields while creating any calculated field. Please answer.

Re: How to convert this function from SAP BO to SAS

kiranv_ — Fri, 19 May 2017 16:23:29 GMT

if you can give a small example with data then it will be easy to help you.

Re: How to convert this function from SAP BO to SAS

GS10 — Mon, 22 May 2017 13:39:05 GMT

Hi,

This is the example I have mentioned in my post.

=Sum((If <Trans Code (num)>=XX Then <Trans Number of Trans>) ForEach <Trans Code (num)>)

Re: How to convert this function from SAP BO to SAS

ballardw — Mon, 22 May 2017 17:05:45 GMT

The request for data such as @kiranv_ is to show some actual values and what the result of that function would be.

Since this is SAS forum it is very possible that few of the users actually are familiar with SAP. I know that I know nothing about SAP.

But with example data sometimes I can work out a procedure that mimics displayed values.

Further complication is that Visual Analytics has a different set of data manipulation tools available than Base SAS or EG or Studio. So an example may be even more important for the subset of forum participants that know VA.