BookmarkSubscribeRSS Feed
rmalcata
Quartz | Level 8

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!

4 REPLIES 4
Ishwarkumar
Obsidian | Level 7
WEEKDATEw. is the date format

##- Please type your reply above this line. Simple formatting, no
attachments. -##
rmalcata
Quartz | Level 8

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
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
rmalcata
Quartz | Level 8

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1738 views
  • 0 likes
  • 3 in conversation