topic Re: report in SAS Procedures

report

sasemp999 — Thu, 03 May 2012 07:10:31 GMT

MY CODE:

ods tagsets.excelxp STYLE=minimal OPTIONS (Orientation = 'landscape' FitToPage = 'yes' sheet_name='Data - Trial 1') body="&path";
    proc report data = a nofs;
    column a b c d;
    define a / display flow 'aaa' STYLE=[CELLWIDTH=8cm];
run;
Ods tagsets.excelxp close; */

%macro v;
title;
data _null_;
file print;
put "******************************************************************************";
put "Output, Please go to this path &path";
put "******************************************************************************";
run;

%mend v;

%v;

OUTPUT:

i dont want to print output in output window.i want to display in output window as ---Output, Please go to this path &path";

But defaultly proc report outpuut is coming in output window

Re: report

Ksharp — Thu, 03 May 2012 07:41:52 GMT

What version of SAS you are using ?

U can close LISTING destination to suppress these output of report .and Open LISTING for the following footnote.

ods listing close;

.....................

...............

ods listing;

%mend v;

%v;

Ksharp

Re: report

shivas — Thu, 03 May 2012 09:58:44 GMT

Hi,

You can use this...

ods listing close;

proc print data=sashelp.class;run;

ods listing;

%macro v;

title;

data _null_;

file print;

put "******************************************************************************";

put "Output, Please go to this path &path ";

put "******************************************************************************";

run;

%mend v;

%v;

Thanks,

Shiva