topic Re: ODS function in New SAS User

Excluding ODS output

lioradam — Thu, 25 Sep 2025 15:37:50 GMT

Hello,

In the following code, I would like to present only the result for "FM_quadric_reg_adj_ebxi3_Winz" results. but I have not succeed to do that with ODS statement.

Thank you,

Lior

proc sort data=FINAL out=FM_quadric_reg_adj_ebxi_a;
by GVKEY01 Full_Name;

run;

PROC REG DATA=FM_quadric_reg_adj_ebxi_a
outest=FM_quadric_reg_adj_ebxi3 noprint outseb;

MODEL Adj_m1_e_bxi_a=Year_of_Tenure year_of_tenure2;
by GVKEY01 Full_Name;

RUN;
QUIT;



proc sql;
create table FM_quadric_reg_adj_ebxi3_PARMS as
select *
from FM_quadric_reg_adj_ebxi3
where _type_ = "PARMS";


data FM_quadric_reg_adj_ebxi3_PARMS2;
set FM_quadric_reg_adj_ebxi3_PARMS;
drop _type_;

run;

proc summary data=FM_quadric_reg_adj_ebxi3_PARMS2;

var intercept Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi3_summ p5= p95= / autoname;

quit;


data FM_quadric_reg_adj_ebxi3_Winz;

set FM_quadric_reg_adj_ebxi3_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi3_summ;


intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);



run;
proc means data=FM_quadric_reg_adj_ebxi3_Winz n mean t probt stderr;

run;

Re: ODS function

Kathryn_SAS — Tue, 23 Sep 2025 10:32:56 GMT

Do you mean that you only want the PROC MEANS results to appear in the output destination? If so, try the following:

ods _all_ close;

proc sort data=FINAL out=FM_quadric_reg_adj_ebxi_a;
by GVKEY01 Full_Name;

run;

PROC REG DATA=FM_quadric_reg_adj_ebxi_a
outest=FM_quadric_reg_adj_ebxi3 noprint outseb;

MODEL Adj_m1_e_bxi_a=Year_of_Tenure year_of_tenure2;
by GVKEY01 Full_Name;

RUN;
QUIT;



proc sql;
create table FM_quadric_reg_adj_ebxi3_PARMS as
select *
from FM_quadric_reg_adj_ebxi3
where _type_ = "PARMS";


data FM_quadric_reg_adj_ebxi3_PARMS2;
set FM_quadric_reg_adj_ebxi3_PARMS;
drop _type_;

run;

proc summary data=FM_quadric_reg_adj_ebxi3_PARMS2;

var intercept Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi3_summ p5= p95= / autoname;

quit;


data FM_quadric_reg_adj_ebxi3_Winz;

set FM_quadric_reg_adj_ebxi3_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi3_summ;


intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);



run;

ods listing;
proc means data=FM_quadric_reg_adj_ebxi3_Winz n mean t probt stderr;

run;

If this does not answer your question, please clarify what you are currently getting and what you are expecting.

Re: ODS function

lioradam — Tue, 23 Sep 2025 11:14:16 GMT

Hi,

Thank you very much.

When I run the program with the single code (the code attached here), it works.

However, in my original program, there are several codes in the same program file, and in that case, it doesn't work.

(even so I enter "ods listing;" in each code).

Lior

Re: ODS function

Kathryn_SAS — Tue, 23 Sep 2025 11:44:49 GMT

The code you included in the original post works for me also when I create sample data. What do you mean by "it doesn't work"? Are you getting Error messages or are you getting more output than you want in the ODS destination? Can you send code that replicates what you are describing? Other ways to prevent ODS output are to use ODS SELECT NONE; or ODS EXCLUDE ALL; and then ODS SELECT ALL; when you want to resume showing output.

Re: ODS function

lioradam — Tue, 23 Sep 2025 12:29:58 GMT

Hi,

I receive more output than I want.

Here are the four different codes for regressions, which are included in the program:




proc sort data=FINAL out=FM_quadric_reg_adj_ebxi_a;
 by GVKEY01 Full_Name;


