Hi all, would like to ask how to set a date for me to use it in my do loop later? if I'm using the code below (bold part) , SAS will automatically add the variable as new column in my table (I don't want this) and don't want to use drop.   From the code below, you can see that I want to set a beg_date (beginning date) and end_date(end date). Purpose of this is to use it in my do loop later. For Ex:   %Do i=beg_yyyy_fy %to end_yyyy_fy; %Do j=%sysfunc(ifn(&i=beg_yyyy_fy,beg_mm_fy,1)) %to %sysfunc(ifn(&i=end_yyyy_fy,end_mm_fy,12)); 　 　 　     MY FULL CODE:   libname py201906 "\\kaiwksgh415thw5\Data\BNM_Data_Request\BNM_Qtrly_Policy_Claim_Stats\Fire\2019\201906\policy\DBF"; Data py201906.FirePolicy201906; infile "\\kaiwksgh415thw5\Data\BNM_Data_Request\BNM_Qtrly_Policy_Claim_Stats\Fire\2019\201906\policy\Monitoring Data\Fire Policy 201906.csv" dlm=',' MISSOVER DSD lrecl=32767 firstobs=2; informat CHDRNUM $8.; informat CNTTYPE $3.; informat LONGDESC $32.; informat TRANNO 4.; informat CURRFROM yymmdd10.; informat ZRENNO 3.; informat ZENDNO 3.; informat TRD_DATE yymmdd10.; informat TRANDATE yymmdd10.; informat STATCODE $3.; informat STATREASN $3.; informat BATCTRCDE $4.; informat BATCACTYR 4.; informat BATCACTMN 2.; informat COWNNUM 8.; informat LSURNAME $60.; informat CCDATE yymmdd10.; informat CRDATE yymmdd10.; informat OCCDATE yymmdd10.; informat DTECAN yymmdd10.; informat AGNTNUM $8.; informat AGTYPE 3.; informat LSURNAME01 $60.; informat ZLIFAGNT $8.; informat CHDRSTCDE 3.; informat MPLNUM 8.; informat REPNUM 8.; informat ZREPOLNO $16.; informat CAMPAIGN $16.; informat RNLDURN 3.; informat CNTBRANCH $3.; informat CHDRSTCDB $3.; informat CHDRSTCDC $3.; informat CLTSEX $3.; informat MARRYD $3.; informat SECUITYNO $25.; informat CLTDOB yymmdd10.; informat DTEATT yymmdd10.; informat RSKNO 3.; informat RSKTYP $3.; informat RATFLG $3.; informat STATECDE $3.; informat LOCREG $10.; informat PCODE $10.; informat ZOCUPY 3.; informat ZOCUPD $60.; informat RATECDE $6.; informat ZRATEDES $50.; informat RATEBAS01 $1.; informat RATEBAS02 $1.; informat SCONST $3.; informat ZCNSTDES $8.; informat CONSYEAR 4.; informat ZFIRPCDE $3.; informat BASRATE01 6.; informat SNO 3.; informat INTCDE 3.; informat COVER_DESC $30.; informat ZITEMSI 10.; informat ZPRFLG $2.; informat PREMRATE 10.; informat GPMPLIER 6.; informat LOAD 6.; informat PPREM 6.; informat PRC $3.; informat PREMCL $3.; informat ZADSI01 2.; informat ZADRTE01 2.; informat ZADPRE01 2.; informat ZLTAPER01 2.; informat ZLTAAMT01 2.; informat TOTFSI 10.; informat FTOTPRE 10.; informat DTETER yymmdd10.; informat EXTR01 10.; informat EXTR03 8.; informat EXTR02 3.; informat APREMDUE 10.; informat INDISC 4.; informat GTGRNR $3.; informat ZCMPC 4.; informat ZCMEXTR 8.; informat EXTR06 8.; informat G_PREM01 6.; informat G_COMM01 8.; informat Q_PREM01 3.; informat Q_COMM01 3.; informat S_PREM01 3.; informat S_COMM01 3.; informat F_PREM01 8.; informat F_COMM01 8.; informat X_PREM01 3.; informat X_COMM01 3.;   　 　 format CHDRNUM $8.; format CNTTYPE $3.; format LONGDESC $32.; format TRANNO 4.; format CURRFROM yymmdd10.; format ZRENNO 3.; format ZENDNO 3.; format TRD_DATE yymmdd10.; format TRANDATE yymmdd10.; format STATCODE $3.; format STATREASN $3.; format BATCTRCDE $4.; format BATCACTYR 4.; format BATCACTMN 2.; format COWNNUM 8.; format LSURNAME $60.; format CCDATE yymmdd10.; format CRDATE yymmdd10.; format OCCDATE yymmdd10.; format DTECAN yymmdd10.; format AGNTNUM $8.; format AGTYPE 3.; format LSURNAME01 $60.; format ZLIFAGNT $8.; format CHDRSTCDE 3.; format MPLNUM 8.; format REPNUM 8.; format ZREPOLNO $16.; format CAMPAIGN $16.; format RNLDURN 3.; format CNTBRANCH $3.; format CHDRSTCDB $3.; format CHDRSTCDC $3.; format CLTSEX $3.; format MARRYD $3.; format SECUITYNO $25.; format CLTDOB yymmdd10.; format DTEATT yymmdd10.; format RSKNO 3.; format RSKTYP $3.; format RATFLG $3.; format STATECDE $3.; format LOCREG $10.; format PCODE $10.; format ZOCUPY 3.; format ZOCUPD $60.; format RATECDE $6.; format ZRATEDES $50.; format RATEBAS01 $1.; format RATEBAS02 $1.; format SCONST $3.; format ZCNSTDES $8.; format CONSYEAR 4.; format ZFIRPCDE $3.; format BASRATE01 6.; format SNO 3.; format INTCDE 3.; format COVER_DESC $30.; format ZITEMSI 10.; format ZPRFLG $2.; format PREMRATE 10.; format GPMPLIER 6.; format LOAD 6.; format PPREM 6.; format PRC $3.; format PREMCL $3.; format ZADSI01 2.; format ZADRTE01 2.; format ZADPRE01 2.; format ZLTAPER01 2.; format ZLTAAMT01 2.; format TOTFSI 10.; format FTOTPRE 10.; format DTETER yymmdd10.; format EXTR01 10.; format EXTR03 8.; format EXTR02 3.; format APREMDUE 10.; format INDISC 4.; format GTGRNR $3.; format ZCMPC 4.; format ZCMEXTR 8.; format EXTR06 8.; format G_PREM01 6.; format G_COMM01 8.; format Q_PREM01 3.; format Q_COMM01 3.; format S_PREM01 3.; format S_COMM01 3.; format F_PREM01 8.; format F_COMM01 8.; format X_PREM01 3.; format X_COMM01 3.;   　 input   CHDRNUM $ CNTTYPE $ LONGDESC $ TRANNO CURRFROM ZRENNO ZENDNO TRD_DATE TRANDATE STATCODE $ STATREASN $ BATCTRCDE $ BATCACTYR BATCACTMN COWNNUM LSURNAME $ CCDATE CRDATE OCCDATE DTECAN AGNTNUM $ AGTYPE LSURNAME01 $ ZLIFAGNT $ CHDRSTCDE MPLNUM REPNUM ZREPOLNO $ CAMPAIGN $ RNLDURN CNTBRANCH $ CHDRSTCDB $ CHDRSTCDC $ CLTSEX $ MARRYD $ SECUITYNO $ CLTDOB DTEATT RSKNO RSKTYP $ RATFLG $ STATECDE $ LOCREG $ PCODE $ ZOCUPY ZOCUPD $ RATECDE $ ZRATEDES $ RATEBAS01 $ RATEBAS02 $ SCONST $ ZCNSTDES $ CONSYEAR ZFIRPCDE $ BASRATE01 SNO INTCDE COVER_DESC $ ZITEMSI ZPRFLG $ PREMRATE GPMPLIER LOAD PPREM PRC $ PREMCL $ ZADSI01 ZADRTE01 ZADPRE01 ZLTAPER01 ZLTAAMT01 TOTFSI FTOTPRE DTETER EXTR01 EXTR03 EXTR02 APREMDUE INDISC GTGRNR $ ZCMPC ZCMEXTR EXTR06 G_PREM01 G_COMM01 Q_PREM01 Q_COMM01 S_PREM01 S_COMM01 F_PREM01 F_COMM01 X_PREM01 X_COMM01; 　 　 if _ERROR_ then call symputx('_EFIERR_',1); run; libname py201904 "\\kaiwksgh415thw5\Data\BNM_Data_Request\BNM_Qtrly_Policy_Claim_Stats\Fire\2019\201904\policy\DBF"; Data py201904.FirePolicy201904; Set py201904.FirePolicy201904; libname py201905 "\\kaiwksgh415thw5\Data\BNM_Data_Request\BNM_Qtrly_Policy_Claim_Stats\Fire\2019\201905\policy\DBF"; Data py201905.FirePolicy201905; Set py201905.FirePolicy201905; Data py201906.RiskProfile_Fire_201904_201906; Set   py201904.FirePolicy201904 py201905.FirePolicy201905 py201906.FirePolicy201906; run; proc sql; create table query as select distinct chdrnum,trandate,batctrcde,batcactyr,batcactmn,tranno,rskno,totfsi,ratecde,cnttype,rsktyp,premcl,currfrom,EXTR01,EXTR03,EXTR02,ZCMEXTR,EXTR06,G_PREM01,Q_PREM01,S_PREM01,F_PREM01,X_PREM01,G_COMM01,Q_COMM01,S_COMM01,F_COMM01,X_COMM01 from py201906.RiskProfile_Fire_201904_201906 where statcode="IF" or statcode="CA"; quit; proc sql; create table py201906.RiskProfFire_201904_201906_group as select * from query where premcl^=""; run; Data py201906.RiskProfFire_201904_201906_group; Set py201906.RiskProfFire_201904_201906_group; if month(currfrom)=12 then effyyyy_fy=year(currfrom)+1; else   effyyyy_fy=year(currfrom); 　 if month(currfrom)=12 then effmth_fy=1; else effmth_fy=month(currfrom)+1;   　 /*********************/ if batcactmn=12 then batyr=batcactyr+1; else   batyr=batcactyr; /*********************/ 　 　 if batcactyr<=2014 then   acyear=batyr; else acyear=batcactyr; 　 /*********************/ if batcactmn=12 then batmth=1;   else batmth=batcactmn+1;   /*********************/ if batcactyr<=2014 then   acmonth=batmth; else acmonth=batcactmn; 　 drop batyr; drop batmth; if (effyyyy_fy*100+effmth_fy)<(acyear*100+acmonth) then   post_yy_fy=acyear; else   post_yy_fy=effyyyy_fy; 　 if (effyyyy_fy*100+effmth_fy)<(acyear*100+acmonth) then   post_mm_fy=acmonth; else   post_mm_fy=effmth_fy; 　 /*****************************************************************************/ length test1 $4;   test1=left(ratecde); length test2 $2;   test2=left(ratecde); drop test1; drop test2;   　 　 　 　 if totfsi<=10000000 then si_band='SI1'; else if totfsi>=10000001 and totfsi<=50000000 then si_band='SI2'; else if totfsi>=50000001 and totfsi<=300000000 then si_band='SI3'; else if totfsi>=300000001 then si_band='SI4';   　 　 /************************************************************************************/ if ratecde^="1000" and ratecde^="COIN" and ratecde^="" then do;   　 　 if rsktyp in ('FCL','FCZ','FLP') then cov_type='Conloss'; else if rsktyp in ('FAZ','FDA','FIA') then cov_type='IAR'; else if test1 in ('4006','4008') then cov_type='HH'; else if test1 in ('4001','4005') then cov_type='HO';   　 　 else if test2=10 then cov_type='MD1'; else if test2=11 then cov_type='MD2'; else if test2=12 then cov_type='MD3'; else if test2=14 then cov_type='MD4'; else if test2=29 then cov_type='MD5';   else cov_type='MD6'; end;   　 　 /**************************************************/ 　 　 if ratecde="1000" or ratecde="COIN" or ratecde="" then do;   　 　 if rsktyp in ('FHO','FHW','FHZ') then cov_type='HH'; else if rsktyp in ('FHH','FHI','FHY') then cov_type='HO'; else if rsktyp in ('FCL','FCZ','FLP') then cov_type='Conloss'; else if rsktyp in ('FAZ','FDA','FIA') then cov_type='IAR'; else if rsktyp in ('FDP','FFD','FFZ','FHX','FMD','FMP') then cov_type='MD1'; end; run; libname py201903 "\\kaiwksgh415thw5\Data\BNM_Data_Request\BNM_Qtrly_Policy_Claim_Stats\Fire\2019\201903\policy\DBF"; Data py201903.riskproffire_201501_201903_group; Set py201903.riskproffire_201501_201903_group;   　 proc sql noprint; create table query2 as select * from py201903.RiskProfFire_201501_201903_group where post_yy_fy*100+post_mm_fy>=201707 and post_yy_fy*100+post_mm_fy<=201907; proc sql noprint; create table query3 as select * from py201906.RiskProfFire_201904_201906_group where post_yy_fy*100+post_mm_fy>=201707 and post_yy_fy*100+post_mm_fy<=201907; proc sql; create table py201903.RskProFir_201706_201906_post_EP as select * from query2 union all select * from query3; run; Data py201903.RskProFir_201706_201906_post_EP; Set py201903.RskProFir_201706_201906_post_EP;   　 beg_date = INPUT(PUT(20181201,8.),YYMMDD10.); FORMAT beg_date YYMMDD10.; end_date = INPUT(PUT(20190630,8.),YYMMDD10.); FORMAT end_date YYMMDD10.;   　 　 if month(beg_date)=12 then beg_yyyy_fy=year(beg_date)+1;   else beg_yyyy_fy=year(beg_date); if month(beg_date)=12 then beg_mm_fy=1;   else beg_mm_fy=month(beg_date)+1; if month(end_date)=12 then end_yyyy_fy=year(end_date)+1;   else end_yyyy_fy=year(end_date); 　 if month(end_date)=12 then end_mm_fy=1;   else end_mm_fy=month(end_date)+1;   　 run;   　   ... View more

