DATA Step, Macro, Functions and more

Need assistance modifying a date field

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Need assistance modifying a date field

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


Accepted Solutions
Solution
‎08-21-2013 03:27 PM
Super User
Posts: 10,466

Re: Need assistance modifying a date field

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.

View solution in original post


All Replies
Solution
‎08-21-2013 03:27 PM
Super User
Posts: 10,466

Re: Need assistance modifying a date field

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.

Occasional Contributor
Posts: 11

Re: Need assistance modifying a date field

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

Wm

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 157 views
  • 0 likes
  • 2 in conversation