run;


PROC REG DATA=FM_quadric_reg_adj_ebxi_a
  outest=FM_quadric_reg_adj_ebxi3 noprint outseb;


MODEL Adj_m1_e_bxi_a /*EM tobin_q */= /*ln_year_of_tenure*/ Year_of_Tenure year_of_tenure2;
   by GVKEY01 Full_Name;

RUN;
QUIT;
proc sql;
create table  FM_quadric_reg_adj_ebxi3_PARMS as 
select *
from FM_quadric_reg_adj_ebxi3
where _type_ = "PARMS";


data FM_quadric_reg_adj_ebxi3_PARMS2;
set FM_quadric_reg_adj_ebxi3_PARMS;
drop _type_;

run;

proc summary data=FM_quadric_reg_adj_ebxi3_PARMS2;
 
var intercept /*ln_year_of_tenure */Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi3_summ p5= p95= / autoname;
  
quit;


data FM_quadric_reg_adj_ebxi3_Winz;

set FM_quadric_reg_adj_ebxi3_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi3_summ; 

 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);


run;
ods listing;
proc means data=FM_quadric_reg_adj_ebxi3_Winz n mean t probt stderr;

run;


PROC REG DATA=FM_quadric_reg_adj_ebxi_a
  outest=FM_quadric_reg_adj_ebxi2 noprint outseb;
 
MODEL Adj_m1_e_bxi_a /*EM tobin_q*/ = Year_of_Tenure year_of_tenure2;
   by GVKEY01 Full_Name;
 
    
RUN;
QUIT;
proc sql;
create table  FM_quadric_reg_adj_ebxi2_PARMS as 
select *
from FM_quadric_reg_adj_ebxi2
where _type_ = "PARMS";


data FM_quadric_reg_adj_ebxi2_PARMS2;
set FM_quadric_reg_adj_ebxi2_PARMS;
drop _type_;

run;

proc summary data=FM_quadric_reg_adj_ebxi2_PARMS2;
 
var intercept Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi2_summ p5= p95= / autoname;
  
quit;


data FM_quadric_reg_adj_ebxi2_Winz;

set FM_quadric_reg_adj_ebxi2_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi2_summ; 

 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);


run;
ods listing;
proc means data=FM_quadric_reg_adj_ebxi2_Winz n mean t probt stderr;

run;



proc sort data=FINAL out= cl_adj_ebxi1_a_fm;
by GVKEY01 Full_Name 'Data Year - Fiscal'n ;
RUN;

PROC REG data=cl_adj_ebxi1_a_fm
	outest=cl_adj_ebxi1_a  noprint outseb;

model Adj_m1_e_bxi_a /*EM/* tobin_q */= year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;

 by GVKEY01 Full_Name;

run;
quit;


proc sql;
create table  cl_adj_ebxi1_a_PARMS as 
select *
from cl_adj_ebxi1_a
where _type_ = "PARMS";


data cl_adj_ebxi1_a_PARMS2;
set cl_adj_ebxi1_a_PARMS;
drop _type_;

run;

proc summary data=cl_adj_ebxi1_a_PARMS2;
 
var intercept year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;
output out=cl_adj_ebxi1_a_summ p5= p95= / autoname;
  
quit;


data cl_adj_ebxi1_a_Winz;

set cl_adj_ebxi1_a_PARMS2;
if _n_ = 1 then set
cl_adj_ebxi1_a_summ; 

 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
DM_ebxi_X_winz = min(max(DM_ebxi_X, DM_ebxi_X_p5), DM_ebxi_X_p95);
DM_adj_ebxi_a_winz = min(max(DM_adj_ebxi_a, DM_adj_ebxi_a_p5), DM_adj_ebxi_a_p95);


run;
ods listing;
proc means data=cl_adj_ebxi1_a_Winz n mean t probt;
 
run;

proc sort data=FINAL out= cl_adj_ebxi2_a_fm;
by GVKEY01 Full_Name 'Data Year - Fiscal'n ;

