topic Re: proc freq nlevels -prevent print in SAS Programming

proc freq nlevels -prevent print

Ronein — Wed, 08 Feb 2023 08:56:54 GMT

Hello

I want to create a data set called nlev_all that contain formation of number of missing observations.

The data set was created and it is 100% fine.

The problem is that I don't want to print it.

What is the way to prevent print of data set nlev_all?

ods output nlevels=work.nlev_all;
proc freq data=sashelp.shoes nlevels;
tables _all_ /noprint;
run;

Re: proc freq nlevels -prevent print

andreas_lds — Wed, 08 Feb 2023 10:12:54 GMT

Looking at the docs of proc freq, it seems an option exists preventing all printed output.

Re: proc freq nlevels -prevent print

Ronein — Wed, 08 Feb 2023 10:44:07 GMT

I looked and haven't seen the solution, this is the reason that I ask here

Re: proc freq nlevels -prevent print

PaigeMiller — Wed, 08 Feb 2023 10:52:06 GMT

If your print is going to HTML, try

ods html select none;

Re: proc freq nlevels -prevent print

Ronein — Wed, 08 Feb 2023 10:55:59 GMT

The print is going to "Results" window.
May you show the full code?
I am trying to apply your answer but get error

Re: proc freq nlevels -prevent print

andreas_lds — Wed, 08 Feb 2023 11:06:01 GMT

The following table is displayed on https://documentation.sas.com/doc/de/pgmsascdc/9.4_3.5/procstat/procstat_freq_syntax01.htm

Re: proc freq nlevels -prevent print

PaigeMiller — Wed, 08 Feb 2023 12:36:37 GMT

Is it not HTML in the results window? Have you opened some other destination for output?

@Ronein wrote:
I am trying to apply your answer but get error

You have been in the forum for many years now. You should know that when you get an error, you should show us _____________

Please show that to us. Don't make us ask, just do it every single time.

Re: proc freq nlevels -prevent print

ballardw — Wed, 08 Feb 2023 16:10:28 GMT

@Ronein wrote:

Hello

I want to create a data set called nlev_all that contain formation of number of missing observations.

The data set was created and it is 100% fine.

The problem is that I don't want to print it.

What is the way to prevent print of data set nlev_all?
ods output nlevels=work.nlev_all;
proc freq data=sashelp.shoes nlevels;
tables _all_ /noprint;
run;

I am afraid that anything that is suppressed in the ODS results will not populate a data set created with ODS OUTPUT. The ODS output uses only information sent to an ods destination. If you do not want something to appear in a report document then create the data set outside of the ODS sandwich that defines the start/end of the output document and then use the data set created as needed.

Dummy code example:

ods output nlevels=work.nlev_all;
proc freq data=sashelp.shoes nlevels;
tables _all_/noprint;
run;


ods rtf file='<path to report file>\reportdocumentname.rtf';

proc print work.nlev_all <print options>
run;

ods rtf close;

Re: proc freq nlevels -prevent print

Tom — Wed, 08 Feb 2023 16:15:38 GMT

You have to tell PROC FREQ to write something in order to ODS OUTPUT to have something to write to the dataset.

So you just need to suppress any other active ODS destinations from displaying the output also.

Use ODS SELECT statements.

ods select none;
ods output nlevels=nlevels;
proc freq data=sashelp.class nlevels;
tables _all_ / noprint;
run;
ods select all;
proc print data=nlevels;
run;

Re: proc freq nlevels -prevent print

Reeza — Wed, 08 Feb 2023 16:34:09 GMT

https://blogs.sas.com/content/iml/2015/05/26/suppress-ods.html

ods select none;
ods output nlevels=work.nlev_all;
proc freq data=sashelp.shoes nlevels;
tables _all_ /noprint;
run;
ods select all;

@Ronein wrote:

Hello

I want to create a data set called nlev_all that contain formation of number of missing observations.

The data set was created and it is 100% fine.

The problem is that I don't want to print it.

What is the way to prevent print of data set nlev_all?
ods output nlevels=work.nlev_all;
proc freq data=sashelp.shoes nlevels;
tables _all_ /noprint;
run;

Re: proc freq nlevels -prevent print

Ronein — Thu, 09 Feb 2023 05:18:56 GMT

This is not the answer since NOPRINT option prevent the print of the frequency table but don't prevent the print of NLEVELS table