topic Re: Deleting records based on a timestamp field with PROC SQL in SAS Programming

Deleting records based on a timestamp field with PROC SQL

rmwachter — Tue, 02 Nov 2010 14:54:15 GMT

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!

Re: Deleting records based on a timestamp field with PROC SQL

sbb — Tue, 02 Nov 2010 15:01:36 GMT

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

Re: Deleting records based on a timestamp field with PROC SQL

rmwachter — Tue, 02 Nov 2010 16:26:44 GMT

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