In SAS EG I have DATETIME values like this with format DATETIME22.3:
When I open the same data in VA I receive the data like this:
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
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)
'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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.