Do you prefer Proc Report or Proc Tabulate? Why?
- 9 Answers
- 29646 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 |
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Differentiate between format and informat? : sas-grid-administration
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?
36 Answers Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,
When you will use nowd option in report???
for whom is sas data integration studio designed? : Sas-di
what can you learn from the sas log when debugging? : Sas programming
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
Name validation tools used in SAS
How do you download a flat file from Mainframe to your local PC using SAS?
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
What is maximum storage capability of SAS?
Teradata 
