About Nasser_DRMCP

Nasser_DRMCP · ‎08-12-2022

PROC REPORT DATA=sashelp.CLASS NOWD STYLE(header)=[background=CX9BC2E6 foreground=white just=center] STYLE(column)=[cellwidth=3cm] ; COLUMN NAME SEX AGE HEIGHT WEIGHT ; DEFINE NAME / DISPLAY "Nom" ; DEFINE HEIGHT / DISPLAY "Taille" ; DEFINE WEIGHT / DISPLAY "Poids" ; RUN; ODS Excel CLOSE; ODS LISTING; Hello, I have to create many proc report (many tables). so if I plan to duplicate this proc report code (copy/paste ) . My problem is : whenever I would like to change the label "Nom" by "Le nom" I should change all proc report. How could I specify the label at only one place and specify all proc report to get the label corresponding of a column ? and all "proc report" should automatically change whenever the label is changed. Many thanks in advance Regards Nasser

Nasser_DRMCP · ‎06-30-2022

/* below : MAINPROG */ /* create the log of the mainprog */ PROC PRINTTO log='$GRPLOGS/MAINPROG.log' new; RUN; %INCLUDE '$GRPSBSAS/SUIVIS/CLIENT/RECOUV/CESSION/SUBPROG1.sas'; /*close the log of the main prog */ PROC PRINTTO; RUN; /* BELOW the SUBPROG1 */ %PUT the SUBPROG1 is started ; /* create the log of the SUBPROG1 */ PROC PRINTTO LOG="$GRPLOGS/SUBPROG1.log" NEW; RUN; %put this is the SUBPROG1 ; /* close the log of the SUBPROG1 */ PROC PRINTTO; RUN; %PUT the SUBPROG1 is completed ; Hello PaigeMiller please find the code of the prog main and sub prog 1. and this is below the entire log of the main prog. as you can notice, "started" appears but "completed" does not ! many Thanks . main log==> NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 23 24 25 %INCLUDE '$GRPSBSAS/SUIVIS/CLIENT/RECOUV/CESSION/SUBPROG1.sas'; NOTE: %INCLUDE (level 1) file $GRPSBSAS/SUIVIS/CLIENT/RECOUV/CESSION/SUBPROG1.sas is file /data/crea/creapil/sbsas/SUIVIS/CLIENT/RECOUV/CESSION/SUBPROG1.sas. 26 + 27 +%PUT the SUBPROG1 is started ; the SUBPROG1 is started 28 + 29 +/* create the log of the SUBPROG1 */ 30 +PROC PRINTTO LOG="$GRPLOGS/SUBPROG1.log" NEW; 31 +RUN;

Nasser_DRMCP · ‎06-28-2022

Not writing it at all, neithor in the log of the main prog, nor in the log of the sub prg 1

Nasser_DRMCP · ‎06-28-2022

Hello PaigeMiller thanks for you quick respons sorry for forgetting explanation on what does not work. My problem is that the subprog 1 writes ""The subprog 1 is started" inside the log file of the main prog but "The subprog 1 is completed" is not writing regards Nasser

Nasser_DRMCP · ‎06-28-2022

Hello, I have 3 programs. one main program that launch two sub programs. I would like 3 log files. I would like to obtain this 4 notes below inside the log of the main prog "The subprog 1 is started" "The subprog 1 is completed" "The subprog 2 is started" "The subprog 2 is completed" so this is what I done but it does not work : in the main prog : PROC PRINTTO log='$GRPLOGS/mainprog.log' new; RUN; %include subprog1.sas %include subprog2.sas proc printto; run ; in the subprog1 %PUT the prog 1 is started ; PROC PRINTTO LOG='$GRPLOGS/subprog1' NEW; RUN; %PUT the prog 1 is completed ; proc printto ; run ; and the same for the subprog2 ; many thanks a lot in advance kind regards Nasser

Nasser_DRMCP · ‎03-29-2022

