SAS Visual Analytics - Data

KrisNori — Mon, 12 Sep 2016 16:16:02 GMT

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 ?

Re: SAS Visual Analytics - Data

ShannonMoore — Wed, 21 Sep 2016 21:03:52 GMT

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

topic Re: SAS Visual Analytics - Data in SAS Visual Analytics

SAS Visual Analytics - Data

Re: SAS Visual Analytics - Data