topic Re: Creating Custom Category in SAS VA in SAS Visual Analytics

Creating Custom Category in SAS VA

Ramakanthkrovi — Thu, 25 Jul 2019 05:55:05 GMT

This is a query on the basis of the following thread

https://communities.sas.com/t5/SAS-Visual-Analytics/Create-a-custom-category-in-SAS-VA-using-2-different-source/m-p/553671#M12335

I have a different issue compared to the one above. I need to create a custom category/ calculated item which is unique.

I have attached the screenshot to understand it better - In the bar chart, "Group" is a sum of all revenue across all regions (including APAC, Europe and Americas), APAC is just APAC and "Rest of the world" is Europe and Americas. They are all built off the same variable. I need to create a category/ calculated item to use in a bar chart and assign values accordingly.

Of course the below code doesn't work but below is a sample of how I expect it to work.

IF ( 'Geo'n In ('APAC', 'Europe', 'North America', 'Enterprise') )
RETURN 'Group'
ELSE (
IF ( 'Geo'n = 'APAC' )
RETURN 'APAC'
ELSE 'Rest of the World'

Re: Creating Custom Category in SAS VA

SASKiwi — Thu, 25 Jul 2019 06:38:44 GMT

Looks like you are missing a bracket at least:

IF ( 'Geo'n In ('APAC', 'Europe', 'North America', 'Enterprise') )
RETURN 'Group'
ELSE (
IF ( 'Geo'n = 'APAC' )
RETURN 'APAC'
ELSE 'Rest of the World')

Re: Creating Custom Category in SAS VA

Ramakanthkrovi — Thu, 25 Jul 2019 06:44:11 GMT

True, but that was what I put together quickly to help you understand the problem.

Because I am including all values of 'Geo' to create 'Group' - the new calculated item will always have only one value - Group.

Re: Creating Custom Category in SAS VA

SASKiwi — Thu, 25 Jul 2019 07:31:18 GMT

Another reason this is not going to work is you have APAC both in the "GROUP" and as its own category. I suspect you will have to create two custom categories, one for GROUP, and another for APAC/Rest of World. Give it a try.

Re: Creating Custom Category in SAS VA

GertNissen — Thu, 25 Jul 2019 09:23:02 GMT

Try

IF ( Geo= 'APAC' )
RETURN 'APAC'
ELSE 'Rest of the World'

Re: Creating Custom Category in SAS VA

Ramakanthkrovi — Thu, 25 Jul 2019 22:48:24 GMT

Exactly, that is the problem. I want to create a category which is custom and I already explained that in the initial question.

it is like writing

sum(All geos) = "Group"

APAC = "APAC"

sum(all geos) - APAC = "RoW"

that is the custom category. is it possible in SAS VA?

Re: Creating Custom Category in SAS VA

SASKiwi — Sat, 27 Jul 2019 22:19:27 GMT

You can't sum a character column. I suggest you experiment with splitting your customer category into two separate ones as already discussed.