Hi all, I'm currently convert the code in visualfoxpro to sas.   Is there any difference between isblank and isnull function in vfox? if I write the code in sas like this below, is this correct?     VFOX CODE use "D:\Fire\claim\Fire_clm_201903_addratecde.dbf" scan for (not inli(allt(ratecde),"1000","COIN") and not isbl(ratecde) and not isnull(ratecde)) Do case case inli(rsktyp,"FCL","FCZ","FLP") repl cov_type with "Conloss" case inli(rsktyp,"FAZ","FDA","FIA") repl cov_type with "IAR" case inli(left(allt(ratecde),4),"4006","4008") repl cov_type with "HH" case inli(left(allt(ratecde),4),"4001","4005") repl cov_type with "HO" otherwise DO casecase inli(left(allt(ratecde),2),"10") repl cov_type with "MD1" case inli(left(allt(ratecde),2),"11") repl cov_type with "MD2" case inli(left(allt(ratecde),2),"12") repl cov_type with "MD3" case inli(left(allt(ratecde),2),"14") repl cov_type with "MD4" case inli(left(allt(ratecde),2),"29") repl cov_type with "MD5" otherwise repl cov_type with "MD6" endcase endcase endscan         MY Code in sas   if ratecde^='1000' and ratecde^='coin' and ratecde^='' then do;   if rsktyp in ('FCL','FCZ','FLP') then cov_type='Conloss'; else if rsktyp in ('FAZ','FDA','FIA') then cov_type='IAR'; else if test1 in ('4006','4008') then cov_type='HH'; else if test1 in ('4001','4005') then cov_type='HO';   　 　 else if test2=10 then cov_type='MD1'; else if test2=11 then cov_type='MD2'; else if test2=12 then cov_type='MD3'; else if test2=14 then cov_type='MD4'; else if test2=29 then cov_type='MD5';   else cov_type='MD6'; end;   ... View more

