With SAS^® Scalable Data Server^®, incorrect textualization of SQL implicit pass-through queries occurs when you use the CALCULATED keyword in a GROUP BY statement.

The code in the Full Code tab of this Problem Note demonstrates the incorrect results and produces the following message in the SAS log file:

   NOTE: Implicit SQL:  select distinct t1.col2, DATEPART(t1.col1) as col1, t1.col3, COUNT(*)
         as num from TBL t1 group by t1.col2, col1, t1.col3
   NOTE: Table WORK.SASDATA created, with 66085 rows and 4 columns.

The CALCULATED keyword is missing in the Implicit SQL note above.

Select the Hot Fix tab in this Note to access the hot fix for this issue.

Operating System and Release Information

libname spdslib sasspds 'tmp' server=localhost.5400 user='anonymous' IP=YES;


data SPDSLIB.tbl;
	format col1 datetime16.;
 do i=1 to 1000000;
	col2= round(1000*ranuni(1));
	col1=1447213759 + round(500000*ranuni(2));
	col3=round(10*ranuni(1));
	output;
 end;

drop i;
run;

PROC SQL; 
	CREATE TABLE WORK.sasdata AS 
		SELECT DISTINCT t1.col2, (datepart(t1.col1)) FORMAT=ddmmyy10. LABEL="col1" AS col1, 
			t1.col3, (count(*)) AS num
	FROM SPDSLIB.tbl t1 
GROUP BY t1.col2, (CALCULATED col1), t1.col3;
QUIT;

A fix for this issue for Base SAS 9.21_M3 is available at:

A fix for this issue for Base SAS 9.3_M1 is available at: