topic Stopping proc tabulate or proc sql from dispayling output in ods pdf in ODS and Base Reporting

Stopping proc tabulate or proc sql from dispayling output in ods pdf

deleted_user — Wed, 02 Sep 2009 17:40:12 GMT

Hi

I'm trying to produce graphs that have axis which automatically re-scale depending on the data. In order to do that I need to calculate the min and max's of certain variables. However whenever I do that the output of the proc tabulate shows in the pdf.

Does anyone know how I can stop that?

The program is already using an awefull lot of macros and is quite complicated so I was hoping I wouldn't have to store these values in macros.

All suggestions are greatly appreciated.

Thanks,
Chris

Re: Stopping proc tabulate or proc sql from dispayling output in ods pdf

Tim_SAS — Wed, 02 Sep 2009 18:08:22 GMT

I think the ODS EXCLUDE statement is what you're looking for: http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/a002233281.htm.

Re: Stopping proc tabulate or proc sql from dispayling output in ods pdf

deleted_user — Thu, 03 Sep 2009 08:02:21 GMT

Hi Tim

Thanks for the reply, but I am still having trouble getting rid of the output.

My code basically reads like:

ods pdf file="";
ods pdf exclude SQL.SQL_Results (which i got using ods trace);

proc report ;

run;
quit;

proc sql;
select min(age)
into :age
from table
quit;

ods pdf close;

I don't want to display the SQL step which is only assigning macros. Am i putting the exclude statement in the wrong place?

Thanks again for your help.
Chris

Re: Stopping proc tabulate or proc sql from dispayling output in ods pdf

David_SAS — Thu, 03 Sep 2009 13:50:41 GMT

Chris,

Selection/exclusion lists reset at proc boundaries by default. Try putting the ODS PDF EXCLUDE statement immediately before the PROC SQL statement.

-- David Kelley, SAS

Re: Stopping proc tabulate or proc sql from dispayling output in ods pdf

data_null__ — Thu, 03 Sep 2009 13:55:16 GMT

Why not just use NOPRINT on the PROC SQL or RESET NOPRINT; statement?

Re: Stopping proc tabulate or proc sql from dispayling output in ods pdf

ballardw — Thu, 03 Sep 2009 22:13:11 GMT

It may be necessary to move any of the "support" steps to outside of the ods pdf area of the code. The intermediate data sets or macro variables will persist unless explicitly removed.

It may not make the program code quite as clear when the final displayed output is separated from the parts creating the data but it will correct the display issue.

Re: Stopping proc tabulate or proc sql from dispayling output in ods pdf

deleted_user — Fri, 04 Sep 2009 08:03:16 GMT

Hi everyone

I've managed to stop it from outputing. I basically wrapped the proc sql step in an exclude all statement.

Not as elegant as it could be but it worked so I can't complain.

Thanks for all your help.

Chris