02-08-2017 07:54 PM
Is there any update on having a date format for week. I am aware you can determine the week number from the actual day. however, I want to use calculation (e.g. parellelperiod) that would only work properly for a date/time variable not a category.
02-14-2017 05:53 PM
You're correct Rita.
Not all BASE SAS date formats are supported in SAS Visual Analytics and as you've found the WEEKDATEw. format isn't available. You may need to do your calculations as part of your data preparation prior to loading.
02-14-2017 06:08 PM
yes, I understood that the week format wasn't available. My question was if there was a away to make it available.
In previous conversations, this was as far as I got
"let me start with the second part of your email where you ask "... is there away to customize the format of day as date aside from the options shown available?". Aside from the provided formats in VA it is possible to define your own formats and this is covered in a SAS note available at http://support.sas.com/kb/47/100.html. As far as the other part of your question is concerned, using the format you design yourself may be the answer. As stated in the User Guide http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n1lxnqfip132can1hdzue... the periodic item is supported only where data items with a format that specifies the year are available."
I'm not sure if this will work as I haven't used it.