DATA Step, Macro, Functions and more

Deleting records based on a timestamp field with PROC SQL

Reply
Occasional Contributor
Posts: 9

Deleting records based on a timestamp field with PROC SQL

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!
Super Contributor
Super Contributor
Posts: 3,174

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

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
Occasional Contributor
Posts: 9

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

Thanks for the help, Scott! I was not aware of the DATEPART function. It worked a treat.
Ask a Question
Discussion stats
  • 2 replies
  • 138 views
  • 0 likes
  • 2 in conversation