Answer / raveendranath

The TRANSPOSE procedure creates an output data set by
restructuring the values in a SAS data set, transposing
selected variables into observations.

Answer / vengala reddy

it transposes the row values into column headings

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

Answer / kumar

PROC TRANSPOSE will change the observations to variables
and variables to the observation

Answer / yakaiah

it just converts the rows into columns and vice and versa

Answer / vamsi

Proc transpose procedure convert the data from normalization format to non-normalization format

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

Answer / sree

ROW VALUES CONVERT IN TO OBSERVATION

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,

How do you use the do loop if you don’t know how many times you should execute the do loop?

0 Answers  

How do you add a number to a macro variable? : sas-macro

0 Answers  

How do you delete duplicate observations in sas?

0 Answers  

What are the difference between ceil and floor functions in sas?

0 Answers  

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers  

How can you put a "trace" in your program?

2 Answers   Quintiles,

Name and describe three SAS functions that you have used, if any?

2 Answers  

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers