Hi Domenico:

As you running no. of loops within your macro and essentially the log gets bigger, I would suggest using the following SAS code at the very inception of your SAS macro.

PROC PRINTTO LOG='your external file path'; RUN;

The PROC PRINTTO routes the messages of log file to an external file so that I believe it won't ask you further for deleting the log file when it exceeds the log file size as your all log messages are redirected to a new external file (may be a .doc file). Alternately, at the end of every execution of your loop you can run which will clean your log file.

dm 'clear log';

Hope it works.

Kind regards, Tanvir

***************************************** Tanvir Quadir Ph.D. Student (Statistics) Department of Mathematics and Statistics University of Windsor E-mail: quadirt@uwindsor.ca tanvir_quadir@yahoo.com tanvir.quadir@gmail.com *******************************************

----- Original Message ---- From: domenico <stataDat@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Sent: Tuesday, July 8, 2008 6:32:20 AM Subject: delete the log file when it is too long

I wrote a macro (% do %while + proc iml with 10,000 cycles) that works properly, but after a large number of cycles get a message asking me to delete or save the log because it is too long. Then I select the option "delete the log" and the macro continues to operate. I am not interested in the log because I am already sure that the macro works. How do I avoid this message? In practice I would not write the log file. I tried to run the macro closing the log file, but I get the message anyway.

Thanks to all newsgroups, I am a beginner but thanks your suggestions I was able to write a file sas in a few days :-)

domenico