Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Week as a date format in VA

Reply
Contributor
Posts: 39

Week as a date format in VA

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!

Occasional Contributor
Posts: 18

Re: Week as a date format in VA

WEEKDATEw. is the date format

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Contributor
Posts: 39

Re: Week as a date format in VA

Posted in reply to Ishwarkumar

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

Trusted Advisor
Posts: 1,321

Re: Week as a date format in VA

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

Contributor
Posts: 39

Re: Week as a date format in VA

Posted in reply to MichelleHomes

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

Ask a Question
Discussion stats
  • 4 replies
  • 221 views
  • 0 likes
  • 3 in conversation