About Nasser_DRMCP

Nasser_DRMCP · ‎09-04-2024

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

Nasser_DRMCP · ‎08-27-2024

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

Nasser_DRMCP · ‎07-04-2024

MANY THANKS !!!

Nasser_DRMCP · ‎07-03-2024

Hello, i need some hep. what I have ==>this is my have_table with client number and the web site of the client for exmaple in the "url" column. what I would like to get ==> an excel file with the "client" colum and by cliquing on a client number, the web site of the corresponding client would open. result ==> I try this code but I do not succeed to make an url depending of the client (of the row). many thanks in adance for your help regards Nasser

Nasser_DRMCP · ‎05-02-2023

it s done ! thank for your help

Nasser_DRMCP · ‎05-02-2023

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

Nasser_DRMCP · ‎05-02-2023

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

Nasser_DRMCP · ‎05-02-2023

I want to get the first working date after a specifiq day that is contained in a "HAVE" (not "want") table.

Nasser_DRMCP · ‎05-02-2023

yes but only based on a list of days in a table; it is important because I have a table with all "working" days defined; and then, I want to get the first working date after a specifiq day that is contained in a "want" table. I am trying something like this proc fcmp outlib=work.fonction.dates; function next_working_day(p_date , p_table $ , p_colonne $); proc sql; select min(p_colonne) into :nextdate from p_table where p_colonne > p_date ; return(nextdate); endsub; run; quit; Data T_TABLE_WANT ; set T_TABLE_HAVE ; output_date = next_working_day(input_date); run ;

Nasser_DRMCP · ‎05-02-2023

Thanks for your prompt respons I realize that my problem was not clearly defined; sorry for that. I have many dates in the input table; this is my "have" table and "want" table; that's why I would like to create a function; thanks Data T_TABLE_WANT ; input input_date ; informat input_date ddmmyy10. ; format input_date date9. ; datalines ; 02/06/2023 07/06/2023 15/06/2023 23/06/2023 29/06/2023 ; run ; Data T_TABLE_WANT ; input input_date output_date ; informat input_date output_date ddmmyy10. ; format input_date output_date date9. ; datalines ; 02/06/2023 03/06/2023 07/06/2023 08/06/2023 15/06/2023 16/06/2023 23/06/2023 24/06/2023 29/06/2023 30/06/2023 ; run ;

Nasser_DRMCP · ‎05-02-2023

not neccessary in a macro variable. Data T_TABLE1 ; input input_date ; informat input_date ddmmyy10. ; format input_date date9. ; datalines ; 23/06/2023 ; run ; the input date is in a table and I would lie to call the function like this: data T_TABLE2 ; set T_TABLE1 ; output_date = function(input_date,T_DATES) ; run ;

Nasser_DRMCP · ‎05-02-2023

Hello, I would like to create a function that returns the min date of a table wich is greater that an input date. for instance. with this table of june, if the input date is 23 june then the date returned should be 24 june. many thanks. Nasser Data T_DATES ; input day ; informat day ddmmyy10. ; format day date9. ; datalines ; 01/06/2023 02/06/2023 03/06/2023 04/06/2023 05/06/2023 06/06/2023 07/06/2023 08/06/2023 09/06/2023 10/06/2023 11/06/2023 12/06/2023 13/06/2023 14/06/2023 15/06/2023 16/06/2023 17/06/2023 18/06/2023 19/06/2023 20/06/2023 21/06/2023 22/06/2023 23/06/2023 24/06/2023 25/06/2023 26/06/2023 27/06/2023 28/06/2023 29/06/2023 30/06/2023 ; run ;

Nasser_DRMCP · ‎01-10-2023

hello thanks for your answer; No, the request was not to just write only start/stop messages to a different file. but this was not specifed in my post. your proposal works well thanks Nasser

Nasser_DRMCP · ‎01-09-2023

Many Thanks Paige and Erik. Sorry if my description was not so clear ! Thanks to yours answers I get the attended result. as you can see in the new inserted code, I use this : PROC PRINTTO LOG="main.log" ; RUN; (without "NEW") to write again in the main.log file The main log contains this text below as I wanted (I added a third included program) prog include is lauched prog include is complete prog include2 is lauched prog include2 is complete prog include3 is lauched prog include3 is complete PROC PRINTTO LOG="main.log" NEW; RUN; %put this is the begin of the main prog ; %put prog include is lauched ; %include "$GRPSBSAS/RQTCP_EI/DEV/include.sas" ; PROC PRINTTO LOG="main.log" ; RUN; %put prog include is completed ; %put prog include2 is lauched ; %include "$GRPSBSAS/RQTCP_EI/DEV/include2.sas" ; PROC PRINTTO LOG="main.log" ; RUN; %put prog include2 is completed ; %put prog include3 is lauched ; %include "$GRPSBSAS/RQTCP_EI/DEV/include3.sas" ; PROC PRINTTO LOG="main.log" ; RUN; %put prog include3 is completed ; %put this is the end of the main prog ; PROC PRINTTO; RUN; Then include.log (or 2 or 3) file contains "this is the begin of the include prog (or 2 or 3) this is the end of the include prog(or 2 or 3)

Nasser_DRMCP · ‎01-06-2023

Hello, my problem is that the content of the main plog is "this is the begin of the main prog" %include "$GRPSBSAS/RQTCP_EI/DEV/include.sas" ; and that s all. I wonder why the main prog does not continue to write "this is the end of the main prog". I would like to be able to open then to write in a main log. Then creating and writing in a sub log. And then, opening again and write again in the main log. But it seems to me that the proc printto of the include prog also close the main log Thanks for your help. /* below main prog*/ PROC PRINTTO LOG="main.log" NEW; RUN; %put this is the begin of the main prog ; %include "$GRPSBSAS/RQTCP_EI/DEV/include.sas" ; %put this is the end of the main prog ; PROC PRINTTO; RUN; /* below an include sub programme*/ PROC PRINTTO LOG="include.log" NEW; RUN; %put this is the begin of the include prog ; %put this is the end of the include prog ; PROC PRINTTO; RUN;

Online Status	Offline
Date Last Visited	‎09-10-2024 09:28 AM

compile all values from many columns in a signle column

close an opened table with open instruction

Re: proc export with url coming from a column

proc export with url coming from a column

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

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

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

compile all values from many columns in a signle column

close an opened table with open instruction

Re: proc export with url coming from a column

proc export with url coming from a column

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

Re: function that returns a min date from table

function that returns a min date from table

Re: write inside main log program and include program

Re: write inside main log program and include program

write inside main log program and include program