topic Re: Day of Week shows up weird in report! in SAS Visual Analytics

Day of Week shows up weird in report!

blewsas — Wed, 21 Aug 2019 21:05:38 GMT

When I view my heat map in the Editor, the days of week (Sunday, Monday, etc.) show up properly (except that I can't custom sort them - see my other post from today).

However, when I view the same heat map in the Report, they show up as "o3Jan1960", "04Jan1960", etc. Any ideas why? SAS VA 8.3

Re: Day of Week shows up weird in report!

VDD — Wed, 21 Aug 2019 22:25:54 GMT

without seeing your code it is a best guess. I would say you are applying a format to the column that contains a date value.

create a new column that contains the string value that represents the day of the week and use that new column in your report.

Re: Day of Week shows up weird in report!

FredrikE — Thu, 22 Aug 2019 06:45:30 GMT

That's a really weird behaviour, maybe something for sas support....:)

//Fredrik

Re: Day of Week shows up weird in report!

ballardw — Thu, 22 Aug 2019 15:48:45 GMT

My guess, since I have never had access to VA, is that the transform to get the day of week from a date value inherited the date variables format because you did not explicitly override it and that is what the report used by default.

Re: Day of Week shows up weird in report!

blewsas — Thu, 22 Aug 2019 22:12:15 GMT

Yes, my calculation is

DatePart('Offence TMST'n)

And I am applying the "Day of Week" format to this.

How do I "create a new column that contains the string value that represents the day of the week and use that new column in your report."?

Thanks!

Re: Day of Week shows up weird in report!

blewsas — Thu, 22 Aug 2019 22:09:17 GMT

I deleted the old data item "Offence Day of Week" and created a new one by right-clicking on the "Offence TMST" (datetime) data item and selecting "Duplicate Data Item". I renamed the new item to "Offence Day of Week" and applied the "Day, Date" format.

That gives me what I want - "Offence Days of Week" of "Sunday", "Monday", "Tuesday", etc. However, I have the same problem when I view the report - they change to "03Jan1960", "04Jan1960", "05Jan1960", etc.

Help! Very frustrating!