Hi Ellen- If the date variable is a SAS date one possibility is to change your where clause to reference the date in a date constant format. Something like:

where date le "13apr2001"d

The format of a date constant reference is "ddmmmyyyy"d, where dd is the day, mmm is the month abbreviation and yyyy (or yy) is the year. Make sure to enclose that part in quotes and follow with a 'd' (no quotes) to tell SAS that it's a date.

---------------------------------------------------------------------------- --- Pete Lund Northwest Crime and Social Research 313-D Fifth Ave SE Olympia, WA 98501 (360) 528-8970 - voice (360) 280-4892 - cell (360) 570-7533 - fax pete.lund@nwcsr.com www.nwcsr.com ---------------------------------------------------------------------------- ---

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of EMRAIN Sent: Thursday, May 24, 2001 7:17 AM To: SAS-L@LISTSERV.UGA.EDU Subject: subsetting by a date

Hi all,

I am looking for some help in subsetting a dataset based on a date. I need to keep all observations that are less than or equal to a certain date. I have tried; where date le 04/13/2001 and this doesnt work. Any thoughts?

Ellen