Do you prefer Proc Report or Proc Tabulate? Why?
- 9 Answers
- 28582 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nishant
I depends on the situation where we use it.
I use proc tabulate when we need to produce matrix-style
reports which is preferred. with proc report we can produce
columnar-style report.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sireesha
Proc report is very flexible to create tables than proc
tabulate as it
----supports built-in formats
-----it has both the features of displaying output on
report template and creating datasets.....
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / mallikarjuna reddy
by using proc tabulate, we can get only cross tabular
reports, where as proc report generates summary reports,
listing reports besides generating cross tabular reports.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / chiranjeevi.p
Proc tabulate is reffered as the 'semi statistical
procedure',which is used to generate the tabular reports.
proc report:
proc report is a pre defined procedure using which we can
generate a reports.Using the proc report,two kinds of
reports can be generated.there are
1)Detailed report
2)Summary report
Summary report is the report,which can hold more than one
observation in it.it is referred as S.report.
Detailed report is the report which can hold only a single
observation in it explained in detail.
so we can prefer the proc report instead of proc tabulate.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rajeev
i will prefer only repoer procedure because we can create
anew variables and some calculations using compute option.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satheesh
using proc report we can create a new variable using
compute block .but in the case of tabulate we didnt create..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / solasa
proc tabulate when we need to produce matrix-style
reports which is preferred.
with proc report we can produce
columnar-style report.
U cant get inferential stats like p-value using PROC TABULATE
and more over the report finally what u get is aligned
in multiple pages which is not desired.
and the headings are not aligned correctly.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / balanarasimhudu
By using TABULATE procedure, we can get quick descriptive statistics on data, but it does not meet the typical needs of generating clinical trial tables, some reasons.
 It does not provide p-values beyond a simple t-test.
 It does not present “n (%)” in a desired format.
 Variable labels are not clearly differentiated from the summary statistics labels.
 “Page X of N” pagination is not available.
 Missing values are handled in an “all or nothing” way, so if you exclude missing
values for one variable, you end up excluding all data for that record for the other
variables in the summary.
 It does not place population counts in the column heading.
The REPORT procedure was designed as a flexible report writing tool that combines features of the PRINT, MEANS, and TABULATE procedures along with “PUT” capabilities commonly used in the DATA step. so, I prefer to use proc report until I have cross tabulation tables, because, it gives me so many options to modify the look up of my table,(Ex: width option, by this we can change the width of each column in table like this so many options, statements we can use in proc report).
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sas - user
Proc Report and Proc Tabulate procedures are very useful
for generating reports. Proc Report is preferable in using
listing type reports and Proc Tabulate is preferable in
genrating Tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
Of all your work, where have you been the most successful?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
What is a put statement?
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
how to remove duplicates using proc sql?
what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?
What is PDV?
what is the difference between nodup and nodupkey options? : Sas programming
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
Mention common programming errors committed in sas ?
Explain proc sort?
Teradata 