Hi all, facing problem regarding the left join.   I want the ratecde column from pl201903.Fire_clm_cov_201903 added into the table pl201903.Fire_clm_201903. When the new column is added, both claim datas from two table sources must be the same.   and also the zsumsi data from pl201903.Fire_clm_201903 must be the same as the totsi from the second one pl201903.Fire_clm_cov_201903.    Here's my code below, However, this does not work. I don't know where is it wrong. It will automatically help me add on some rows which is repeat from the existing rows from original file.       proc sql noprint; create table pl201903.query as select a.*,b.ratecde as ratecde_1 from pl201903.Fire_clm_201903 a left join pl201903.Fire_clm_cov_201903 b on a.claim=b.claim and a.zsumsi=b.totsi; run; ... View more

Hi all, facing some problems regarding to have a do loop to loop between date (only the month and year). Plus can I extract the year and month while looping them?   I have startyear, startmonth, endyear and endmonth for user to set according to their need. For example I set the startyear and month is 2015 and 6, while the end is 2019 and 2. Can I loop   6/2015, 7/2015 , 8/2015 ,...................., 1/2019, 2/2019 like this?   The do loop I want to apply is only for the OS which is on the last part in bold. while the accyrfy and accmthfy in orange text is based on the year and the month  in the loop.   my code is below:   %let startyr=2015; %let startmth=6; %let endyr=2019; %let endmth=2;   %let yymm=%eval(&endyr*100+&endmth); %macro date(startyr, startmth,endyr,endmth);     libname pl&yymm. "\\kaiwksgh415thw5\Data\POLA\Claim\&endyr\&yymm\DBF"; Data pl&yymm..POLA_clm_agg_&yymm.; set pl&yymm..POLA_clm_agg_&yymm.;   run; PROC FORMAT; value $ class 'VEH'='1' 'FIR'='2' 'GMS'='3' 'BON'='3' 'HUL'='3' 'PAC'='4' 'TEL'='5' 'WWC'='5' 'LIA'='6' 'CGO'='7' 'ENG'='8'   ; RUN; %if &startmth=12 %then %do; %let accyr_fy1=%eval(&startyr+1); %let accmth_fy1=1; %end; %else %do; %let accyr_fy1=&startyr; %let accmth_fy1=%eval(&startmth+1); %end; %if &endmth=12 %then %do; %let accyr_fy2=%eval(&endyr+1); %let accmth_fy2=1; %end; %else %do; %let accyr_fy2=&endyr; %let accmth_fy2=%eval(&endmth+1); %end; %let accyrmth_fy1=%eval(&accyr_fy1*100+&accmth_fy1); %let accyrmth_fy2=%eval(&accyr_fy2*100+&accmth_fy2);   　 　 /*****************************OS*****************************/ PROC SQL; create table SMCD_OS_&yymm. AS SELECT put(zmajrsk,$class.) as class, min(&accyrfy.-lossyr_fy,11) as dev11yr,accyr_fy,accmth_fy,sum(zclmos) AS zclmos FROM pl&yymm..POLA_clm_agg_&yymm. where (accyr_fy*100+accmth_fy)<=(&accyrfy.*100+&ACCMTHFY.) GROUP BY class,2,3,4 order by accyr_fy,accmth_fy; quit; ods html file="\\kaiwksgh415thw5\Data\POLA\Claim\&endyr\&yymm\result\SMCD_mth_OS_FY_10DY_&yymm..html"   style=normal; proc print; run; 　 　 %mend date;   %date(&startyr, &startmth,&endyr,&endmth); run;     ... View more

