Answer / satyanand

PROC TABULATE is a procedure used to display descriptive
statistics in tabular format.

It computes many statistics that are computed by other
procedures, such as MEANS, FREQ, and REPORT.

PROC TABULATE then displays the results of these statistics
in a table format.

TABULATE will produce tables in up to three dimensions and
allows, within each dimension, multiple variables to be
reported one after another hierarchically.

PROC TABULATE has some very nice mechanisms that can be
used to label and format the variables and the statistics
produced.

Answer / sathya kanuri

The use of PROC TABULATE for producing statistical tables, as
an alternative to using PROC REPORT or FILE PRINT.

The techniques presented combine basic TABULATE statements
with DATA steps and other traditional SAS- procedures
(FORMAT,FREQ and UNIVARIATE) to produce report ready output.

PROC TABULATE is shown to be an efficient report writer,
capable of displaying a variety of statistics.

Answer / sivakumar sekar

The process of arranging data oderly in form of rows n
columns is knwn as tabulation. rows r horizontal
arangments, columns r vertical arngmnts


Example Using PROC TABULATE

To produce exactly what your boss wants, use the following
code:

PROC TABULATE;
CLASS GENDER;
VAR AGE INCOME EDUC;
TABLE (AGE INCOME EDUC)*MEAN, GENDER ALL;
RUN;
------------------------------------------------------------
Example without Using PROC TABULATE

PROC MEANS;
VAR AGE INCOME EDUC;
RUN;

PROC MEANS;
BY GENDER;
VAR AGE INCOME EDUC;
RUN;

How to convert a given date value into SAS date

9 Answers   CitiGroup, Quintiles,

---

What SAS statements would you code to read an external raw data file to a DATA step?

10 Answers   NIIT,

---

how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?

8 Answers   Wipro, Xansa,

---

Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS

1 Answers   Accenture, HSBC,

---

How to get the repeated values by using sql in sas ?

2 Answers  

---

if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

4 Answers   HSBC,

---

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

---

What are the efficacy variables in your study?

2 Answers   Accenture, Quintiles,

---

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

0 Answers   Satyam,

---

What is the order of evaluation of the comparison && logical && relational operators:?

2 Answers   CitiGroup,

---

When you will use nowd option in report???

6 Answers   Accenture,

---