Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the basic structure sas administrator? : Sas-administrator

955


What does P-value signify about the statistical data?

1300


What do the PUT and INPUT functions do?

1268


What is the difference between match merge and one to one merge?

1150


What is a method to debug and test your SAS program?

1273


How can you create a macro variable with in data step? : sas-macro

982


what are some good sas programming practices for processing very large data sets? : Sas programming

872


What is the function of output statement in a SAS Program?

1007


What is the use of function Proc summary?

1207


What is PDV?

1093


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

999


what is intially documentation in sas?

4951


explain the main difference between the nodup and nodupkey options? : Sas-administrator

1105


it will become easy if uuu provide website linkssss and list of consultanciessssss

1917


how can you create zero observation dataset? : Sas programming

1084