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

SAS Visual Analytics - Data

Reply
Occasional Contributor
Posts: 19

SAS Visual Analytics - Data

[ Edited ]

Hi,

 

I have uploaded a table to SAS LASR server. The table has the below data.

 

Month      Value

Jan          1000

Feb          1500

.........................

Dec          2000

 

I wanted to work on a particular month's data (say, Feb)

 

I created a calculated data item (Feb_Val) as below:

 

IF (RemoveBlanks('Month'n, _All_) = 'Feb')

RETURN ('Value'n * 0.1)

ELSE 0

 

However, I don't get the value 150 in the Calculated data item, but get 0. Can some one help ?

SAS Employee
Posts: 19

Re: SAS Visual Analytics - Data

KrisNori, I just tested this in VA 7.3 Designer and it worked fine for me. I created a LASR table by importing a small excel file and then created the calculated item using your formula. What does the table look like in VA for you? My screen shot shows the new item and the values to the left.  Shannon


Capture.PNG
Ask a Question
Discussion stats
  • 1 reply
  • 262 views
  • 0 likes
  • 2 in conversation