cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Nasser_DRMCP
‎10-10-2025
  • 280 Posts
  • 44 Likes Given
  • 11 Solutions
  • 5 Likes Received

Re: struggle with join toward a table with 3 billions rows

by Lapis Lazuli | Level 10 in SAS Programming
‎10-07-2025 04:44 AM
‎10-07-2025 04:44 AM
hello thanks to your advices I managed to optimise very much. I have a column "send date" in the big table so I added a criteria inside the inner join expression to limite the rows that are > of begining of the month. many thanks. Nasser ... View more

Re: struggle with join toward a table with 3 billions rows

by Lapis Lazuli | Level 10 in SAS Programming
‎10-06-2025 06:12 AM
‎10-06-2025 06:12 AM
hello thanks for your respons. I tested what tom has suggested. and the 2 codes take the same time, arroud 10 min   nasser ... View more

Re: struggle with join toward a table with 3 billions rows

by Lapis Lazuli | Level 10 in SAS Programming
‎10-03-2025 08:26 AM
‎10-03-2025 08:26 AM
about 200 000. i have to do that for 50 differents models ... View more

struggle with join toward a table with 3 billions rows

by Lapis Lazuli | Level 10 in SAS Programming
‎10-03-2025 05:37 AM
‎10-03-2025 05:37 AM
hello   I a struggling with a proc sql . it takes too much time, too much cpu. I have two tables. table of mails (500 milions rows / 10 columns ) with the n° mail and the model of the mail and the send date .  tables of client/mails (3 billions) with n° mail + n° client (but without the model of the mail, sans la date). I would like to get the list of the client that are received the model mail '503106'  in september. should I make a join between the two big vertica tables ? or should I , first, create a sas table filtered on model and the sent month. and join this sas table on the second vertica table ? many thanks in advance Nasser ... View more

duration between 2 dates and display hour min sec

by Lapis Lazuli | Level 10 in SAS Programming
‎09-25-2025 10:01 AM
‎09-25-2025 10:01 AM
hello data have; input TSP_DEB TSP_MOF datetime25.6 ; informat TSP_DEB TSP_MOF datetime25.6; format TSP_DEB TSP_MOF datetime25.6 ; datalines ; 24SEP2025:15:13:35.000000 24SEP2025:15:21:00.000000 ; i get 2 datetime. i would like to create a colum with "0h 7m 25s" many thanks for your help Nass ... View more

struggle with different date format in a string

by Lapis Lazuli | Level 10 in SAS Programming
‎09-04-2025 05:09 AM
1 Like
‎09-04-2025 05:09 AM
1 Like
Hello data have; format date_char $100. ; date_char = '14/09/2035' ; output; date_char = '2035-07-02' ; output ; run; data have2 ; set have ; format date_num1 date_num2 date9. ; date_num1=input(date_char,ddmmyy10.); date_num2=input(date_char,yymmdd10.); run ;     hello I have a string column  that contains different format of dates. my aim is to get a column that transforms char in a date column. by using input, I get a missing value depending the input format. How could I get a colum that always works (without missing) whatever the format date of my source column date_char thanks in advance Nasser ... View more

Re: macro with returned value string instead numeric

