Week as a date format in VA

[rmalcata]

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!

[Ishwarkumar]

WEEKDATEw. is the date format

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

[rmalcata]

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

[MichelleHomes]

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

[rmalcata]

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.

Regards,

Rita