topic Re: Displaying a summarized SAS data table? in ODS and Base Reporting

Displaying a summarized SAS data table?

dunga — Wed, 23 Aug 2017 15:56:38 GMT

/*Hi Forum,

I have this dataset.

data have;

input product income;

cards;

1 1000 15000

1 5000 25000

2 590 1000

3 777 500

3 777 800

3 243 987

;

run;

/*And I summarized it using proc sql code below.*/

proc sql;

create table smry as

select product

,count(*) as acct_ct

,sum(income) as spot_income format = dollar20.

from have

group by 1;

quit;

/*SQL generates the below small SAS data resutls table. I have over 80 such summarized tables. I do not want to export them to Excel

and present.*/

product	acct_ct	spot_income
1	2	$6,000
2	1	$590
3	3	$1,797

/*Q: Is there any method to display the above SAS data resutls table just like proc tablulate, proc freq etc. display. Any help is appreciated. Proc tabulate alternative would not be the answer, I want to display the SAS tables

Re: Displaying a summarized SAS data table?

Reeza — Wed, 23 Aug 2017 15:59:03 GMT

It's really unclear what you're asking here. You don't want to export them to Excel? You want a proc to display the results like tabulate/freq? What about PROC PRINT or REPORT?

Re: Displaying a summarized SAS data table?

RW9 — Wed, 23 Aug 2017 16:00:27 GMT

Sorry, not understanding what the quesiton is? If you don't want output files (e.g. Excel) then you would view datasets by opening them in the datasets view?

Re: Displaying a summarized SAS data table?

ballardw — Wed, 23 Aug 2017 16:44:40 GMT

If you don't use a create table statement in that code the results of the select go directly to the open ODS destination.

By default that would be the SAS results viewer but an ODS destination could write to an RTF or PDF or other file type as desired.