Do you prefer Proc Report or Proc Tabulate? Why?
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 |
what are _numeric_ and _character_ and what do they do? : Sas programming
how can you sort the dataset having millions of OBS(instead of sort procedure?
What do you know about sas data set?
Can you explain the process of calendar?
How substr function works in sas?
What is substr function?
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
What is the difference between order and group variable in proc report?
Write a SAS macro to calculate number of numbers in an email address
create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
How is character variable converted into numeric variable and vice versa?