Interested to Buy Any Domain ? << Click Here >> for more details...
how to shift the rows to cols?
eg:
i have like
field1 field2 field3
10 20 20
this should be displayed as
field1 10
field2 20
field3 30
(without the obs col)
how do this?can i use transpose or tell me suitable way to
do this?
- 3 Answers
- 8753 Views
- CMC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / luclyl
proc transpose data=hyd out=mum (drop=_NAME_);
var a b c;
run;
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / haritha
by using proc transpose procedure
ur data should be like this
data hyd;
input a$ b$ c$;
datalines;
field1 field2 field3
10 20 30
;
run;
solution will be like this:
proc tranpose data=hyd out=mum;
var a b c;
run;
proc print data=mum noobs;
run;
| Is This Answer Correct ? | 5 Yes | 2 No |
Where do the database management systems store data and how do u import them.
How can you limit the variables written to output dataset in data step?
how many types prompting framework can be broken down to? : Sas-bi
what is Enterprise Guide?what is the use of it?
How to convert a numeric variable to a character variable?
what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?
36 Answers Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,
How will you generate test data with no input data?
what is the diff b/w verification validation in sas
Briefly describe 5 ways to do a "table lookup" in sas.
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
Teradata 
