topic operation on SAS VA in SAS Visual Analytics

operation on SAS VA

pablo29 — Thu, 13 Aug 2020 08:29:37 GMT

Hi.

ON SAS VA I have to perform a subtraction among two variable, representing two years, types are character. But SAS VA give me mistake. Have you advice?

Thanks to everyone 🙂

Re: operation on SAS VA

mohd-danshaik — Thu, 13 Aug 2020 16:40:57 GMT

Hi Pablo,

Can you please post a screen shot of what you are trying to do?

Re: operation on SAS VA

Sam_SAS — Thu, 13 Aug 2020 19:15:15 GMT

Hello,

Dates in Visual Analytics are SAS dates and can be tricky to perform basic math on. The best approach to handling them will depend on what exactly you are trying to do.

Sam

Re: operation on SAS VA

PetriRoine — Mon, 17 Aug 2020 13:02:06 GMT

Hello @pablo29

Did I understand correctly that your year variable is actually a character string, not actual numbers/date? If this is the case then you first need to create a new date type variable from the character string. You can do this f.ex. by using Substring, Parse and DateFromMDY functions.

Is your year variable just four digits (2020) or more like a date (2020-08-17)? You could create a numeric variable just for year, but I personally prefer to create date variables with year format as it enables use of VA's periodic operators.

You can calculate differences between date variables by utilizing TreatAs (_number_) function. First you convert your date type variable to numbers, then calculate the difference, and finally convert number type variable back to date type variable by using TreatAs second time. It's actually very easy and straightforward even though it might not sound like it.

Btw. which version of VA you have?

Best regards,

Petri