SAS Programming

DATA Step, Macro, Functions and more
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-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

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
  • 2205 views
  • 4 likes
  • 3 in conversation