Hello,   I have a dataset let's say Temp1 with the following variables (10 observations): prov P1-5 P6_10 P16_20 P21_25 P26_30 P31_35 P36_40 P41_45 P46_50 P51_52   Based on the weeknumber of the year I would like to select a specific variable.   for example, if weeknumber =47 then I would like to create a datasubset with prov and P46_50   So, what I have done is to create a macro variable name VarName using the following macro function   %let week2=35; %macro SelectVar; %global VarName week2; %if &week2. ge 1 and le 5 %then %let VarName=P1_5; %if &week2. ge 6 and le 10 %then %let VarName=P6_10; %if &week2. ge 11 and le 15 %then %let VarName=P11_15; %if &week2. ge 16 and le 20 %then %let VarName=P16_20; %if &week2. ge 21 and le 25 %then %let VarName=P21_25; %if &week2. ge 26 and le 30 %then %let VarName=P26_30; %if &week2. ge 31 and le 35 %then %let VarName=P31_35; %if &week2. ge 36 and le 40 %then %let VarName=P36_40; %if &week2. ge 41 and le 45 %then %let VarName=P41_45; %if &week2. ge 46 and le 45 %then %let VarName=P46_50; %if &week2. ge 51 and le 52 %then %let VarName=P51_52; %mend SelectVar; %SelectVar; %put &Varname;   Then I can create my datasubset   Data Temp2 (keep=prov &Varname); set Temp1 (firstobs=1 obs=4); run;     Is there a more efficient way to do that? Thanks for your help   Alain     ... View more

Hello,   I want to put the week number into a macro variable ex:   %let today=%sysfunc(today()); %let week=%???? week(&today, 'v'); %put &week gives 2...   any suggestion?   Regards, Alain  ... View more

This code works perfectly with EG 7.15 but on the robot   (SAS version ????)   %let sysyear= %sysfunc(year("&sysdate"d)); %let Annee=&sysyear; %let FirstWDay=%sysfunc(NWKDOM(1,2,1,&Annee)); %let FirstWorkingDay=%sysfunc(inputn(&FirstWDay, z8.), date9.); %let Debut=%sysfunc(compress(%bquote('&FirstWorkingDay'd))); %put &sysyear; %put &annee; %put &firstwday; %put &firstworkingday;   1229 +%let sysyear= %sysfunc(year("&sysdate"d));  Le Système SAS 1230 + 1231 + %if &MotifRapport EQ FINANCIER %THEN 1232 + %DO; 1233 + %let Annee=&sysyear; 1234 + %let FirstWDay=%sysfunc(NWKDOM(1,2,1,&Annee)); 1235 + %let FirstWorkingDay=%sysfunc(inputn(&FirstWDay, z8.), date9.); 1236 + %let Debut=%sysfunc(compress(%bquote('&FirstWorkingDay'd))); 1237 + %END; 1238 + %ELSE 1239 + %DO; 1240 + %let Annee=%eval(&sysyear-1); 1241 + %let Debut=%sysfunc(compress(%BQUOTE('31OCT&Annee.'D))); 1242 + %END; 1243 +RUN; 1244 +%mend MotifRap; 1245 +%MotifRap; MLOGIC(MOTIFRAP): Début de l'exécution. MLOGIC(MOTIFRAP) : %GLOBAL ANNEE FIRSTWDAY FIRSTWORKINGDAY DEBUT MLOGIC(MOTIFRAP) : %LET (le nom de la variable est SYSYEAR) SYMBOLGEN: La macro-variable SYSDATE est résolue en 05JAN18 SYMBOLGEN: La macro-variable MOTIFRAPPORT est résolue en FINANCIER MLOGIC(MOTIFRAP) : La condition %IF &MotifRapport EQ FINANCIER est TRUE MLOGIC(MOTIFRAP) : %LET (le nom de la variable est ANNEE) SYMBOLGEN: La macro-variable SYSYEAR est résolue en 2018 MLOGIC(MOTIFRAP) : %LET (le nom de la variable est FIRSTWDAY) SYMBOLGEN: La macro-variable ANNEE est résolue en 2018 MLOGIC(MOTIFRAP) : %LET (le nom de la variable est FIRSTWORKINGDAY) SYMBOLGEN: La macro-variable FIRSTWDAY est résolue en 21185 WARNING: Argument 2 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value. MLOGIC(MOTIFRAP) : %LET (le nom de la variable est DEBUT) SYMBOLGEN: La macro-variable FIRSTWORKINGDAY est résolue en . MPRINT(MOTIFRAP): RUN; MLOGIC(MOTIFRAP) : Fin de l'exécution. 1246 +%put &Annee; SYMBOLGEN: La macro-variable ANNEE est résolue en 2018 2018 1247 +%put &FirstWDay;   Any idea how to solve this issue.  It is like the SAS on the robot does not recognize    %let FirstWorkingDay=%sysfunc(inputn(&FirstWDay, z8.), date9.);     ... View more

Hello,   I would like to make create a table using a proc sql but selecting different library based on the type of environment (DEV for development or PROD for production) .   For exemple, if TypeEnv  eq DEV , I would like to select the symy library and if TypeEnv eq PROD, I would like to select the 12symu library   I have tried this code and it is not working   %let typeEnv=DEV; *%let typeEnv=PROD; %macro Transfert; /*tranferts par agents ATO (Agents au Traitement des Opportunités);*/ proc sql; create table transfert as select table1.quand, table1.cdnname, table1.callsanswered as transferts, table1.callsoffered, table1.callsabandoned, table1.callsterminated, table2.sannee, table2.smois, table2.trimestre, table2.semaine %if typeEnv eq DEV %then %do; FROM symu.icdnstat as table1 left join commun.dates as table2 ON table1.quand = table2.date; %end; %else %do; FROM l2symu.icdnstat as table1 left join commun.dates as table2 ON table1.quand = table2.date; %end; QUIT; %mend Transfert; %Transfert;   Does any one have already found a solution for this situation? Regards, ... View more

Hello, based on the type of report (operational or financial) I am trying to get the good starting date (see below)   For an operational report, the starting date (debut) should be equal to '02jan2017'd; For a financial report, the starting date (Debut) should be equal to '31oct2016'd;   Here's my code below but It does work and I don’t know Why. Does someone could help me with that issue?   %let motifrap=FINANCIER; *%let MotifRap=OPERATIONNEL; %let sysyear= %sysfunc(year("&sysdate"d)); %MACRO MotifRap; %if &motifrap EQ "FINANCIER" %THEN %DO; %let Annee=&sysyear; %let FirstWDay=%sysfunc(NWKDOM(1,2,1,&Annee)); %let FirstWorkingDay=%sysfunc(inputn(&FirstWDay, z8.), date9.); %let Debut=%sysfunc(compress(%bquote('&FirstWorkingDay'd))); %END; %ELSE %DO; %let Annee=%eval(&sysyear-1); %let Debut=%sysfunc(compress(%BQUOTE('31OCT&Annee.'D))); %END; RUN; %mend MotifRap; %MotifRap; %put &Annee; %put &FirstWDay; %put &FirstWorkingDay; %put &Debut; %put &motifrap;   ... View more