Hi mkeintz many thanks for your help. I have an additional question. I notice that if a contratc exists in the in have_contract table but not in the have_event table then this contract does not exist in the "want" table. is it possible to get all contracts even thoses without events ? thanks in advance Nasser

Nasser_DRMCP · ‎03-17-2022

hello I succeeded to get the result I expected . first I sort my data by descending date .and then with LAG I could determine the version_begin_date_next. and then with the filter below and event_date>= a.version_begin_date and b.event_date < a.version_bvegin_date_next Nasser

Nasser_DRMCP · ‎03-17-2022

Data have_contract ; input contract_number contract_version version_begin_date ; informat version_begin_date ddmmyy10. ; format version_begin_date ddmmyy10. ; datalines ; 123456789 1 01/09/2021 123456789 2 02/10/2021 123456789 3 03/11/2021 run ; data have_event ; input contract_number event_date ; informat event_date ddmmyy10. ; format event_date ddmmyy10. ; datalines; 123456789 01/09/2021 123456789 08/09/2021 123456789 03/10/2021 123456789 30/10/2021 123456789 03/11/2021 123456789 13/11/2021 123456789 23/11/2021 run ; Data want ; input contract_number contract_version version_begin_date event_date ; informat version_begin_date event_date ddmmyy10. ; format version_begin_date event_date ddmmyy10. ; datalines ; 123456789 1 01/09/2021 01/09/2021 123456789 1 01/09/2021 08/09/2021 123456789 2 02/10/2021 03/10/2021 123456789 2 02/10/2021 30/10/2021 123456789 3 03/11/2021 03/11/2021 123456789 3 03/11/2021 13/11/2021 123456789 3 03/11/2021 23/11/2021 run ; Hello, I would like to join this 2 tables "have". But I only want to join the events wich have an event date greater or equal the begin_date of the version and less than the the begin date of the next version. thanks in advance for your help kind regards Nasser

Nasser_DRMCP · ‎12-03-2021

thank you very much very clear and very interesting

Nasser_DRMCP · ‎12-03-2021

ok I found the solution.see below. in the scan I forgot to specify the separator space. this code below works as I intended %macro mc_boucle_surlesjours ; %local i next_jour; %let i=1; %do %while (%scan(&liste_jour, &i, " ") ne ); %let next_jour = %scan(&liste_jour, &i, " "); %put -->&next_jour ; %let i = %eval(&i + 1); %end ; %mend ;

Nasser_DRMCP · ‎12-03-2021

by executing this %macro mc_boucle_surlesjours ; %local i next_jour; %let i=1; %do %while (%scan(&liste_jour, &i) ne ); %let next_jour = %scan(&liste_jour, &i); %put -->&next_jour ; %let i = %eval(&i + 1); %end ; %mend ; %mc_boucle_surlesjours ; the result is -->01 -->01 -->2022 -->02 -->01 -->2022 -->03 -->01 -->2022 -->04 -->01 -->2022 -->05 -->01 -->2022 -->06 -->01 -->2022 -->07 ...

Nasser_DRMCP · ‎12-03-2021

I would like to write a loop step with the objectif is to put into a variable the values 01/01/2022 for iteration 1 02/01/2022 for iteration 2 03/01/2022 for iteration 3 04/01/2022 ... 05/01/2022 06/01/2022 07/01/2022 08/01/2022 09/01/2022 10/01/2022 11/01/2022 for the last iteration

Nasser_DRMCP · ‎12-03-2021

I have a table with a variable "day" that containes dates values like "01/01/022" "02/01/2022" "03/01/2022" … I would that a macro variable gets each values by usinf a loop

Nasser_DRMCP · ‎12-03-2021