PROC REG data=cl_adj_ebxi2_a_fm
	outest=cl_adj_ebxi2_a  noprint outseb;

model Adj_m1_e_bxi_a /*EM /*tobin_q*/=year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;

 by GVKEY01 Full_Name;

run;
quit;


proc sql;
create table  cl_adj_ebxi2_a_PARMS as 
select *
from cl_adj_ebxi2_a
where _type_ = "PARMS";


data cl_adj_ebxi2_a_PARMS2;
set cl_adj_ebxi2_a_PARMS;
drop _type_;

run;

proc summary data=cl_adj_ebxi2_a_PARMS2;
 
var intercept year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;
output out=cl_adj_ebxi2_a_summ p5= p95= / autoname;

quit;


data cl_adj_ebxi2_a_Winz;

set cl_adj_ebxi2_a_PARMS2;
if _n_ = 1 then set
cl_adj_ebxi2_a_summ; 

 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
DM_ebxi_X_winz = min(max(DM_ebxi_X, DM_ebxi_X_p5), DM_ebxi_X_p95);
DM_adj_ebxi_a_winz = min(max(DM_adj_ebxi_a, DM_adj_ebxi_a_p5), DM_adj_ebxi_a_p95);



ods listing;
proc means data=cl_adj_ebxi2_a_Winz n mean t probt;
 
run;

Re: ODS function

Quentin — Tue, 23 Sep 2025 12:41:18 GMT

In your code, you never close the listing destination. If you only want the PROC MEANS results to print to the listing, you need to close the listing destination before your first PROC REG, then before each PROC MEANS step open the listing destination, and after the PROC MEANS step close the listing destination. You could do that like:

ods _all_ close;

proc sort data=FINAL out=FM_quadric_reg_adj_ebxi_a;
 by GVKEY01 Full_Name;
run;


PROC REG DATA=FM_quadric_reg_adj_ebxi_a
  outest=FM_quadric_reg_adj_ebxi3 noprint outseb;


MODEL Adj_m1_e_bxi_a /*EM tobin_q */= /*ln_year_of_tenure*/ Year_of_Tenure year_of_tenure2;
   by GVKEY01 Full_Name;
RUN;
QUIT;
proc sql;
create table  FM_quadric_reg_adj_ebxi3_PARMS as 
select *
from FM_quadric_reg_adj_ebxi3
where _type_ = "PARMS";


data FM_quadric_reg_adj_ebxi3_PARMS2;
set FM_quadric_reg_adj_ebxi3_PARMS;
drop _type_;
run;

proc summary data=FM_quadric_reg_adj_ebxi3_PARMS2;
var intercept /*ln_year_of_tenure */Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi3_summ p5= p95= / autoname;
quit;


data FM_quadric_reg_adj_ebxi3_Winz;

set FM_quadric_reg_adj_ebxi3_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi3_summ; 

 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);


run;

ods listing;
proc means data=FM_quadric_reg_adj_ebxi3_Winz n mean t probt stderr;
run;
ods listing close;

PROC REG DATA=FM_quadric_reg_adj_ebxi_a
  outest=FM_quadric_reg_adj_ebxi2 noprint outseb;
 
MODEL Adj_m1_e_bxi_a /*EM tobin_q*/ = Year_of_Tenure year_of_tenure2;
   by GVKEY01 Full_Name;  
RUN;
QUIT;
proc sql;
create table  FM_quadric_reg_adj_ebxi2_PARMS as 
select *
from FM_quadric_reg_adj_ebxi2
where _type_ = "PARMS";


data FM_quadric_reg_adj_ebxi2_PARMS2;
set FM_quadric_reg_adj_ebxi2_PARMS;
drop _type_;
run;

proc summary data=FM_quadric_reg_adj_ebxi2_PARMS2;
var intercept Year_of_Tenure year_of_tenure2;
output out=FM_quadric_reg_adj_ebxi2_summ p5= p95= / autoname;
quit;


