/*  step 1 */ data test ; delai = resolve(cats('%mc_delai_jours_ouvres_z21(' , '01JUL2025'd, ',' , '31JUL2025'd, ',FLG_JOU_OUV' , ',FR' , ',FR' , ')' )) ; run ;   /*  step 2 */ proc sql; create table test2 as select case when resolve(cats('%mc_delai_jours_ouvres_z21(' , '01JUL2025'd, ',' , '31JUL2025'd, ',FLG_JOU_OUV' , ',FR' , ',FR' , ')' ))  > 6  then 'O' else 'N' end as ANO_DELAI from test ; quit ;   /*  below the log of the step 2*/   The SAS System Monday, August 11, 2025 10:58:00 AM 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='MC_CALCUL_PERIODE.sas'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE='/home/ldap/mellouna/smsas/MC_CALCUL_PERIODE.sas'; 9 %LET _SASPROGRAMFILEHOST='lsas1kj3.cm-cic.fr'; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported MPRINT(HTML5ACCESSIBLEGRAPHSUPPORTED): ACCESSIBLE_GRAPH 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 %saseg_interactive_begin(); MPRINT(SASEG_INTERACTIVE_BEGIN): DATA _NULL_; MPRINT(SASEG_INTERACTIVE_BEGIN): file "/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_debut.log"; MPRINT(SASEG_INTERACTIVE_BEGIN): export_date=put(date(),ddmmyy10.); MPRINT(SASEG_INTERACTIVE_BEGIN): export_time=put(time(),time.); MPRINT(SASEG_INTERACTIVE_BEGIN): PUT "DEBUT;mellouna;'';'/home/ldap/mellouna/smsas/MC_CALCUL_PERIODE.sas';lsas1kj3;3217457;" export_date+(-1)";" export_time+(-1); MPRINT(SASEG_INTERACTIVE_BEGIN): RUN; NOTE: The file "/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_debut.log" is: Filename=/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_debut.log, Owner Name=mellouna,Group Name=domain users, Access Permission=-rw-rw-r--, Last Modified=11Aug2025:17:24:38 NOTE: 1 record was written to the file "/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_debut.log". The minimum record length was 104. The maximum record length was 104. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 605.03k OS Memory 59324.00k Timestamp 08/11/2025 05:24:38 PM Step Count 186 Switch Count 0 2 The SAS System Monday, August 11, 2025 10:58:00 AM Page Faults 0 Page Reclaims 22 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 MPRINT(SASEG_INTERACTIVE_BEGIN): x "cat /data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_debut.log >> $SAS_APPLI/data/stats/saseg_interactive.log"; 29 30 proc sql; 31 create table test2 as 32 select case when resolve(cats('%mc_delai_jours_ouvres_z21(' , '01JUL2025'd, ',' , '31JUL2025'd, ',FLG_JOU_OUV' , ',FR' , 32 ! ',FR' , ')' )) > 6 33 then 'O' 34 else 'N' end as ANO_DELAI 35 from test ; ERROR: Expression using greater than (>) has components that are of different data types. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 36 quit ; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 5755.53k OS Memory 64448.00k Timestamp 08/11/2025 05:24:38 PM Step Count 187 Switch Count 0 Page Faults 0 Page Reclaims 10 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 37 38 %saseg_interactive_end(); MPRINT(SASEG_INTERACTIVE_END): DATA _NULL_; MPRINT(SASEG_INTERACTIVE_END): file "/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_fin.log"; MPRINT(SASEG_INTERACTIVE_END): export_date=put(date(),ddmmyy10.); MPRINT(SASEG_INTERACTIVE_END): export_time=put(time(),time.); MPRINT(SASEG_INTERACTIVE_END): PUT "FIN;mellouna;'';'/home/ldap/mellouna/smsas/MC_CALCUL_PERIODE.sas';lsas1kj3;3217457;" export_date+(-1)";" export_time+(-1); MPRINT(SASEG_INTERACTIVE_END): RUN; NOTE: The file "/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_fin.log" is: Filename=/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_fin.log, Owner Name=mellouna,Group Name=domain users, Access Permission=-rw-rw-r--, Last Modified=11Aug2025:17:24:38 3 The SAS System Monday, August 11, 2025 10:58:00 AM NOTE: 1 record was written to the file "/data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_fin.log". The minimum record length was 102. The maximum record length was 102. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 717.15k OS Memory 59324.00k Timestamp 08/11/2025 05:24:38 PM Step Count 188 Switch Count 0 Page Faults 0 Page Reclaims 22 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 MPRINT(SASEG_INTERACTIVE_END): x "cat /data/sastmp1/saswork/SAS_work7A1400311831_lsas1kj3/SAS_work9D0400311831_lsas1kj3/saseg_interactive_tmp_fin.log >> $SAS_APPLI/data/stats/saseg_interactive.log"; 39 40 %LET _CLIENTTASKLABEL=; 41 %LET _CLIENTPROCESSFLOWNAME=; 42 %LET _CLIENTPROJECTPATH=; 43 %LET _CLIENTPROJECTPATHHOST=; 44 %LET _CLIENTPROJECTNAME=; 45 %LET _SASPROGRAMFILE=; 46 %LET _SASPROGRAMFILEHOST=; 47 48 ;*';*";*/;quit;run; 49 ODS _ALL_ CLOSE; 50 51 52 QUIT; RUN; 53 ... View more

thanks ksharp one more question please. is it possible to scan all log files of today in a folder (files name are like ...._20250811.log) and check each file like ? many thanks ... View more

sorry, by "failed", I mean, the launched program stops because of error. %macro erreur_programme; /* trap error here */ %if &syserr^=0 %then %do; %put an error occurs ; %end ; %mend erreur_programme ; data test; x=1 /* <-- intentionally leave off a semicolon to produce an error*/ run ; %erreur_programme;   I try this code but it does not work  ... View more

MANY THANKS !!! ... View more

it s done ! thank for your help ... View more

Quentin, I agree with you to accept the FreelanceReinh 's solution; but I don't know how t un-accept yours ... View more

OK.I try to be clear. with july it should be clearer;  in input I have 2 tables; T_WORKING_DAYS and T_HAVE; note that 14 is missing in T_WORKING_DAYS because is not a working day   Data T_WORKING_DAYS ; input day ; informat day ddmmyy10. ; format day date9. ; datalines ; 01/07/2023 02/07/2023 03/07/2023 04/07/2023 05/07/2023 06/07/2023 07/07/2023 08/07/2023 09/07/2023 10/07/2023 11/07/2023 12/07/2023 13/07/2023 15/07/2023 16/07/2023 17/07/2023 18/07/2023 19/07/2023 20/07/2023 21/07/2023 22/07/2023 23/07/2023 24/07/2023 25/07/2023 26/07/2023 27/07/2023 28/07/2023 29/07/2023 30/07/2023 31/07/2023 ; run ; Data T_HAVE ; input input_date ; informat input_date ddmmyy10. ; format input_date date9. ; datalines ; 13/07/2023 23/07/2023 29/07/2023 ; run ;  I would like to get a T_WANT_TABLE that contains 2 columns. "input_date" column coming from T_HAVE table. and "output_date" column would be the first date (the smallest) after the input_date. for examle, by applying the function to first row, where the input_date is 13/07/2023; the function woud return 15/07/2023 because 15/07 is the first day among dates in  T_WORKING_DAYS that is greater than 13    ... View more