Hello, data have; input jour DDMMYY10. ; format jour DDMMYY10. ; datalines; 01/01/2022 02/01/2022 03/01/2022 04/01/2022 05/01/2022 06/01/2022 07/01/2022 08/01/2022 09/01/2022 10/01/2022 11/01/2022 ; proc sql; select distinct jour into :liste_jour separated by ' ' from have ; quit ; %put &liste_jour; by executing this code above the result is 01/01/2022 02/01/2022 03/01/2022 04/01/2022 05/01/2022 06/01/2022 07/01/2022 08/01/2022 09/01/2022 10/01/2022 11/01/2022 But my problem is when I try to get each date value for loop like this below; the result is not corret because it is 01 and 01 and 2021... thanks in advance for your help kind regards Nass %macro mc_boucle_surlesjours ; %local i next_jour; %let i=1; %do %while (%scan(&liste_jour, &i) ne ""); %let next_jour = %scan(&liste_jour, &i); %put -->&next_jour ; %let i = %eval(&i + 1); %end ; %mend ; %mc_boucle_surlesjours ;

Nasser_DRMCP · ‎10-18-2021

data have; input employee $ tsp_start tsp_end datetime18. status $ ; informat tsp_start tsp_end datetime18.; format tsp_start tsp_end datetime18. ; format employee status $4. ; datalines ; AAAA 10SEP2121:08:00:00 10SEP2121:08:04:00 BUSY AAAA 10SEP2121:08:05:30 10SEP2121:08:12:30 CALL AAAA 10SEP2121:08:14:20 10SEP2121:08:15:20 BUSY AAAA 10SEP2121:08:28:20 10SEP2121:08:34:20 CALL AAAA 10SEP2121:08:35:00 10SEP2121:08:40:10 BUSY ; run; data want; input employee $ range_below range_top datetime18. status $ duration time. ; informat range_below range_top datetime18.; format range_below range_top datetime18. ; format employee status $4. ; format duration time. ; datalines ; AAAA 10SEP2121:08:00:00 10SEP2121:08:30:00 BUSY 00:05:00 AAAA 10SEP2121:08:00:00 10SEP2121:08:30:00 CALL 00:08:40 AAAA 10SEP2121:08:30:00 10SEP2121:09:00:00 BUSY 00:05:10 AAAA 10SEP2121:08:30:00 10SEP2121:09:09:00 CALL 00:04:20 ; run; Hello some emlpoyees make calls. calls have begin time and end time so duration. there are "call" phases and "busy" phases. I would like to calculate duraiton time of "call" phase and "busy" phase but for every range time. a range is 30min duration. so range1 is from 08:00 to 08:30 range2 is from 08:30 to 09:00 range3 is from 09:00 to 09:30 ... range 24 from 19:30 to 20:00 for example, in the "want" table, row 2 the duration is 08:40 (concerning range 08:00 to 08:30) because we cumulate 7 min (08:05:30 to 08:12:30) and 1:30 (coming from row 5, 08:28:20 to 08:30:00) thanks in advance kind regards Nass

Online Status	Offline
Date Last Visited	3 weeks ago

Re: problem with where clause on numeric

problem with where clause on numeric

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

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

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

struggle with join toward a table with 3 billions rows

duration between 2 dates and display hour min sec

struggle with different date format in a string

Re: macro with returned value string instead numeric

macro with returned value string instead numeric

Re: Converting Date number to Date9.

Re: create subgroup number by group

Re: generate a random integer without duplicate

Re: generate a random integer without duplicate

Re: generate a random integer without duplicate

struggle with different date format in a string

Re: function that returns a min date from table

join two tables by comparing date in range dates

Re: sgplot xaxis NOT sorted for all group values

proc report column define automatic label

Re: write in log of a main program and a sub program

Re: write in log of a main program and a sub program

Re: write in log of a main program and a sub program

write in log of a main program and a sub program

Re: join two tables by comparing date in range dates

Re: join two tables by comparing date in range dates

join two tables by comparing date in range dates

Re: loop scan dates values coming from variable of table

Re: loop scan dates values coming from variable of table

Re: loop scan dates values coming from variable of table

Re: loop scan dates values coming from variable of table

Re: loop scan dates values coming from variable of table

loop scan dates values coming from variable of table

cumul duration time by range time