SAS - today() in a proc freq where clause

Question

I'm using SAS and trying to automatically pick up today's date and put it into the where clause for a proc freq.

it looks likes this:

proc freq data=data_name;
  tables date_col;
  where date_col > '30aug2017'd;
run;

Instead of 30aug2017 i want today() but i'm struggling to get this working, i 've tried:

data create_date;
current1 = today();
format current1 date9.;
run;

proc freq data=data_name;
  tables date_col;
  where date_col > current1;
run;

but the error i get is that variable is not on file

Any help appreciated,

cheers guys

Answer 1

You can use TODAY() directly in your WHERE statement.

 where date_col > today();