https://communities.sas.com/t5/SAS-Procedures/proc-sql-max-datetime/m-p/49523#M13454 Hello,<BR /> <BR /> when I want to use max() function over datetime column in proc sql mode, I get some integer result 1.6067E9<BR /> <BR /> Is it able to cast this number to datetime? Or how can i use max() function on datetime column?<BR /> <BR /> Thank you in advance Tue, 14 Dec 2010 11:20:48 GMT Julo 2010-12-14T11:20:48Z https://communities.sas.com/t5/SAS-Procedures/proc-sql-max-datetime/m-p/49523#M13454 Hello,<BR /> <BR /> when I want to use max() function over datetime column in proc sql mode, I get some integer result 1.6067E9<BR /> <BR /> Is it able to cast this number to datetime? Or how can i use max() function on datetime column?<BR /> <BR /> Thank you in advance Tue, 14 Dec 2010 11:20:48 GMT https://communities.sas.com/t5/SAS-Procedures/proc-sql-max-datetime/m-p/49523#M13454 Julo 2010-12-14T11:20:48Z https://communities.sas.com/t5/SAS-Procedures/proc-sql-max-datetime/m-p/49524#M13455 Variables containing date-, time- and datetime-values are always integers. They look like "dates" when a format is applied to them. So adding a format to the variable containing the maximum will solve the problem.<BR /> [pre]proc sql print;<BR /> select max(modate) format=datetime.<BR /> from sashelp.vtable;<BR /> quit;[/pre] Tue, 14 Dec 2010 11:27:57 GMT https://communities.sas.com/t5/SAS-Procedures/proc-sql-max-datetime/m-p/49524#M13455 andreas_lds 2010-12-14T11:27:57Z