Hi all, is there a way to combine the proc sql table I created in my do loop?   Here's my code below for my do loop to produce 3 proc sql tables (which is 201705,201704,201703).   The codes below will produce 3 ods html. Instead of producing 3 ods html, after combining all the three proc sql table, I want to export them in ods html together so there will only be 1 ods html.           %macro date(YYYY=2017,MM=05,Y=2017,M=05);     (some coding....)     %macro financial (MONTH); %do i=&acmthfy1. %to &MONTH; %if &i.=1 %THEN %DO; %let fileyear=%eval(&YYYY-1); %let filemth=12; %end; %else %if &i.=2 %THEN %DO; %let fileyear=&YYYY; %let filemth=01; %end; %else %if &i.=11 %then %do; %let fileyear=&YYYY; %let filemth=10; %end; %else %if &i.=12 %then %do; %let fileyear=&YYYY; %let filemth=11; %end; %else %do; %let fileyear=&YYYY; %let filemth=0%eval(&i.-1); %end;   　 /*****************************PD*****************************/ PROC SQL; create table SMCD_PD_&fileyear&filemth. AS SELECT put(zmajrsk,$class.) as class, dev11yr_fy,sum(zclmpd) AS zclmpd FROM pl&Y&M..POLA_clm_3months_&Y&M. WHERE ACCYR_FY=&Y. & accmth_fy=&i. GROUP BY class,2;   run; ods html file="\\kaiwksgh415thw5\Data\POLA\Claim\&fileyear\&fileyear&filemth\result\SMCD_mth_PD_FY_10DY_&fileyear&filemth..html"   style=normal; proc print; run; %end; %mend financial; %financial(&acmthfy2.);   　 %mend date; %date(YYYY=2017,MM=05,Y=2017,M=05); run; ... View more

