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

Using expressions in query builder

Reply
Occasional Contributor
Posts: 11

Using expressions in query builder

I'm want to use the query builder to add an additional calculated field to my data, using a CASE or IF function to determine the result using two other fields (e.g if SellPrice = MarketPrice then "Marginal", if SellPrice < MarketPrice then "No Sale", if SellPrice > MarketPrice then "Profit").

The documentation of the expression builder is poor in all the help files and although this is something that could be built in the Report builder part of VA, it is not available in Exploration.

Is this possible?

James.

Ask a Question
Discussion stats
  • 0 replies
  • 260 views
  • 0 likes
  • 1 in conversation