report

[sasemp999]

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

[Ksharp]

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;

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

%mend v;

%v;

Ksharp

[shivas]

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