Hi Reeza, yes I have a working code, its quite large and I dont want to go through it each time to change the dates, thats why I want to built a macro which I can easily update without going through all my codes.
... View more
Hi, I'm trying to build a macro that would automate a date range of data for my query. This macro would generate data for an entire week. I've tried the following but nothing works when I invoke my variable name in my query Proc SQL; %let DATASET_DATE BETWEEN '18aug2017'd AND '20aug2017'd; quit; any help would be great!!!
... View more
Hi, I'm trying to build a macro that would automate a date range of data for my query. This macro would generate data for an entire week. I've tried the following but nothing works when I invoke my variable name in my query Proc SQL; %let DATASET_DATE BETWEEN '18aug2017'd AND '20aug2017'd; quit; any help would be great!!!
... View more