you are right. i give you a sample of data data source ; length project_name $ 9; input num_client project_name $ project_amount date_load date_update ; informat date_load date_update ddmmyy10.; format date_load date_update ddmmyy10.; datalines; 280001 home 15000 01/04/2019 20/04/2019 280002 car 3000 01/05/2019 . 280003 personnal 2250 30/06/2019 . 280004 home 25000 31/07/2020 01/08/2020 280005 car 12000 21/01/2021 . 280006 personnal 1500 20/02/2021 . 280007 home 75500 12/04/2021 12/05/2021 280008 car 42000 27/05/2021 . 280009 personnal 2000 05/09/2021 10/10/2021 280010 home 2000 10/10/2021 . ; run; in the target table, amount of the client 28009 is 1000 (and not 2000 yet). and the client 20010 does not exist yet I would like to identify client 28009 the be updated ans client 20010 to be inserted. I Don't know the best way to do that. there is no dimensional (star schema) with fact and dimension tables with keys) this table is "alone" thanks ... View more

thanks Kurt for the explanations. I have no more errors. but the last obs I get returns the variables "date_update" "and" date_load "with the values ". " And I don't understanbd this result because by getting min and max of this 2 variables with proc sql, result is "02JUN2014 / 09OCT2021 / 02JUN2014 / 08OCT2021" so why the step with "point=..." returns "." ? and does not return a "09OCT2021" and "08OCT2021" ... View more

yes, but when I try this data step bellow. I encounter an error "out of memory" and the result is very big "t_last table" table. data t_last ; set sashelp.class nobs=NOBS point=NOBS; run;   I know that this code bellow works well==> data last ; /* get number of records (N) */ if 0 then set sashelp.class nobs=p_nobs end=eof; /* use POINT= to get nth record */ set sashelp.class point=p_nobs; output; stop; run;   Chris said "Yes exactly. My code does the same in one line." sorry, but I Don't know how. Thanks ... View more

1 The SAS System Monday, October 11, 2021 11:12:00 AM 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='DTM_SIMU_VDELTA'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE='/home/ldap/rollens/sbsas/ROLLENS/CRC/DTM_SIMU_VDELTA.sas'; 9 %LET _SASPROGRAMFILEHOST='isasakj4.compagny.fr'; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///D:/appli/SAS/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 set TABLE nobs=NOBS point=NOBS; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 27 28 29 GOPTIONS NOACCESSIBLE; 30 %LET _CLIENTTASKLABEL=; 31 %LET _CLIENTPROCESSFLOWNAME=; 32 %LET _CLIENTPROJECTPATH=; 33 %LET _CLIENTPROJECTPATHHOST=; 34 %LET _CLIENTPROJECTNAME=; 35 %LET _SASPROGRAMFILE=; 36 %LET _SASPROGRAMFILEHOST=; 37 38 ;*';*";*/;quit;run; 39 ODS _ALL_ CLOSE; 40 41 42 QUIT; RUN; 43 Hello Kurt I put the whole log thanks ... View more

Hello Chris I tried this code your suggested --> set TABLE nobs=NOBS point=NOBS; but I encounter an error "Statement is not valid or it is used out of proper order." I try this as wel (to get the last of the "class" table ) -->set sashelp.class nobs=NOBS point=NOBS; same error ... View more

I think I understood, you advice me to get only last record by using this (for example) data last; /* get number of records (N) */ if 0 then set sashelp.class nobs=nobs end=eof; /* use POINT= to get nth record */ set sashelp.class point=nobs; output; stop; run; ... View more

Thanks Chris for your help. yes, by checking the date, if I have to re launch the program (in the day) , I Always extract only the new data. the new data should be inserted only once in the target even if the program is launch twice or more. Also, I am sorru but i don't understand this "set TABLE nobs=NOBS point=NOBS;" ... View more

hello,   sorry for my question, I found this data want(drop = c); set have; by name ; if first.name then c=0 ; if i_jour_sem ne i_sem then flag = .; else do; flag = sum(c, 1); c = sum(c, 1); end;     if c = 3 then c = 0; retain c; run;   ... View more

