How to see data loading time zone

[sarahzhou]

Hi, 

How do I see the data loading time zone of my data base from the server?

When I select data = datepart(date, &yesterday.), then the data loaded from 4am from yesterday was missing from the selection output, I suspect it's a time zone might be difference from my working station with my server.

How do I fix the time zone problem?

I am using sas 9.4

Thank you!

[LinusH]

To see/set the timezone for your SAS server, you can use the TIMEZONE options and the SYSTIMEZONE automatic macro variable respectively.

If you database resides in another timezone than your SAS server you need to come with some DB specific way doing this. If this is the case, what database it?