05-21-2014 11:51 AM
I have dates like this in a big master dataset:
I wanted to pull all the dates from 2013april to 2014 march ...that is for one year
i do like below and i get 0 records pulled up!!!!!!
is there anything wrong i am doing???
%let bgndt = '01APR2013'D;
%let enddt = '31MAR2014'D;
where Date between &bgndt and &enddt;
05-21-2014 12:12 PM
So then its a number not a date so you SAS dates won't work with it.
Either convert to a date or change your boundaries to a number.
Because it is a number you can just use 20130401 and 20140331 as your boundaries.