data FM_quadric_reg_adj_ebxi2_Winz;
set FM_quadric_reg_adj_ebxi2_PARMS2;
if _n_ = 1 then set
FM_quadric_reg_adj_ebxi2_summ; 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
year_of_tenure2_winz = min(max(year_of_tenure2, year_of_tenure2_p5), year_of_tenure2_p95);
run;

ods listing;
proc means data=FM_quadric_reg_adj_ebxi2_Winz n mean t probt stderr;
run;
ods listing close;


proc sort data=FINAL out= cl_adj_ebxi1_a_fm;
by GVKEY01 Full_Name 'Data Year - Fiscal'n ;
RUN;

PROC REG data=cl_adj_ebxi1_a_fm
	outest=cl_adj_ebxi1_a  noprint outseb;
model Adj_m1_e_bxi_a /*EM/* tobin_q */= year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;
 by GVKEY01 Full_Name;
run;
quit;


proc sql;
create table  cl_adj_ebxi1_a_PARMS as 
select *
from cl_adj_ebxi1_a
where _type_ = "PARMS";


data cl_adj_ebxi1_a_PARMS2;
set cl_adj_ebxi1_a_PARMS;
drop _type_;
run;

proc summary data=cl_adj_ebxi1_a_PARMS2;
var intercept year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;
output out=cl_adj_ebxi1_a_summ p5= p95= / autoname;
quit;


data cl_adj_ebxi1_a_Winz;

set cl_adj_ebxi1_a_PARMS2;
if _n_ = 1 then set
cl_adj_ebxi1_a_summ; 

 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
DM_ebxi_X_winz = min(max(DM_ebxi_X, DM_ebxi_X_p5), DM_ebxi_X_p95);
DM_adj_ebxi_a_winz = min(max(DM_adj_ebxi_a, DM_adj_ebxi_a_p5), DM_adj_ebxi_a_p95);
run;

ods listing;
proc means data=cl_adj_ebxi1_a_Winz n mean t probt;
run;
ods listing close;

proc sort data=FINAL out= cl_adj_ebxi2_a_fm;
by GVKEY01 Full_Name 'Data Year - Fiscal'n ;

PROC REG data=cl_adj_ebxi2_a_fm
	outest=cl_adj_ebxi2_a  noprint outseb;
model Adj_m1_e_bxi_a /*EM /*tobin_q*/=year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;
 by GVKEY01 Full_Name;
un;
quit;


proc sql;
create table  cl_adj_ebxi2_a_PARMS as 
select *
from cl_adj_ebxi2_a
where _type_ = "PARMS";


data cl_adj_ebxi2_a_PARMS2;
set cl_adj_ebxi2_a_PARMS;
drop _type_;
run;

proc summary data=cl_adj_ebxi2_a_PARMS2;
var intercept year_of_tenure DM_ebxi_X  DM_adj_ebxi_a;
output out=cl_adj_ebxi2_a_summ p5= p95= / autoname;
quit;


data cl_adj_ebxi2_a_Winz;
set cl_adj_ebxi2_a_PARMS2;
if _n_ = 1 then set
cl_adj_ebxi2_a_summ; 
intercept_winz = min(max(intercept, intercept_p5), intercept_p95);
Year_of_Tenure_winz = min(max(Year_of_Tenure, Year_of_Tenure_p5), Year_of_Tenure_p95);
DM_ebxi_X_winz = min(max(DM_ebxi_X, DM_ebxi_X_p5), DM_ebxi_X_p95);
DM_adj_ebxi_a_winz = min(max(DM_adj_ebxi_a, DM_adj_ebxi_a_p5), DM_adj_ebxi_a_p95);



ods listing;
proc means data=cl_adj_ebxi2_a_Winz n mean t probt;
run;

Re: ODS function

lioradam — Tue, 23 Sep 2025 12:54:20 GMT

Hi,

Thank you, but it doesn't work.

I still receive too many results.

Lior

Re: ODS function

Quentin — Tue, 23 Sep 2025 13:11:13 GMT

If you clear your results, and then run that code, in addition to the PROC MEANS output, what other output do you see?

Re: ODS function

lioradam — Tue, 23 Sep 2025 13:17:07 GMT

