Thank you for the solution. It has been a great help and great learning experience ... View more

Please post the log ... View more

@Patrick, Thanks for you answer, the "order = varnum" in the proc contents doesn't work for me, it doesn't sort the table !   But the second program you made is perfect ! Thanks 🙂   I don't have the reflex to go through metadatas ! ... View more

@FreelanceReinh wrote: Hello @Onizuka,   An alternative approach uses a "non-executable" SET statement in conjunction with selected KEEP= dataset options (where you can use variable lists): data want; retain d; if 0 then set have(keep=b:) have(keep=a:); set have; run;   Hello @FreelanceReinh , thank you for your answer, I will try your solution too, thanks again ! 🙂 ... View more

Dear Erik,   quick question please, given the data i am using now, do you have any guide on how to conduct or what is the best apprach to use for a good descriptive analysis? i am aware of the Proc Freq, means etc.. is there anything to follow to make sure that i have tackeled most or all the nedded analysis on my data.   Many Thanks   Sof ... View more

Thank you very much @ChrisNZ  !! 😄 😄 Why make it complicated when it can be easy ! haha ... View more

Hello all,   Thank you a lot for all you responses, I think that the solution of @Tom is working perfectly and so as the solution of @Kurt_Bremser !   I don't know why I didn't think about doing a simple merge... !   I tried to do something similar, I did not think for a single second to the instruction "output" ... View more

You're right, what I wanted to do is nonsense, so I removed the "BIG_ONE" and added a code which directly run all the macros like :   %Macro RUN_GESTION_RECUL (typequest =) ; %local i ; %do i = 1 %to %sysfunc(countw(&typequest)); %let nextvar = %scan(&typequest,&i.); %comptage_niveau ; %calcul_periode ; %traitement_recul ; %ajout_niveau_base ; %end ; %Mend RUN_GESTION_RECUL ; Thanks for your answer 🙂 ... View more

Thanks Patrick! You help me a lot! ... View more

@ballardw wrote: DDE is fragile, not being recommended by Microsoft and the communication approach it uses can be conflicted by other programs such that DDE will not work.   So if your approach quits working it is likely to be something external to SAS that changes in your environment. I found this out when my shop installed Cisco Jabber.   You may also have issues with Office 365 as the Microsoft Office no longer has an "Excel.exe", at least not one that I can find. Hello, thank you for your answer, I appreciate it 🙂   For information, i am in an internship until august. I will provide to the company the code with the DDE but telling that it can have some problems. The problem is that the excel file have differents sheets and we don't have the possibility to import "XLS" or "XLSX" or "EXCEL" files on SAS (unless we convert it in CSV but to long because lot of sheets..)   Edit : sorry for my bad english haha ... View more

This is working if your datasets have the same name but just a number who is changing 🙂 ... View more