🔒 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 08-22-2018 11:03 PM
(1081 views)
log_date | cst_id |
09Dec2016 | 101 |
20Jan2016 | 102 |
16Jul2015 | 103 |
The format of column "log_date" is DATE9.
proc sql;
select * from tableA
where intck('dtday',log_date,'01apr2018'd) >=30;
run;
the code return no rows,why and how to fix?
thanks!
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You are using DTDAY which is a datetime interval not a DATE one. Use DAY instead.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is your log_date var character by any chance formatted with date9.?
And can you post your log message plz?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You are using DTDAY which is a datetime interval not a DATE one. Use DAY instead.