I see:

FM_QUADRIC_REG_ADJ_EBXI_A

FM_QUADRIC_REG_ADJ_EBXI3

FM_QUADRIC_REG_ADJ_EBXI3_PARMS

FM_QUADRIC_REG_ADJ_EBXI3_PARMS2

FM_QUADRIC_REG_ADJ_EBXI3_SUMM

FM_QUADRIC_REG_ADJ_EBXI2

and many others

Re: ODS function

Quentin — Tue, 23 Sep 2025 13:25:45 GMT

Those are the names of datasets. You shouldn't see them in your results window. But if you're using Enterprise Guide, or another IDE, you may see icons for the output datasets that were created.

Are you using Enterprise Guide, Studio, or something else?

Can you post a screen shot of what you're seeing?

Re: ODS function

Quentin — Tue, 23 Sep 2025 13:34:56 GMT

I see in another thread that you mentioned Enterprise Guide and process flows.

Is your goal to stop these output datasets from being added as icons in your process flow?

If that's your goal, you can go to Tools->Options and then select Project and Process Flows and set the Maximum number of output datasets to add to the project to be 0.

Re: ODS function

lioradam — Tue, 23 Sep 2025 13:42:41 GMT

Yes, I use Enterprise Guide.

Those icons make my process flow look complicated.

Is there a way to avoid seeing them?

thank,

Lior

Re: ODS function

Quentin — Tue, 23 Sep 2025 13:45:30 GMT

Thanks for image. Yes, there is an option you can set that will stop those dataset icons from being added to your flow. See my second post:

https://communities.sas.com/t5/New-SAS-User/ODS-function/m-p/975570/highlight/true#M43510

Re: ODS function

lioradam — Tue, 23 Sep 2025 14:11:11 GMT

Thank you, but there are cases when I wank to see the icons to continue building the process flow from that database.

When I follow your instructions for signal regression, it works; I see only the results (icons) that I wanted to see.

But with several regressions, it doesn't work.

Here is an example of an icon of a result that I use to build another database:

Lior

Re: ODS function

Quentin — Tue, 23 Sep 2025 14:26:48 GMT

In my experience setting that option to 0 has always worked to prevent all output datasets from being added to the process flow. Maybe someone else will have an idea.

Re: ODS function

lioradam — Tue, 23 Sep 2025 14:45:17 GMT

Thank you very much for trying!

Highly appreciated.

Lior

Re: ODS function

Rick_SAS — Wed, 24 Sep 2025 18:21:17 GMT

I don't want to hijack this thread, but I'd like to encourage SAS Experts like @Kathryn_SAS and @Quentin to stop proposing
ODS _ALL_ CLOSE;
or
ODS LISTING CLOSE;
in their solutions.

The modern syntax for suppressing ODS results is
ODS EXCLUDE ALL;
followed by ODS EXCLUDE NONE or ODS SELECT <object> when you are ready to resume output.

For more details, see

Re: ODS function

lioradam — Thu, 25 Sep 2025 15:24:50 GMT

Hi Rick,

Could you please assist in locating this syntax?

I sent my complete program, which includes several regressions; each regression includes several codes.

Thank you,

Lior

Re: ODS function

Rick_SAS — Thu, 25 Sep 2025 15:37:03 GMT

I feel confident that you can use the best practices in the links to improve your program. Since I don't have your data, it is difficult for me (or anyone) to know whether our suggestions fix all of the problems you are experiencing. Give it a try and then report back if you have additional questions.

Re: ODS function

Quentin — Thu, 25 Sep 2025 16:07:30 GMT

@lioradam wrote:

Thank you, but there are cases when I wank to see the icons to continue building the process flow from that database.

When I follow your instructions for signal regression, it works; I see only the results (icons) that I wanted to see.

But with several regressions, it doesn't work.

Here is an example of an icon of a result that I use to build another database:

Lior

In that second picture, can you show the full process flow? It's not clear to me if those lines are pointing to output datasets (which should not happen if you have set the option I mentioned to 0), or if they are pointing to other artifacts.