Help using Base SAS procedures

Proc Export Dates Before/After Date

Reply
Occasional Contributor
Posts: 14

Proc Export Dates Before/After Date

I want to export observations which occurred after x date, how can I modify this query to do so?  I've tried AFTER, IS AFTER, and >.


Proc export data=MAUDE.Total1999thru2013 (where=(DATE_RECEIVED='10MAR1992'D))

dbms=excel file="...\Output\test9.xls";

run;

Super User
Posts: 19,815

Re: Proc Export Dates Before/After Date

>

Respected Advisor
Posts: 4,925

Re: Proc Export Dates Before/After Date

Or, if DATE_RECEIVED is a SAS datetime and not a date:

where=(DATE_RECEIVED>'10MAR1992:00:00:00'DT)

PG
Ask a Question
Discussion stats
  • 2 replies
  • 161 views
  • 0 likes
  • 3 in conversation