I have below dataset. date
01jan17
01feb17
01jun17
30jun17
01apr17
01mar17
I created new macro to split the dataset based on dates. %macro date_loop(start,end);
%let start=%sysfunc(inputn(&start,anydtdte9.));
%let end=%sysfunc(inputn(&end,anydtdte9.));
%let dif=%sysfunc(intck(month,&start,&end));
%do i=0 %to &dif;
%let date=%sysfunc(putn(%sysfunc(intnx(month,&start,&i,b),yymmn6.));
proc sql;
create table new&date. as select 8 from new where date=&start.; quit;
%put &date &dif;
%end;
%mend;
%date_loop; The above code is working fine in SAS EG but its not working it it is accessing teradata dates. For example; dates for start is 2017-01-01 and end 2017-06-01. How to handle date function in above code it is teradata.
... View more