SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 70271: The TZONES2U function fails to give an accurate result for Mexico City

DetailsHotfixAboutRate It

The TZONES2U function converts a SAS datetime value to a UTC (Coordinated Universal Time) datetime value. In the example below, the time zone is set to America/Mexico City, and UTC is six hours ahead of Mexico City.

Mexico City ended the use of Daylight Savings Time in 2022, so the result below is incorrect by one hour. The Startdatetime1 variable is computed with the DHMS function. Then, the TZONES2U function adjusts the Startdatetime1 variable for Mexico City. Since SessionStartTime is set to 8:00, the newly computed Startdatetime1 value should be 14:00, which is six hours ahead. However, the computed Startdatetime1 value is 03JUL23:13:00:00.

Here is an example:

data _null_;
   CourseStartDate = '03JUL23'd;
   SessionStartTime = '08:00't;
   Timezone1 = 'America/Mexico_City';
   Startdatetime1 = tzones2u(dhms(CourseStartDate,0,0,SessionStartTime),timezone1);
   format CourseStartDate date9. SessionStartTime time. Startdatetime1 datetime.;
   put _all_;
run;

CourseStartDate=03JUL2023 SessionStartTime=8:00:00 timezone1=America/Mexico_City startdatetime1=03JUL23:13:00:00 ERROR=0 N=1

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASz/OS9.4_M7
z/OS 64-bit9.4_M7
Microsoft® Windows® for x649.4_M7
Microsoft Windows 8 Enterprise 32-bit9.4_M7
Microsoft Windows 8 Enterprise x649.4_M7
Microsoft Windows 8 Pro 32-bit9.4_M7
Microsoft Windows 8 Pro x649.4_M7
Microsoft Windows 8.1 Enterprise 32-bit9.4_M7
Microsoft Windows 8.1 Enterprise x649.4_M7
Microsoft Windows 8.1 Pro 32-bit9.4_M7
Microsoft Windows 8.1 Pro x649.4_M7
Microsoft Windows 109.4_M7
Microsoft Windows 119.4_M7
Microsoft Windows 95/989.4_M7
Microsoft Windows 2000 Advanced Server9.4_M7
Microsoft Windows 2000 Datacenter Server9.4_M7
Microsoft Windows 2000 Server9.4_M7
Microsoft Windows 2000 Professional9.4_M7
Microsoft Windows NT Workstation9.4_M7
Microsoft Windows Server 2003 Datacenter Edition9.4_M7
Microsoft Windows Server 2003 Enterprise Edition9.4_M7
Microsoft Windows Server 2003 Standard Edition9.4_M7
Microsoft Windows Server 2003 for x649.4_M7
Microsoft Windows Server 20089.4_M7
Microsoft Windows Server 2008 R29.4_M7
Microsoft Windows Server 2008 for x649.4_M7
Microsoft Windows Server 2012 Datacenter9.4_M7
Microsoft Windows Server 2012 R2 Datacenter9.4_M7
Microsoft Windows Server 2012 R2 Std9.4_M7
Microsoft Windows Server 2012 Std9.4_M7
Microsoft Windows Server 20169.4_M7
Microsoft Windows Server 20199.4_M7
Microsoft Windows Server 20229.4_M7
Microsoft Windows XP Professional9.4_M7
Windows 7 Enterprise 32 bit9.4_M7
Windows 7 Enterprise x649.4_M7
Windows 7 Home Premium 32 bit9.4_M7
Windows 7 Home Premium x649.4_M7
Windows 7 Professional 32 bit9.4_M7
Windows 7 Professional x649.4_M7
Windows 7 Ultimate 32 bit9.4_M7
Windows 7 Ultimate x649.4_M7
Windows Millennium Edition (Me)9.4_M7
Windows Vista9.4_M7
Windows Vista for x649.4_M7
64-bit Enabled AIX9.4_M7
64-bit Enabled Solaris9.4_M7
HP-UX IPF9.4_M7
Linux for x649.4_M7
Solaris for x649.4_M7
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.