topic Re: Need assistance modifying a date field in SAS Programming

Need assistance modifying a date field

LiamRowan — Wed, 21 Aug 2013 19:13:03 GMT

I have a date field that includes hours/minutes/seconds (e.g., '10SEP2012:0:0:0')dt). I need the data to include only day/month/year (e.g., '10SEP2012'd instead of '10SEP2012:0:0:0')dt. I created a new field based on the original date field using a computed column: put(datepart(t1.BirthDate), date9.). The data looks right, but now I cannot filter using the BETWEEN function because the dates are in a character format. There has got to be a better and different way to get rid of the hours/minutes/seconds and keep the date in a format that can be filtered as needed.

Thanks for ideas . . .

William

Re: Need assistance modifying a date field

ballardw — Wed, 21 Aug 2013 19:27:07 GMT

Just create the new variable as datepart(t1.birthdate) to get a SAS date variable and should work with between and date literals. The "put" is what made it a string result.

Re: Need assistance modifying a date field

LiamRowan — Wed, 21 Aug 2013 19:32:44 GMT

This appears to work perfectly. Thanks so much, really appreciated!