Deleting records based on a timestamp field with PROC SQL

[rmwachter]

I have a SAS datafile that contains a timestamp field (datetime20.)

I would like to delete a specific set of records that have no other commonality other than they were all loaded with the same timestamp.

Within PROC SQL, is it possible to perform a cast-type function or substring the data? The only part that I really need is the date portion.

Thanks!

[sbb]

A SAS DATE and DATETIME variable are not CHARACTER-type, they are numeric. You must use the DATEPART function and likely a SAS DATE literal value in your SQL SELECT statement.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search arguments, this topic / post:

proc sql datepart function site:sas.com

using date datetime values site:sas.com

using date literal values site:sas.com Message was edited by: sbb

[rmwachter]

Thanks for the help, Scott! I was not aware of the DATEPART function. It worked a treat.