Hello Peter, how to do that with many names ? look at "have2" dataset. the flag should start with 1 when a new group name starts. many thanks Data have2 ; infile datalines ; input name $ week i_jour_sem i_sem ; datalines ; Andrew 39 1 1 Andrew 39 2 1 Andrew 39 3 1 Andrew 39 4 1 Andrew 39 5 1 Andrew 40 1 2 Andrew 40 2 2 Andrew 40 3 2 Andrew 40 4 2 Andrew 40 5 2 Andrew 41 1 3 Andrew 41 2 3 Andrew 41 3 3 Andrew 41 4 3 Andrew 41 5 3 Andrew 42 1 4 Andrew 42 2 4 Andrew 42 3 4 Andrew 42 4 4 Andrew 42 5 4 Andrew 43 1 5 Andrew 43 2 5 Andrew 43 3 5 Andrew 43 4 5 Andrew 43 5 5 Andrew 44 1 6 Andrew 44 2 6 Andrew 44 3 6 Andrew 44 4 6 Andrew 44 5 6 Dalila 39 1 1 Dalila 39 2 1 Dalila 39 3 1 Dalila 39 4 1 Dalila 39 5 1 Dalila 40 1 2 Dalila 40 2 2 Dalila 40 3 2 Dalila 40 4 2 Dalila 40 5 2 Dalila 41 1 3 Dalila 41 2 3 Dalila 41 3 3 Dalila 41 4 3 Dalila 41 5 3 Dalila 42 1 4 Dalila 42 2 4 Dalila 42 3 4 Dalila 42 4 4 Dalila 42 5 4 Dalila 43 1 5 Dalila 43 2 5 Dalila 43 3 5 Dalila 43 4 5 Dalila 43 5 5 Dalila 44 1 6 Dalila 44 2 6 Dalila 44 3 6 Dalila 44 4 6 ; run ;   ... View more

yes. ... View more

hello kawakami it works very well thanks a lot ... View more

Hello kawakami many thanks for your respons il works well I just notice that when I have several employees (there, robert and Alice).then I get many rows with weekday if I could get only one it could be great ! thanks Data have ; input ladate result employee $ ; day_name = trim(left(put(ladate, downame.))); informat ladate ddmmyy10. ; format ladate ddmmyy10. ; datalines ; 03/09/2021 1 robert 04/09/2021 5 robert 05/09/2021 8 robert 06/09/2021 9 robert 07/09/2021 23 robert 08/09/2021 56 robert 09/09/2021 15 robert 10/09/2021 48 robert 11/09/2021 99 robert 12/09/2021 23 robert 13/09/2021 45 robert 14/09/2021 48 robert 15/09/2021 1 robert 16/09/2021 5 robert 17/09/2021 8 robert 18/09/2021 9 robert 19/09/2021 23 robert 20/09/2021 56 robert 21/09/2021 15 robert 22/09/2021 48 robert 23/09/2021 99 robert 24/09/2021 23 robert 25/09/2021 45 robert 26/09/2021 48 robert 27/09/2021 11 robert 28/09/2021 12 robert 29/09/2021 13 robert 30/09/2021 16 robert 03/09/2021 1 alice 04/09/2021 5 alice 05/09/2021 8 alice 06/09/2021 9 alice 07/09/2021 23 alice 08/09/2021 56 alice 09/09/2021 15 alice 10/09/2021 48 alice 11/09/2021 99 alice 12/09/2021 23 alice 13/09/2021 45 alice 14/09/2021 48 alice 15/09/2021 1 alice 16/09/2021 5 alice 17/09/2021 8 alice 18/09/2021 9 alice 19/09/2021 23 alice 20/09/2021 56 alice 21/09/2021 15 alice 22/09/2021 48 alice 23/09/2021 99 alice 24/09/2021 23 alice 25/09/2021 45 alice 26/09/2021 48 alice 27/09/2021 11 alice 28/09/2021 12 alice 29/09/2021 13 alice 30/09/2021 16 alice ; run ; ... View more