SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 60191: When running in a non-English language, SAS® Enterprise Guide® might specify dates in the wrong format for a Between filter

DetailsHotfixAboutRate It

If you are using SAS Enterprise Guide in a non-English language, the generated code for a Between filter might use the wrong format for the start and end dates. The issue occurs in only the 32-bit version of SAS Enterprise Guide. Here is an example of 32-bit SAS Enterprise Guide running in Italian.

 

In the following display, the value 31/12/2015 is entered for Val. iniziale. However, this date is not specified correctly in the filter shown beneath the two fields.

 

 

 

This is how the generated PROC SQL appears.

PROC SQL;
   CREATE TABLE WORK.QUERY_FOR_DATA AS
   SELECT t1.DATA
      FROM WORK.DATA t1
      WHERE t1.DATA BETWEEN 31/12/2015 AND '1Jan2016'd;
QUIT;

 

As a workaround, you can use the 64-bit version of SAS Enterprise Guide, or you can enter dates using the English format. In the following example, the date 31Dec2015 is entered as 12/31/2015 instead of as 31/12/2015 and the code is correct.

 

 



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideMicrosoft Windows Server 2012 R2 Datacenter7.139.4 TS1M49.4 TS1M4
Microsoft Windows Server 2012 Datacenter7.139.4 TS1M49.4 TS1M4
Microsoft Windows Server 2008 for x647.139.4 TS1M49.4 TS1M4
Microsoft Windows Server 2008 R27.139.4 TS1M49.4 TS1M4
Microsoft Windows Server 20087.139.4 TS1M49.4 TS1M4
Microsoft Windows 8.1 Enterprise 32-bit7.139.4 TS1M49.4 TS1M4
Microsoft Windows 8 Pro x647.139.4 TS1M49.4 TS1M4
Microsoft Windows 8 Pro 32-bit7.139.4 TS1M49.4 TS1M4
Microsoft Windows 8 Enterprise x647.139.4 TS1M49.4 TS1M4
Microsoft Windows 8 Enterprise 32-bit7.139.4 TS1M49.4 TS1M4
Windows 7 Ultimate x647.139.4 TS1M49.4 TS1M4
Windows 7 Ultimate 32 bit7.139.4 TS1M49.4 TS1M4
Windows 7 Professional x647.139.4 TS1M49.4 TS1M4
Windows 7 Professional 32 bit7.139.4 TS1M49.4 TS1M4
Windows 7 Home Premium x647.139.4 TS1M49.4 TS1M4
Windows 7 Home Premium 32 bit7.139.4 TS1M49.4 TS1M4
Windows 7 Enterprise x647.139.4 TS1M49.4 TS1M4
Windows 7 Enterprise 32 bit7.139.4 TS1M49.4 TS1M4
Microsoft Windows Server 2012 Std7.139.4 TS1M49.4 TS1M4
Microsoft Windows Server 2012 R2 Std7.139.4 TS1M49.4 TS1M4
Microsoft Windows 107.139.4 TS1M49.4 TS1M4
Microsoft Windows 8.1 Pro x647.139.4 TS1M49.4 TS1M4
Microsoft Windows 8.1 Pro 32-bit7.139.4 TS1M49.4 TS1M4
Microsoft Windows 8.1 Enterprise x647.139.4 TS1M49.4 TS1M4
Microsoft® Windows® for x647.139.4 TS1M49.4 TS1M4
* 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.