topic Re: How not to print result but only output in proc univariate in SAS Programming

How not to print result but only output in proc univariate

Phil_NZ — Mon, 08 Feb 2021 01:46:46 GMT

Hi SAS Users,

Today when I run the proc univariate and using Output delivery system to get the Quantiles dataset, I receive both the results from Proc Univariate and the output of Quantiles.

In particular, my code is as below

ods output Quantiles=outlier;
proc univariate data=sashelp.shoes;
var sales Inventory;
run;

By running this code, I have one result and one output

I am wondering what I should do to not show the result but show only the output data?

I have tried no print option and ods exclude all; but they all not work the way I want.

Many thanks and warm regards.

Re: How not to print result but only output in proc univariate

SASKiwi — Mon, 08 Feb 2021 03:40:49 GMT

I think you need to use an ODS SELECT statement, something like: ODS select quantiles;

Re: How not to print result but only output in proc univariate

Phil_NZ — Mon, 08 Feb 2021 03:50:44 GMT

Hi @SASKiwi

Thank you for your suggestion, but when running this code, I only get results but not output, while what I need is output but not result.

ods select Quantiles;
proc univariate data=sashelp.shoes;
var sales Inventory;
run;

Many thanks.

Re: How not to print result but only output in proc univariate

Reeza — Mon, 08 Feb 2021 04:18:45 GMT

ODS SELECT NONE;
<insert your sas code>;
ODS SELECT ALL;

Use either ODS SELECT or EXCLUDE to conditionally display output.

ALL/NONE are keywords as well, to select all tables or none.

https://blogs.sas.com/content/iml/2018/11/19/select-ods-tables-wildcards-regular-expressions-sas.html

@Phil_NZ wrote:

Hi SAS Users,

Today when I run the proc univariate and using Output delivery system to get the Quantiles dataset, I receive both the results from Proc Univariate and the output of Quantiles.

In particular, my code is as below
ods output Quantiles=outlier;
proc univariate data=sashelp.shoes;
var sales Inventory;
run;
By running this code, I have one result and one output

I am wondering what I should do to not show the result but show only the output data?

I have tried no print option and ods exclude all; but they all not work the way I want.

Many thanks and warm regards.

Re: How not to print result but only output in proc univariate

Phil_NZ — Mon, 08 Feb 2021 04:31:02 GMT

Hi @Reeza

Thank you very much, I found the code to deal with my need from your suggestion

ods select None;
proc univariate data=sashelp.shoes ;
var sales Inventory;
ods output Quantiles=outlier;
run;
ods select all;

Many thanks and warm regards.