About Nasser_DRMCP

Nasser_DRMCP · ‎01-13-2021

Hello, I have a table t1 that holds 3 millions rows (with one datetime) and a table t2 that holds 5 millions rows (with 2 datetime) In a proc sql, i have a join like this select ... FROM t1 AS a LEFT JOIN t2 AS b ON a.IDT_RSS=b.IDT_RSS AND a.TSP_CVL BETWEEN b.TSP_TEST_DEB AND b.TSP_TEST_FIN ; cpu times takes 23 minutes. How coul I optimize ? thanks a lot in advance nasser

Nasser_DRMCP · ‎01-12-2021

Hello, I have a macro varaible that contains the texte : table1 table2 table3 table4 table5 table6 only table1 and table3 exists in the work librarie So i would like to get in a macro variable the text table1 table3 thanks in advance for your help Nasser

Nasser_DRMCP · ‎01-06-2021

Hello, I have a program that creates a table Inside the SBOX libray via macro prog and tables in the work Library. At the end of the program I would like to delete all tables in the work so I do proc delete library=work ; run ; My prob is that tables are still existing in the work Library and the sbox table is deleted many thanks in advance for your help regards Nasser

Nasser_DRMCP · ‎12-31-2020

data have; input client $ date1 date9. event1 $ date2 date9. event2 $ date3 date9. event3 $ imp1: date9. imp2: date9. imp3: date9. ; format date: imp: date9. ; datalines ; 12345 01JAN2020 CREATION 01APR2020 CREATION 01JUL2020 PROLONGATION 01MAR2020 01MAY2020 01SEP2020 ; Hello, happy new year ! For each imp, I would like to calculate the duration between the imp date and the greatest event among the creation event thanks a lot in advance delay1 of the imp1 = 2 = from january to mars (event 1 is the begining) delay2 of the imp2 = 1 = from april to may (event 2 is the begining) delay3 of the imp3 = 5 = from april to september (event 2 is the begining, event3 is ignored because not creation)

Nasser_DRMCP · ‎12-07-2020

thanks Ballardw Here is the result I would like to get client date status needed rules 123 10Nov2020 A 123 10Nov2020 S 1 first S of 10nov 123 12Nov2020 A 123 12Nov2020 S 1 first s of 12nov 456 10Nov2020 A 456 10Nov2020 S 1 first s of 10 nov 456 12Nov2020 S 1 first s of 12 nov 456 12Nov2020 S 2 2nd S of 12nov

Nasser_DRMCP · ‎12-07-2020

data have; input client date date9. status $ ; format date date9.; datalines ; 123 10NOV2020 A 123 10NOV2020 S 123 12NOV2020 A 123 12NOV2020 S 456 10NOV2020 A 456 10NOV2020 S 456 12NOV2020 S 456 12NOV2020 S ; data want ; set have ; by client date ; if first.date then cpt=1 ; else cpt +1 ; run ; Hello, this code enumerate the rows by client/date group whatever the status. I would like to enumerate rows only if status = S thanks in advance for your help regard Nasser

Nasser_DRMCP · ‎12-02-2020

thanks to your help, the solution is data have; input client date date9. datetime datetime20. status $ ; informat datetime datetime20.; format datetime datetime20. date date9.; datalines ; 12345 10NOV2020 10NOV2020:10:10:10 A 12345 11NOV2020 11NOV2020:11:11:11 S 12345 12NOV2020 12NOV2020:12:12:12 S 12345 12NOV2020 12NOV2020:12:13:13 S 12345 12NOV2020 12NOV2020:12:14:14 A 92345 10NOV2020 10NOV2020:10:10:10 A 92345 11NOV2020 11NOV2020:11:11:11 S 92345 12NOV2020 12NOV2020:12:12:12 S 92345 12NOV2020 12NOV2020:12:13:13 S 92345 12NOV2020 12NOV2020:12:14:14 A ; proc sort data=have; by client datetime ;run ; 　 data want (drop=_:); set have (where=(status='S') in=ins) have (in=keep); by client; if first.client then call missing(_last_s_date); if ins then _last_s_date=date; retain _last_s_date; if keep; if date=_last_s_date and status='S' then flag=1; else flag=0; run; data want(drop=_:) ; format _last_s_datetime datetime20. ; set have (where=(status='S') in=ins) have (in=keep); by client date ; if first.datetime then call missing(_last_s_datetime); if ins then _last_s_datetime=datetime; retain _last_s_datetime; if keep; if datetime=_last_s_datetime and status='S' then flag=1; else flag=0; run;

Nasser_DRMCP · ‎12-02-2020

thanks mkeintz I have clarified my problem. I hope it is clearer . I do not manage to implement your suggestion thanks for your help

Nasser_DRMCP · ‎12-02-2020

Hello, thanks for your quick respons I am sorry, I figure out that I should clarify my problem. I need to flag the last status S for each client and each day in this new dataset with date and time, what I want is : for the day 10NOV==>flag to 0 for the day 11NOV==>flag to 1 for the day 12NOV==>flag to 1 only for line 12:13:13 data have; input client date :datetime18. status $ ; informat date datetime20.; format date datetime20.; datalines ; 12345 10NOV2020:10:10:10 A 12345 11NOV2020:11:11:11 S 12345 12NOV2020:12:12:12 S 12345 12NOV2020:12:13:13 S 12345 12NOV2020:12:14:14 A ;

Nasser_DRMCP · ‎12-01-2020

Hello I need to create a flag. the value should be 1 onfly for the last date among the staus S. here, only the row 3 thanks for your help data have; input client date status $ ; informat date date9.; format date date9.; datalines ; 12345 10NOV2020 A 12345 11NOV2020 S 12345 12NOV2020 S 12345 12NOV2020 B ;

Nasser_DRMCP · ‎09-30-2020

Thanks Bart for your quick respons but I would like to delete without specifying the variables names. then I could call the same command for programmes without knowing the varaibles names. thanks

Nasser_DRMCP · ‎09-30-2020

hello how could I delete all macro variables defined by user during program execution thanks in advance for your help Regards Nass

Nasser_DRMCP · ‎09-15-2020

I do not know the scheduler. I found the environment variable "SASCLI". and this is exactly what I need in saseg the returned value is "SASEG" in batch the returned value is "BATCH" thanks for your help

Nasser_DRMCP · ‎09-15-2020

thanks Shmuel. I wonder if there is a workaround to get the mode with sas studio. UE, analytics... thanks

Nasser_DRMCP · ‎09-15-2020

Hi, I would like to get the launching mode, interactiv or batch. I use &sysenv. but i see that "BACK" is returned in both modes. however "FORE" was expected in interactiv mode. thanks in advance for your help regards Nasser

Online Status	Online
Date Last Visited	4 hours ago

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: catch program failed

Re: catch program failed

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

optimizing proc sql join

get only existing tables

probleme with proc delete

calculated delay between dates with condition

Re: enumerate rows by group by only on condition

enumerate rows by group by only on condition

Re: get the last row of a group with a condition

Re: get the last row of a group with a condition

Re: get the last row of a group with a condition

get the last row of a group with a condition

Re: remove macro variables defined by user

remove macro variables defined by user

Re: catch environment mode. interactiv or batch

Re: catch environment mode. interactiv or batch

catch environment mode. interactiv or batch