🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-31-2017 03:24 PM
(1002 views)
I want to create a data step that keeps only dates greater or equal to Aug 15, 2016. A sample of the data is listed below.
data want;
set have;
if Incident_ts ge ??;
run;
INCIDENT_TS | Frequency | Percent | Cumulative Frequency |
Cumulative Percent |
---|---|---|---|---|
13FEB11:08:00:00 | 1 | 0.00 | 1 | 0.00 |
13APR11:08:00:00 | 1 | 0.00 | 2 | 0.01 |
informat INCIDENT_TS anydtdtm40. ;
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
if datepart(Incident_ts) ge '15AUG2016'd;
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
if datepart(Incident_ts) ge '15AUG2016'd;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
No problem. The key is to recognize that it is a datetime value, not a date, so you need to extract the date from it and then just use the literal in your expression.