About Nasser_DRMCP

ballardw · ‎09-04-2024

Or consider how you read the raw data: data have; infile datalines delimiter=","; input NUM_PTR @@ ; 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 ;

Tom · ‎08-27-2024

When you open a DATASET (as opposed some generic FILE) with the OPEN() function it returns a reference to that dataset. So to close it you pass that reference back to the CLOSE() function. %let rc=%sysfunc(close(&mv_id_table)) ;

Nasser_DRMCP · ‎07-04-2024

MANY THANKS !!!

Nasser_DRMCP · ‎05-02-2023

it s done ! thank for your help

pkm_edu · ‎02-22-2023

Hi Tom. Thanks for the clarification.

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 · ‎12-27-2022

hello, I copy/past the excel result in ultraedit and then I notice that a RC appears (but also quotes) manu thanks for your hep

Nasser_DRMCP · ‎12-16-2022

hello Ksharp it works very well as attended ! thanks for your efficiency

PaigeMiller · ‎08-12-2022

I have never created a report that has headers only and no data. I suppose you could create a fake data set with one row of missing data for every variable, and the run PROC REPORT on that fake data set.

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;

Tommer · ‎03-29-2022

/*First sort the have_contract and create a lag variable:*/ proc sort data=have_Contract; by descending version_begin_date; run; data have_contract2; set have_contract; version_lag = lag(version_begin_date); format version_lag ddmmyy10.; run; /*Then create a Cartesian product followed by filtering for what you need:*/ proc sql; create table all1 as select a.*, b.event_date from have_contract2 a, have_event b where a.contract_number=b.contract_number order by version_begin_date; quit; data all2; set all1; if version_lag ne . and version_begin_date=<event_date<version_lag then inc = 1; else if version_lag eq . and version_begin_date=<event_date then inc =1; if inc=1; drop version_lag inc; run; proc sort data=all2; by contract_number contract_version version_begin_date event_date;

Nasser_DRMCP · ‎12-03-2021

thank you very much very clear and very interesting

PaigeMiller · ‎10-18-2021

data modify; set have; /* Determine if start to end time crosses 30 minute boundary */ start_period=round(tsp_start-900,1800); end_period=round(tsp_end-900,1800); /* If start_period < end_period then we need to split the row into two or more rows */ if start_period < end_period then do; delta=floor(end_period-start_period)/1800; do i=0 to delta; duration=(min(end_period,tsp_end)-tsp_start); output; start_period=start_period+1800; tsp_start=end_period; end_period=end_period+1800; end; end; else do; duration=tsp_end-tsp_start; output; end; format start_period end_period datetime18. duration time.; drop i; run; proc summary data=modify nway; class start_period status; var duration; output out=want sum=; run;

Kurt_Bremser · ‎10-13-2021

Its a little more tricky than just using FIRST., but this does it: data have; input idt_ixn tsp_deb datetime18. top_dec $ ; informat tsp_deb datetime18.; format tsp_deb datetime18. ; datalines ; 123 10NOV2020:10:10:10 0 123 10NOV2020:11:11:11 1 123 10NOV2020:12:12:12 1 456 11NOV2020:10:10:10 0 456 12NOV2020:11:11:11 0 456 13NOV2020:12:12:12 0 ; data want; merge have have ( in=h1 keep=idt_ixn top_dec rename=(top_dec=_top) where=(_top = "1") ) ; by idt_ixn; __top = lag(top_dec); flag = 0; if first.idt_ixn and not h1 then flag = 1; if h1 and top_dec = "1" and (first.idt_ixn or __top ne "1") then flag = 1; drop _top __top; run;

Kurt_Bremser · ‎10-11-2021

So you only need proc sql noprint; select max(load_date) into :max_load from target; quit; data target_new; set target source (where=(load_date gt &max_load)) ; 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

Re: compile all values from many columns in a signle column

Re: close an opened table with open instruction

Re: proc export with url coming from a column

Re: function that returns a min date from table

Re: Fill missing values with the previous values

Re: write inside main log program and include program

Re: proc report : wrap text inside the excel celles

Re: proc report : unexpected return cariage

Re: proc report column define automatic label

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

Re: join two tables by comparing date in range dates

Re: loop scan dates values coming from variable of table

Re: cumul duration time by range time

Re: top row by group with flag

Re: Loading table. delta loading instead of full loading