topic Re: How to change your DATETIME format in SAS VA? in SAS Visual Analytics

How to change your DATETIME format in SAS VA?

Andalusia — Thu, 26 Nov 2020 11:30:39 GMT

Hello,

In SAS EG I have DATETIME values like this with format DATETIME22.3:

25JUN2014:08:10:55.340

When I open the same data in VA I receive the data like this:

25JUN2014:08:10:55

Why is the last part ''.340'' gone? I also cant adjust the format because all I get is this:

A critical note: I use SAS VA 7.5

Re: How to change your DATETIME format in SAS VA?

PetriRoine — Thu, 26 Nov 2020 13:27:33 GMT

Hello @Andalusia

Many new date formats were introduced in VA8.3, including millisecond, week and quarter formats. My understanding is that VA7.5 doesn't support milliseconds. Sorry about that.

Best regards,

Petri

Re: How to change your DATETIME format in SAS VA?

Andalusia — Thu, 26 Nov 2020 13:36:11 GMT

It seems to me that a lot of people are struggling with this. Are their really no other ways to tacke this problem?

Re: How to change your DATETIME format in SAS VA?

FalkoSchulz — Fri, 27 Nov 2020 01:29:56 GMT

What about this as work-around. Keep a separate column carrying the value in milliseconds in your data for VA. Let's call this column 'milliseconds'.

In VA - create a new calculated field using formula (dtime being your datatime column)

Concatenate(Concatenate(Concatenate(Format('dtime'n[Raw],
'DTDATE7.'), ' '), Concatenate(Format(Hour('dtime'n), 'Z2.0'),
Concatenate(':', Format(Minute('dtime'n), 'Z2.0')))), Concatenate
(':', Format(( Second('dtime'n) + 'milliseconds'n ), 'COMMA6.3')))

..and use that as category role in standard line or other charts. Sorry for the rather long formula - but it's pretty much just taking apart the datetime information and concatenates the milliseconds into the given string so that information isn't lost when rendering. Only disadvantage is, that the given field is of character type but shouldn't matter too much for you rendering unless you plan some advanced time based calculations. You may also have to tweak above formula if you encounter any sorting issues given this is now sorted by the character value (e.g. by using YY/MM/DD numeric formatting instead)

Hope this helps. Falko