by Lapis Lazuli | Level 10 in SAS Programming
‎08-11-2025 11:27 AM
‎08-11-2025 11:27 AM
/*  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

macro with returned value string instead numeric

by Lapis Lazuli | Level 10 in SAS Programming
‎08-11-2025 11:13 AM
‎08-11-2025 11:13 AM
%macro mc_delai_jours_ouvres_Z21 ( p_date_debut , p_date_fin , p_flag_jour_ouvre , p_cod_pay_iso , p_cod_lng ) ; %local rc nbr_jou_ouv ; %let p_date_min = min(&p_date_debut,&p_date_fin) ; %let p_date_max = max(&p_date_debut,&p_date_fin) ; %if &p_date_debut <= &p_date_fin %then %do ; %let sens_chrono = 1 ; %end ; %else %do ; %let sens_chrono = -1 ; %end ; %let rc=%sysfunc(dosubl(%nrstr( proc sql noprint ; select count(DAT_CVL) * &sens_chrono into :nbr_jou_ouv from SBOX.&mv_prefixe_tab_dim._Z21I_5ans where DAT_CVL > &p_date_min and DAT_CVL <= &p_date_max and &p_flag_jour_ouvre = 'O' and COD_PAY_ISO = "&p_cod_pay_iso" and COD_LNG_RIU = "&p_cod_lng" ; quit; ))) ; %superq(nbr_jou_ouv) %mend mc_delai_jours_ouvres_z21 ; data test ; delai = resolve(cats('%mc_delai_jours_ouvres_z21(' , '01JUL2025'd, ',' , '31JUL2025'd, ',FLG_JOU_OUV' , ',FR' , ',FR' , ')' )) ; run ; hello this is the code of my macro that calculate a delay between two dates. and the result is correct. i mean, the "delai" column in the test table is 21. but this returned delai is a string and not a numeric . so by using this kind of comparator if delai > 6 ...i get this "ERROR: Expression using greater than (>) has components that are of different data types." ... View more

Re: catch program failed

by Lapis Lazuli | Level 10 in SAS Programming
‎08-11-2025 05:47 AM
‎08-11-2025 05:47 AM
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

Re: catch program failed

by Lapis Lazuli | Level 10 in SAS Programming
‎08-11-2025 05:02 AM
‎08-11-2025 05:02 AM
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

catch program failed

by Lapis Lazuli | Level 10 in SAS Programming
‎08-11-2025 04:40 AM
‎08-11-2025 04:40 AM
Hello,   How can I get the information that a running program failed ? by doing that, my purpose is (for example)  to send a mail to inform thanks in advance for your help. regards Nasser ... View more

use ampersand in concatenation string but not a macro variable

by Lapis Lazuli | Level 10 in SAS Programming
‎01-06-2025 05:04 AM
‎01-06-2025 05:04 AM
data get_base_url ; format HTTPS $50. ; format appli $10. ; appli = 'GEC' ; HTTPS = "https://gec0-kf.compagny.fr/CONSULTATION/?mnc=GEC" ; output ; run ; %macro mv_calcul_url(p_appli, p_banque) ; %local rc url_definie ; %let url_definie = ; %let rc=%sysfunc(dosubl(%nrstr( proc sql noprint ; select HTTPS||"&banque="||&p_banque into :url_renvoye from get_base_url where appli = "&p_appli" ; quit ; ))) ; &url_renvoye ; %mend mv_calcul_url; data get_table_finale1 ; banque = '14940' ; output ; run ; data want_table_finale2 ; set table_finale1 ; url_gec = "%mv_calcul_url(GEC,banque)"; run ; hello i would like to get a url_gec column that contains the string 'https://gec0-kf.compagny.fr/CONSULTATION/?mnc=GEC&banque=14940' but the log file says that : WARNING: Apparent symbolic reference BANQUE not resolved. ERROR: The following columns were not found in the contributing tables: banque.   many thanks in advance for your help ... View more

compile all values from many columns in a signle column

by Lapis Lazuli | Level 10 in SAS Programming
‎09-04-2024 08:19 AM
‎09-04-2024 08:19 AM
data have; infile datalines delimiter=","; input NUM_PTR_NIV_0 NUM_PTR_NIV_1 NUM_PTR_NIV_2 NUM_PTR_NIV_3 ; datalines ; 08000000080,08000000190,08000000080,08000011800 08000000080,08000000190,08000000080,08000905580 08000000087,08000000190,08000000080,08000011320 08000000087,08000000190,08000000080,08000011150 08000000080,08000000190,08000000080,08000010840 08000000081,08000001190,08000000180,08000905580 08000000082,08000002190,08000000280,08000011320 08000000083,08000003190,08000000380,08000011150 08000000084,08000004190,08000000480,08000010840 run ; data want; infile datalines delimiter=","; input NUM_PTR ; datalines ; 8000000080 8000000087 8000000081 8000000082 8000000083 8000000084 8000000190 8000001190 8000002190 8000003190 8000004190 8000000180 8000000280 8000000380 8000000480 8000011800 8000905580 8000011320 8000011150 8000010840 run ; hello, i have many partners number in different level; i would like to get a list of all partners in a column many thanks for your help kind regards Nasser ... View more

close an opened table with open instruction

by Lapis Lazuli | Level 10 in New SAS User
‎08-27-2024 09:18 AM
‎08-27-2024 09:18 AM
hello data HAVE ; x=1; run ; %let mv_id_table = %sysfunc(open(work.HAVE)); proc datasets library=WORK memtype=data nolist; delete HAVE ; quit ; by executing this code, the note is "File WORK.HAVE (memtype=DATA) cannot be deleted because it is in use." how could I close the HAVE table ? thanks in advance for your help regards Nasser ... View more

Re: proc export with url coming from a column

by Lapis Lazuli | Level 10 in SAS Procedures
‎07-04-2024 04:11 AM
‎07-04-2024 04:11 AM
MANY THANKS !!! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-10-2025 03:06 AM
Likes given to
Likes from
Quick links