Hi, I need to group the 4 columns but it keep showing the grouping that I don't want.   I expect my result will be like this below   class                tema002                accyr_fy             accmth_fy           zclmpd 1                          0                            2018                    12                       2600 1                          1                            2018                    12                   81945.95     1                          2                            2018                    12                        300 2                          0                            2018                    12                       5515 2                          1                            2018                    12                        88451 2                          2                             2018                    12                         7463 ..... 8                          1                             2018                     12                       7455 8                          2                             2018                     12                         8451 1                          0                            2019                      1                           544 1                          1                            2019                      1                       8465    1                          2                            2019                      1                        2310 2                          0                            2019                      1                       48410 2                          1                            2019                      1                        98651 2                          2                             2019                    1                         1253 ..... 8                          1                             2019                    1                         942 8                          2                             2019                     1                       47121     However, if I type my code like this,   PROC SQL; create table SMCD_PD_&yymm. AS SELECT put(zmajrsk,$class.) as class, min(accyr_fy-lossyr_fy,11),accyr_fy,accmth_fy,sum(zclmpd) AS zclmpd FROM pl&yymm..POLA_clm_agg_&yymm. WHERE (accyr_fy*100+accmth_fy)<=201901 & (accyr_fy*100+accmth_fy)>=201812 GROUP BY class,2,3,4; run;   ods html file="\\kaiwksgh415thw5\Data\POLA\Claim\&endyr\&yymm\result\SMCD_mth_PD_FY_10DY_&yymm..html" style=normal; proc print;     The result is something like this,   class                tema002                accyr_fy             accmth_fy           zclmpd 1                          0                            2018                   12                       2600 1                          0                            2019                    1                          544 1                          1                            2018                    12                   81945.95  1                          1                            2019                      1                       8465 1                          2                            2018                    12                        300 1                          2                            2019                      1                        2310   2                          0                            2018                    12                       5515 2                          0                            2019                      1                       48410 2                          1                            2018                    12                        88451 2                          1                            2019                      1                        98651 2                          2                             2018                    12                         7463 2                          2                             2019                    1                         1253 ..... ..... 8                          1                             2018                     12                       7455 8                          1                             2019                    1                         942 8                          2                             2018                     12                       8451 8                          2                             2019                     1                       47121     I have no idea how to group it into the way I want, I tried and error many times but still don't get it. ... View more

  Hi all, I am facing a problem of my if statement is not work in the Do loop. This cause my ods html does not work and I cant print out my result. Did I type anything wrong?    The log summary does not have any error. But just the result does not printed out.           %macro date(YYYY=2019,MM=02,Y=2019,M=02);%global YR accyrfy MTH accmthfy acmthfy1 acmthfy2 fileyear accyrfy1 filemth;   　 libname pl&Y&M. "\\kaiwksgh415thw5\Data\POLA\Claim\&Y\&Y&M\DBF"; Data pl&Y&M..POLA_clm_3months_&Y&M.; set pl&Y&M..POLA_clm_agg_&Y&M.;     .........................................(BODY)       %macro financial (MONTH); %do i=&acmthfy1. %to &MONTH; %if &i.=1 %THEN %DO; %let filemth=12; %end;   %else %if &i.=12 %then %do; %let filemth=11; %end;   %else %if &i.=11 %then %do; %let filemth=10; %end;   %else %do; %let filemth=0%eval(&i.-1); %end;   　 /*****************************PD*****************************/ PROC SQL; create table SMCD_PD_&fileyear&filemth. AS SELECT put(zmajrsk,$class.) as class, dev11yr_fy,sum(zclmpd) AS zclmpd FROM pl&Y&M..POLA_clm_3months_&Y&M. WHERE ACCYR_FY=&accyrfy1. & accmth_fy=&i. GROUP BY class,2;   run; ods html file="\\kaiwksgh415thw5\Data\POLA\Claim\&fileyear\&fileyear&filemth\result\SMCD_mth_PD_FY_10DY_&fileyear&filemth..html"   style=normal; proc print; run;   %end; %mend financial; %financial(&acmthfy2.);   　 　 　 %mend date; %date(YYYY=2019,MM=02,Y=2019,M=02); run;   ... View more

