BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phil_NZ
Barite | Level 11

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

My97_0-1612748636257.png

My97_1-1612748657351.png

 

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.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

 

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.htm...

 


@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

My97_0-1612748636257.png

My97_1-1612748657351.png

 

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.


 

View solution in original post

4 REPLIES 4
SASKiwi
PROC Star

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

Phil_NZ
Barite | Level 11

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;

My97_0-1612756234665.png

 

Many thanks.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Reeza
Super User

 

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.htm...

 


@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

My97_0-1612748636257.png

My97_1-1612748657351.png

 

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.


 

Phil_NZ
Barite | Level 11

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. 

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1567 views
  • 4 likes
  • 3 in conversation