I don't see the error message. Just a note. ... View more

Try this:   /*Set your starting date ranges*/ %LET STARTDATE = 2012-07-26; %LET ENDDATE = 2012-07-30; %LET NUMBER_OF_QUERIES=3; %MACRO PullData; %DO I=0 %TO &NUMBER_OF_QUERIES. ; DATA _NULL_; /*Determinig the difference between the initial date ranges so subsequent date ranges will do the same*/ DIFFERENCE = (INPUT("&ENDDATE",YYMMDD10.) - INPUT("&STARTDATE",YYMMDD10.))+1; /*Calculate the date values and create macro variables for the date ranges.*/ CALL SYMPUTX("STARDATE1",PUT(INPUT("&STARTDATE",YYMMDD10.)+SUM(&I.*DIFFERENCE),YYMMDD10.)); CALL SYMPUTX("ENDDATE1",PUT(INPUT("&ENDDATE",YYMMDD10.)+SUM(&I.*DIFFERENCE),YYMMDD10.)); RUN; Proc SQL; connect to teradata (database=); create table here.new&I. as select * from connection to teradata ( SELECT d.Nbr, d.Sequence, a.Nb, '-' as Duration, (Case When a.Dir = b.Dir Then 'S' Else 'M' END) as Type, AL.Gphc_Adrress, AL4.Gphc_Adr2, FROM OP.Base a LEFT OUTER JOIN MV.STN b ON (a.Cd=b.Cd AND a.Cd=b.Cd) FROM OP.D5a, MV.D5b WHERE (Doc=Doc AND D5.Ldt=LDt AND D5.Sq=Sq) AND ((D5a.Inav='N' AND D5a.Ind='N' AND (D5b.Cd='D' OR D5b.Op='D') LEFT OUTER JOIN ( SELECT DISTINCT D.kt, D.LDt, D.Sq, SUM ( D6.Dc ) FROM OPMV.CHRG WHERE (D6.LDt BETWEEN DATE %BQUOTE(')&STARTDATE1%BQUOTE(') AND DATE %BQUOTE(')&ENDDATE1%BQUOTE(')) GROUP BY D6.Doc_Nb, D6.Doc_LDt, D6.Sq) AL(nbr, dt, sq, amt) ON (AL.nbr=AL.nbr LEFT OUTER JOIN ( SELECT D7.Doc_Nb, SUM ( D7b.Dc ) FROM OPMV.TK LEFT OUTER JOIN OPMV.MISC ON (D7a.Cur_RM=D7b.Rm_Nb WHERE ((D7a.LDt BETWEEN DATE %BQUOTE(')&STARTDATE1%BQUOTE(') AND DATE %BQUOTE(')&ENDDATE1%BQUOTE(') GROUP BY D7a.Doc_Nb, D7a.Iss_LDt, ORDER BY 4,1,3 ); quit; %END; %MEND; %PullData; ... View more

I think I see what you're trying to do, but I'm a little confused by the fact that your first date range is 6 days and your second date range is 5 days.  Is that intentional? If so, then why?   So, assuming that your date ranges are meant to be 6 days, it looks to me like you want to be able to 1) set your starting date range and then 2) automatically generate any number of additional date ranges baed on the first one. Is this correct? If so, can you confirm that this code generates correct date ranges?   /*Set your starting date ranges*/ %LET STARTDATE = 2012-07-26; %LET ENDDATE = 2012-07-31; %LET NUMBER_OF_QUERIES=3; /*Creating a dataset of date ranges for review. We will change this later to just create macro variables*/ DATA DATE_RANGES; FORMAT DATE1 DATE2 YYMMDD10.; /*Determinig the difference between the initial date ranges so subsequent date ranges will do the same*/ DIFFERENCE = (INPUT("&ENDDATE",YYMMDD10.) - INPUT("&STARTDATE",YYMMDD10.))+1; /*This will eventually be macro code instead, but using a data step DO loop output user-defined number of date ranges*/ /*Just change value for NUMBER_OF_QUERIES above*/ DO I = 0 TO &NUMBER_OF_QUERIES.-1; DATE1 = INPUT("&STARTDATE",YYMMDD10.)+SUM(I*DIFFERENCE); DATE2 = INPUT("&ENDDATE",YYMMDD10.)+SUM(I*DIFFERENCE); OUTPUT; END; RUN; All you have to do is define the starting date ranges and then the number of queries you want to run (at the top) and then the second step will generate the date ranges for the queries.  If this is doing want you want then we can further modify the code and incorporate your query.   ... View more