topic Re: NOPRINT for PROC TABULATE in ODS and Base Reporting

NOPRINT for PROC TABULATE

Altal — Wed, 14 May 2014 20:16:56 GMT

I'm using PROC TABULATE to output a dataset and I don't want the TABULATE table to show in RTF or output i.e. I just want it to spit the dataset. Is there anyway to do that? looks like TABULATE has no NOPRINT equivalent

I'm using the code below and it doesn't serve the purpose...

ODS RTF file='PATH/.rtf'

ODS LISTING CLOSE;

proc tabulate data=DATA out=WANT;

class

tables Var , Var * (n pctn=''*f=pctfmt.) ;

run;

ODS LISTING;

ODS RTF CLSOE;

Thanks

Re: NOPRINT for PROC TABULATE

Cynthia_sas — Wed, 14 May 2014 20:24:27 GMT

Hi:

I don't know what you mean by "spit the dataset" -- you're going to need PROC PRINT for that -- there is no "spitting" to a destination without a procedure that creates output. I would suggest this instead. Move the TABULATE step outside of your ODS "sandwich" and then put your PROC PRINT "inside" the ODS statements.

Cynthia

ods listing;

** run tabulate and make the dataset work.want;

proc tabulate data=DATA out=WANT;

class

tables Var , Var * (n pctn=''*f=pctfmt.) ;

run;

ODS LISTING CLOSE;

ODS RTF file='PATH/.rtf'

proc print data=work.want;

run;

ODS RTF CLOSE;

Re: NOPRINT for PROC TABULATE

Reeza — Wed, 14 May 2014 20:27:06 GMT

Use the ODS Select statement

ods select none;

proc tabulate data=sashelp.class out=want;

class sex age;

tables sex age, n;

run;

ods select all;

Re: NOPRINT for PROC TABULATE

jakarman — Thu, 15 May 2014 05:39:21 GMT

With some languages "spit" (spitten nl) should be translated to dig (en), more advanced that is "data mining".

Re: NOPRINT for PROC TABULATE

Altal — Thu, 15 May 2014 11:57:13 GMT

Sorry for the language, I meant for the proc tabulate to output the dataset I wanted without printing it in the rtf output. Cynthia, thanks for your suggestion; but I couldn't take the tabulate proc outside the ODS since it's inside a macro. I implemented Reeza's code and it works. Thank you all.

Re: NOPRINT for PROC TABULATE

Cynthia_sas — Thu, 15 May 2014 15:15:20 GMT

Hi:

You must be using some other code to get the dataset to appear in the RTF file. When I implement Reeza's code in this sample program, my RTF file is empty. See screen shot.

Cynthia

ods _all_ close;
ods rtf file='c:\temp\what_report.rtf';
ods select none;

    proc tabulate data=sashelp.class out=want;
      class sex age;
      tables sex age, n;
    run;

ods select all;
ods rtf close;

Re: NOPRINT for PROC TABULATE

Altal — Thu, 15 May 2014 15:22:15 GMT

That's exactly what I wanted (for proc tabulate to do the tabulation, give me the dataset in the OUT= and not to print anything in the RTF; then I'm using the dataset for other calculation). I appreciate the response.

Re: NOPRINT for PROC TABULATE

GiridharGoutham — Tue, 02 Sep 2014 05:33:22 GMT

Hello All,

Thank You very much for helping me through this type of output .

I have been working on text pad and as I use this tabulate I would get all the unwanted stuff .Any ways it was very much helpful.

Thanks a Lot.

Giridhar Goutham Y