another test in a better env seems to show better performances    NOTE: PROCEDURE SORT used (Total process time):       real time           3:56:21.17       user cpu time       1:13:29.12       system cpu time     19:33.06       memory              1059895.26k       OS Memory           1080224.00k       Timestamp           01/24/2022 01:56:51 PM       Step Count                        3  Switch Count  22047 ... View more

thanks for sharing, will have a look on it !) ... View more

The Set Statement read TableA sequentially, so the order from TableA will be intact in the output data set 🙂 ... View more

Many thanks , i was a little confused , this is exactly what i wanted ... ... View more

@bebess wrote:   rc = hhh.find(key:max(50,min(AGE,55)));   By the way, missing values of AGE in bigtable would be matched with observations from smalltable with AGE=55. I hope this is what you intended (or there are no obs. with missing AGE in bigtable). ... View more

/* sorry for my mistakes it works more easy with a data step but still understand why my macro program doesn't work , it seems the it is indefinitely runing .....*/   /* i have en error when i submit my code with my example where source and string contains quotation marks or special caracters   i have created the source and string macro variable with proc sql statment using into: separated by ' ' ( space ) */       %macro control_find_word(source,string,dlm);   　 %let k=1; %let ID_dim=%scan(&string. , &k ," "); %do %while (&ID_dim ne );   data _null_; result = indexw("&source","&string"," "); call symputx('result',result,'g');   run; %if &result=0 %then %do; %let control_dim=1; %put ERROR: WORD DOES NOT EXIST; %goto fin; %end; %let k=%eval(&k+1); %let ID_dim=%scan(&string. , &k ," "); %end;   %FIN : ; 　 %mend;   %control_find_word(&source,&string,);   ... View more

>i am not talking avout SAS names but the values of the variables   This was not obvious from your confusing answer:   for example i can have in the original table : All_buisness and in the ref table ALL_BUISNESS , so i need to apply either upcase/lowcase in the first but also in th second table ... View more

Yes thanks it could be another solution , but the merge involve a sort of the 2 table , more time consuming i think ? ... View more

for my need ( create a file which is going to be call in a PROC HTTP ( in parameter)  ) , i used the JSON procedure ( i have never used it before ... ) :   http://documentation.sas.com/?docsetId=proc&docsetTarget=n0s97o94nhawspn1rjhhsiu4nucz.htm&docsetVersion=9.4&locale=fr   thanks for your help. ... View more

data input; input start_date: ddmmyy10. end_date: ddmmyy10.; format start_date end_date ddmmyy10.; datalines; 15/06/2008 31/12/2009 ; run; data temp; set input; n+1; do date=start_date to end_date; month=month(date);output; end; format date ddmmyy10.; drop start_date end_date; run; proc sql; create table want as select n,month,min(date) as start format=date9.,max(date) as end format=date9. from temp group by n,month; quit; ... View more