topic Re: Include and log in SAS Procedures

Include and log

silasskovsbo — Mon, 25 Mar 2013 16:07:44 GMT

Hello all.. I have a problem.

I have several programs, 'program1', 'program2' etc, which shall be run in row. So first 'program1' and then 'program2' etc. I run my programs in batch mode and I have used the %include-statement to run program2 after program1.

My problem is that I want to save specific logs for each program.

How can I do that?

If the programs are for example:

Program 1:

data temp2;

set temp1;

run;

%include' program2'

Program 2:

data temp3;

set temp2;

run;

I have tried with proc printto and dm-statements but have no luck..

Hope you can help me

// Best, Silas Skovsbo, Aarhus University, Denmark

Re: Include and log

Quentin — Mon, 25 Mar 2013 17:08:24 GMT

Hi,

PROC PRINTTO should be able to do this for you. What problems did you have with that approach?

Something like:

proc printto log="d:\junk\logA.log" new;
run;

%include "d:\junk\A.sas"/source2;

proc printto log="d:\junk\logB.log" new;
run;

%include "d:\junk\B.sas"/source2;

proc printto;
run;

You need to have /source2 on the %include statement to have it write to the log. And need NEW on the proc printto otherwise it will keep appending.

HTH,

--Q.

Re: Include and log

ArtC — Mon, 25 Mar 2013 18:22:21 GMT

as suggested by @Quentin PRINTTO should do the trick. You could also submit the jobs individually using the OS scheduler. Other options include the use of the ALTLOG options and the use of DM statements to redirect the log.

Re: Include and log

silasskovsbo — Mon, 25 Mar 2013 20:06:38 GMT

Thank you for the fast response.

Using /source2 helped a bit. Now I get the full log. But I do get the full log in one textile, logA.

This does not print two separate log-files for program A and one for program B.

Do you know how to get that? And can you make an exact example of it? Just with the mentioned data-statements above?

Thanks again!

Re: Include and log

ArtC — Mon, 25 Mar 2013 21:58:25 GMT

Are you saying that the PROC PRINTTO did not work for you? Show us the PRINTTO steps.

Re: Include and log

Ron_MacroMaven — Thu, 28 Mar 2013 15:40:42 GMT

in the answers I have seen I do not see the close for the printto

%Macro SaveLog

(program

,path=d:\junk\);

PROC Printto log="&Path\&Program..log"

new;

run;

%include "&Path\&Program..sas"/source2;

PROC Printto;

run;

%mend SaveLog;

%SaveLog(A)

%SaveLog(B)

commentary:

personally I use

filename Project '.';

in my autoexec

and in programs:

%include Project(<program-name>);

can you guess I learned SAS on BigIron?

note that the extension is not needed, unless the prefix of the program name has digits

i.e.:

%include Project(01-inport-csv);

this has to be expanded and surrounded with quotes:

%include Project('01-inport-csv.sas');

Ron Fehd logs maven