/* 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
