Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3)

fieldsa83 — Mon, 19 Jun 2017 20:13:53 GMT

Can you save the results output to a libname or something?

Re: Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3)

Tom — Mon, 19 Jun 2017 20:25:07 GMT

Can you explain what you mean? Anything run via EG is actually run using Base SAS.

Re: Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3)

ballardw — Mon, 19 Jun 2017 20:28:06 GMT

You can send the output to a data set using the OUT= option on the Proc Statement.

Proc tabulate data=sashelp.class out=mylib.tabulateoutput;

class sex age;

var height weight;

table sex*age all,

(height weight)*(mean max min);

run;

HOWEVER the data does not look like what you may expect. The output data set has a number of variables that just tell where the resulting statitistic values appear because of the option in tabulate that allow nesting row and column values, creating multiple tables from a single procedure call and the "All" row/column options.

You might try dumping a small proc tabulate output to a set and then examime it closely to see if it will do what you want.

If you have never figured out the _type_ variable in proc summary or proc means output this may not be the approach for you.

I do use Proc tabulate to create data sets that I manipulate a bit to display latter with more control than a single Tabulate call allows but it is not a trivial operation.

topic Re: Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3) in SAS Programming

Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3)

Re: Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3)

Re: Is there a way to run proc tabulate on base SAS but view the results in EG? (SAS 9.3)