Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to convert this function from SAP BO to SAS

Reply
Occasional Contributor
Posts: 14

How to convert this function from SAP BO to SAS

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.

 

 

PROC Star
Posts: 284

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

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

Occasional Contributor
Posts: 14

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

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)>)

Super User
Posts: 11,141

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

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.

Ask a Question
Discussion stats
  • 3 replies
  • 145 views
  • 0 likes
  • 3 in conversation