BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
twocanbazza
Quartz | Level 8

Hi All.

Fogive me if I have posted in the wrong community.

We have recently implemented the SAS APM (Audit Performance Monitoring) tools and have run the reports, we are specifically interested in the Report Usage Data. 

While analysing the data I noticed the Report usage hours looked wrong (most of the report usage out of business hours).  Looking into his it seems that the JAVADATE read from the SASWebReportStudio4.3_KeyActions.log is GMT, how can one change this to the local time zone (when logged not analysed), not happy just adding 13hrs as we have daylight savings etc.

Any help greatly welcomed.

Regards

Barry

1 ACCEPTED SOLUTION

Accepted Solutions
twocanbazza
Quartz | Level 8

Techsupports Answer

The SAS Web Report Studio key action log can't have the timezone information set in the javadate field. This value is in Coordinated Universal Time (UTC) the reason is that UTC is the primary time standard by which the world regulates clocks and time.

The data and time fields thats are listed in the log are adjusted to the system time, they represent the same value as the UTC javadate field just displayed in the local timezone of the server.

For example

<javaDate>1328238257418</javaDate> UTC time == <date>3/02/12</date><time>2:04 PM</time> Australian Eastern Time

View solution in original post

1 REPLY 1
twocanbazza
Quartz | Level 8

Techsupports Answer

The SAS Web Report Studio key action log can't have the timezone information set in the javadate field. This value is in Coordinated Universal Time (UTC) the reason is that UTC is the primary time standard by which the world regulates clocks and time.

The data and time fields thats are listed in the log are adjusted to the system time, they represent the same value as the UTC javadate field just displayed in the local timezone of the server.

For example

<javaDate>1328238257418</javaDate> UTC time == <date>3/02/12</date><time>2:04 PM</time> Australian Eastern Time

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1024 views
  • 0 likes
  • 1 in conversation