　 Hi all, is there a way to make the do loop to loop my code according to the way I set?   If i use the code like this %do i=%eval(&MM.-1) %to &MONTH; it is correct if the macro date I set at the beginning is .For Ex:   YYYY=2019,MM=02. The i symbol in do loop will be 1,2 and 3. YYYY=2019,MM=03. The i symbol in do loop will be 2,3 and 4.     Now, if lets say i set the macro date to be   YYYY=2019,MM=01 , the i symbol in do loop supposed to be appeared as 12,1,2.  But it will help me to loop with number 0,1,2.   YYYY=2018,MM=12 , the i symbol in do loop supposed to be appeared as 11,12,1. But it will help me to loop with number 11,12,13.     However this is not work if using the same code above as this only follow the order of the number.   Is there a way to let the do loop follow the number i set to loop the code? My idea is like this below but this is not work   %if &MM=01 %then %do; %do i=12,1,2;    <---- i want the do statement loop the code with the number i set here ........... %end;   %else %if &MM=12 %THEN %DO; %do i=11,12,1; .... %end;   %else %do; %do i=%eval(&MM.-1) %to &MONTH; %end;           my complete  code is below:     %macro date(YYYY=2019,MM=01,Y=2019,M=01);%global YR MTH;   　 libname pl&Y&M. "\\kaiwksgh415thw5\Data\POLA\Claim\&Y\&Y&M\DBF"; Data pl&Y&M..POLA_clm_3months_&Y&M.; set pl&Y&M..POLA_clm_agg_&Y&M.; where accyr_fy=&YYYY. & accmth_fy<=%eval(&MM.+1); dev11yr_fy=min(accyr_fy-lossyr_fy,11);   run; PROC FORMAT; value $ class 'VEH'='1' 'FIR'='2' 'GMS'='3' 'BON'='3' 'HUL'='3' 'PAC'='4' 'TEL'='5' 'WWC'='5' 'LIA'='6' 'CGO'='7' 'ENG'='8'   ; RUN; 　 /************************************************************/ %macro financial (MONTH); %do i=%eval(&MM.-1) %to &MONTH;    　 %if &i.=1 %then %do; %let YR=%eval(&YYYY-1); %let MTH=12; %end;   %else %if &i.=12 %then %do; %let YR=&YYYY; %let MTH=11; %end;   %else %if &i.=11 %then %do; %let YR=&YYYY; %let MTH=10; %end; %else %do; %let YR=&YYYY; %let MTH=0%eval(&i.-1); %end;   　   PROC SQL; create table SMCD_PD_&YR&MTH. AS SELECT put(zmajrsk,$class.) as class, dev11yr_fy,sum(zclmpd) AS zclmpd FROM pl&Y&M..POLA_clm_3months_&Y&M. WHERE accmth_fy=&i. GROUP BY class,2;   run; 　 　 ods html file="\\kaiwksgh415thw5\Data\POLA\Claim\&YR\&YR&MTH\result\SMCD_mth_PD_FY_10DY_&YR&MTH..html"   style=normal; proc print; run; 　 　 　 %end; %mend financial; %financial(%eval(&MM.+1)); run;   　 %mend date; %date(YYYY=2019,MM=02,Y=2019,M=02); run;   ... View more