sas >> whats the difference between proc tabulate and proc report

by vinodh » Fri, 25 Apr 2008 11:13:15 GMT


I am fresh to SAS. I am confused a lot between proc report and proc

whats the difference between these two.

can anyone provide me the differences between these two please....


sas >> whats the difference between proc tabulate and proc report

by ir.bucher » Fri, 25 Apr 2008 21:21:57 GMT

PROC TABULATE allows for the creation of cross-tabulations, similar to
PROC FREQ, but it allows a greater level of control in terms of the
display of the data and the statistics generated.

PROC REPORT produces more listing-style reports, similar to PROC PRINT,
but allowing the inclusion of calculated statistics.

The best way to get a feel for the difference may be to take a look at the
SAS PROC Guide (available of the SAS website at ), which
provides pictures of reports and the syntax used to generate them.


sas >> whats the difference between proc tabulate and proc report

by ohri2007 » Fri, 25 Apr 2008 22:18:02 GMT

Best is to use approriate cross tab in proc freq or a class
statement with a proc means,or proc summary and use ods to make excel
sheets. Reporting formats are better formatted in excel. Ot

sas >> whats the difference between proc tabulate and proc report

by hs AT dc-sug DOT org » Sat, 26 Apr 2008 10:34:01 GMT

Take a look at the several "Titans" papers co-authored by Dan Bruns and Ray

Similar Threads

1. Proc Tabulate or Proc Freq or Proc Report

Please note the change in my e-MAIL Domain from BIOCON.COM to CLINIGENEINTL.COM.
All future correspondence to me should be addressed to  XXXX@XXXXX.COM 

Dear All,

I have a data set like this:

(Embedded image moved to file: pic02082.jpg)

I wanted the output in this format,

(Embedded image moved to file: pic22929.jpg)

Which Procedure to use. Thanks in Advance.

                                      Confidentiality Statement
The Information attached herewith is strictly confidential and for the
authorised use of the intended recipient only. If you are not the intended
recipient,  please notify the sender or  Biocon Limited immediately.
BIOCON LIMITED, 20th K. M. Hosur Road, Electronic City P.O
Bangalore-560 100, INDIA                     Website :
Phone: 00-91-80-2808 2808                    Fax: 00-91-80-2852 34 23

2. Do you prefer Proc Report or Proc Tabulate?Ans,If proc

3. Proc Transpose, Proc Tabulate, Proc Report?

Hi All,

I need to create a report that has a table with columns. At the top of each page is the person's name. The table has 8 columns. The name of the subscale is at the top (right above the table) of each table to the far left. The first cell (A1) in the first column has the text "My Principal...", then right underneath that in cell A2 the items begin. Item 1 says, "exhibits an understanding..."  Cell B1 has the text "Strongly Agree", cell C1 "Agree", cell D1 "Disagree', cell E1 "Strongly Disagree", cell F1 "Not Applicable". Item 2 begins in cell A3. Percentages are in cells B2, C2, D2, E2, and F2 for item 1. The table is the same for the other items that fall under that subscale. There are other tables just like what I described for the remaining 9 subscales.  The last page of the report has a table that compares the assistant principal's percentages on each of the competencies to All school  Principals in that school region and to All  Principals in the entire school district. A!
  region is comprised of a number of schools. Our school system has 8 regions.

I have one text file per school. I was told that I need to first transpose the data before using proc tabulate or proc report.  I am fairly new at this and am having a hard time with proc transpose.

I have copied the first line of a text file below so you can refer to it.

N 405001

The data doesn't start until after the N.  After the N, the first 3 digits are the school code followed by 001 or 002 indicating whether or not the respondent is classified staff or non-classified staff.

I know I need to use either proc tabulate or proc report or both to come up with the finished product which would be tables in Word that summarizes the data.

If anyone can help me, I would really appreciate it. I am a novice at this and need help getting started.

Thanks so much,


4. PROC TABULATE or PROC REPORT : newby question

5. Proc Report and Proc Tabulate


I am using proc tabulate very often in my current job. But I heard most
people are using proc report to generate results. Does anyone have a
preference  paper discussing the difference between  proc tabulate and
proc report,  Or any paper which has an overview of proc report? I have
searched papers on google, but I am overwhelmed. Thanks a lot.



7. Question on Proc Freq, Proc Tabulate, and reporting..

From one fish bowl to another..

An interesting problem on my part, but likely a simple answer.

I have variables from an input data set for which I assign a format and label.

LABEL q1=If you plan on taking to trip to Europe, when do you intend to do so?
q2=If you plan on taking to trip to Asia, when do you intend to do so?

FORMAT (For both q1 and q2)
1 = One year from now
2 = Two years from now
3 = Three years from now
4 = Four years from now
5 = 5 years from now
6 = more than 5 years from now

So when I run
TABLES q1 -- q2;

I get a standard frequency table with a label to describe the variable AND
the formats attached to their relative frequency

 "If you plan on taking..."
 One year from now  1
 More than 5 years  5

These tables are merely one-way frequency tables.

I've now been asked to take all of these variables and consolidate them into a
table that would look like the following:

Column 1  Column 2 .. Column 8
(Locale)  One year from now ... More than 5 years

The requestor is basically asking that I flip the table and merge the results
Is there a simple or straight-forward method of doing this?

(Or am I going to be running multiple out options in Proc Freq followed by
 multiple Proc Transpose with a final data set to merge the results?)

Signed a data step cruncher now lost in the wilds of SAS report writing..
Chris Amherst

8. similar statements in proc tabulate and proc report