DATA Step, Macro, Functions and more

A question about Date Format

Accepted Solution Solved
Reply
Contributor ZZB
Contributor
Posts: 34
Accepted Solution

A question about Date Format

I want to delete the data in 01/14/2005, format is MMDDYY10.

I use the following code 'if date=01/14/2005 then delete; run;', but it does not work. How to delete it? Is any special code to delete date data? I succeed in deleting data in other format.

Thanks


Accepted Solutions
Solution
‎10-19-2014 01:42 PM
Respected Advisor
Posts: 3,777

Re: A question about Date Format

You need to learn more about SAS dates.

You need a date literal. 'ddMMMyyyy'd. 

View solution in original post


All Replies
Solution
‎10-19-2014 01:42 PM
Respected Advisor
Posts: 3,777

Re: A question about Date Format

You need to learn more about SAS dates.

You need a date literal. 'ddMMMyyyy'd. 

☑ This topic is SOLVED.

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

Discussion stats
  • 1 reply
  • 141 views
  • 0 likes
  • 2 in conversation