how to shift the rows to cols? eg: i have like field1 field2 field3 10

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?

Question Posted / sun

3 Answers
8612 Views
CMC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this sh..

Answer / luclyl

proc transpose data=hyd out=mum (drop=_NAME_);
var a b c;
run;

Is This Answer Correct ?

7 Yes

2 No

how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this sh..

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

how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this sh..

Answer / guest

you can also use arrays to shift rows into columns.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer

More SAS Interview Questions

How would you define the end of a macro?

0 Answers

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

0 Answers Accenture, Quintiles,

what is sas metadata server? : Sas-di

0 Answers

what is study design in while working with SAS? what are screening variables in SAS?

0 Answers MSCR,

how do you read binary data in sas?

3 Answers Satyam,

Which is the best training Institute for SAS Business Intelligence course?

6 Answers

What are the functions done while Compilation...?

1 Answers TCS,

What r all the reporting procedures...?

3 Answers

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers

How are the analysis data sets structured?

3 Answers

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers Accenture,

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

0 Answers

For more SAS Interview Questions Click Here