I have a SAS query fiile with about 50 sequential queries. Some of them use a datetime variable.
When I need to increment that variable, I have to do a find and replace within SAS in order to change it.
I looked at Macro Variables and I feel like i almost have a solution, but I'm missing something.
The code (attached) doesn't work because &datetimestamp contains 01MAY2009:00:00:00dt and not '01MAY2009:00:00:00'dt.
The error is
NOTE: Line generated by the macro variable "DATETIMESTAMP".
Thanks in advance..
%syslput datetimestamp = sysfunc(datepart('01MAY2009:00:00:00'dt),date9.):00:00:00dt;
create table work.dummyData as
select ticket_number from tickets_DB
where RESOLVE_TIME_ET >= &datetimestamp;