Interested to Buy Any Domain ? << Click Here >> for more details...
What does a PROC TRANSPOSE do?
- 8 Answers
- 18955 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raveendranath
The TRANSPOSE procedure creates an output data set by
restructuring the values in a SAS data set, transposing
selected variables into observations.
| Is This Answer Correct ? | 42 Yes | 2 No |
Answer / vengala reddy
it transposes the row values into column headings
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / 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
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / kumar
PROC TRANSPOSE will change the observations to variables
and variables to the observation
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / yakaiah
it just converts the rows into columns and vice and versa
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vamsi
Proc transpose procedure convert the data from normalization format to non-normalization format
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amar
To make this crosstabulation of time of day and choice of
radio programming, you must have a data set that contains a
variable for time of day and a variable for programming
preference. PROC TRANSPOSE reshapes the data into a new data
set that contains these variables
| Is This Answer Correct ? | 4 Yes | 5 No |
What are the differences between proc means and proc summary?
explain the proc in sas? : Sas-administrator
What was the last computer book you purchased? Why?
what is SAS/Graph?
I have a dataset with variables empid and doj how to calculate retirement age?
What is the order of evaluation of the comparison && logical && relational operators:?
You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 Answers Verinon Technology Solutions,
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
How would you compile all macros from a folder in a study, within the autoexec program?
how to rearrange the data as our wish by using dataset block?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
Teradata 
