Answer Posted / sarath

We have two different type of TRANSPOSE: “UP” and “DOWN”:

“UP” transpose change rows of a dataset to columns, whereas
the “Down” transpose change columns to rows. We either
use "UP" or "DOWN" tranpose depending upon the requirement.

Whenver we use PROC TRANSPOSE we need to ask some questions
ourselves, since visualizing the PROC Transpose syntax is
not that easy:

To develop the PROC TRANSPOSE syntax we need to know the
answers to the above questions,

1) Which variable/variables need to get transposed?
A) Whatever the variable we mention in the ID statement.
2) What are the variables that need to stay same as in the
input dataset?
A) Variables that are included in the BY statement.
3) Which variables values need to become the values for the
transposed variable.
A) Variables that are included in the VAR statement.
read more at...

http://studysas.blogspot.com/2009/03/proc-transpose-how-to-
convert.html

What are common programming errors committed in sas

1097

---

Mention few capabilities of sas framework.

1126

---

Explain data_null_?

1003

---

Name some categories in sas 9? : sas-grid-administration

915

---

explain the key concept of sas? : Sas-administrator

941

---

Of all your work, where have you been the most successful?

4621

---

explain what is data set in sas? : Sas-administrator

911

---

How to limit decimal places for variable using proc means?

1044

---

What are the ways to do a “table lookup” in sas?

976

---

what is program data vector? : Sas-administrator

1012

---

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1076

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1099

---

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2280

---

Which function is used to count the number of intervals between two sas dates?

1066

---

What is SAS?

984

---