topic Re: Week as a date format in VA in SAS Visual Analytics

Week as a date format in VA

rmalcata — Thu, 09 Feb 2017 00:54:31 GMT

Hi,
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.

Thank you!

Re: Week as a date format in VA

Ishwarkumar — Tue, 14 Feb 2017 10:44:58 GMT

WEEKDATEw. is the date format

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Week as a date format in VA

rmalcata — Tue, 14 Feb 2017 19:29:48 GMT

Is that date format available on the 7.3 Visual Analytics?

It doesn't appear among the possibilities to choose from. Do I have to create a format and input it?

Cheers

Rita

Re: Week as a date format in VA

MichelleHomes — Tue, 14 Feb 2017 22:53:20 GMT

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.

Kind Regards,

Michelle

Re: Week as a date format in VA

rmalcata — Tue, 14 Feb 2017 23:08:59 GMT

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#n1lxnqfip132can1hdzuerib7i76.htm 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.

Regards,

Rita