topic Re: Creating Calculating Items in SAS VA 7.3 in SAS Visual Analytics

Creating Calculating Items in SAS VA 7.3

GS10 — Tue, 28 Mar 2017 19:11:11 GMT

Hi,

I m trying to create a calculated fieldfor a report. I have to create an item with a range and I using If else boolean for this. Here, i have to get the output as numeric with combination of date and numeric. i m not able to create an item with date and range between numeric where as the ouput should be a nuemeric. Please suggest..

Re: Creating Calculating Items in SAS VA 7.3

Sam_SAS — Tue, 28 Mar 2017 19:31:41 GMT

Hello,

Can you provide some more information about the calculated expression that you want to create?

Do you need to compare numerics and dates?

It wouldn't be as simple as something like this would it?

IF ( 'Date'n BetweenInclusive('7MAR2017'd, '28MAR2017'd) )
RETURN 'Profit'n
ELSE .

Thanks,

Sam

Re: Creating Calculating Items in SAS VA 7.3

GS10 — Tue, 28 Mar 2017 20:31:29 GMT

Yes..

IF ( 'Numeric'n BetweenInclusive('numeric', 'numeric') )
RETURN 'text string'n
ELSE .

Re: Creating Calculating Items in SAS VA 7.3

Sam_SAS — Wed, 29 Mar 2017 13:02:02 GMT

Are you getting a message about argument types not matching?

In the VA expression syntax, . is a numeric missing value and '.' is a character missing value. If your RETURN parameter is character, then try,

IF ( 'Numeric'n BetweenInclusive('numeric', 'numeric') )
RETURN 'text string'n
ELSE '.'

Re: Creating Calculating Items in SAS VA 7.3

GS10 — Wed, 29 Mar 2017 15:08:30 GMT

Yes..

Re: Creating Calculating Items in SAS VA 7.3

GS10 — Thu, 30 Mar 2017 20:13:13 GMT

Can someone solve this ??

Re: Creating Calculating Items in SAS VA 7.3

Sam_SAS — Thu, 30 Mar 2017 20:24:06 GMT

Did you try putting quotes around the missing value for your ELSE statement?

Re: Creating Calculating Items in SAS VA 7.3

GS10 — Wed, 19 Apr 2017 20:29:19 GMT

Thanks! Yes, I tried it and its working.

Re: Creating Calculating Items in SAS VA 7.3

Sam_SAS — Thu, 20 Apr 2017 11:56:01 GMT

Great! Thanks for following up.