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
- 8637 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 |
How would you code the criteria to restrict the output to be produced?
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,
How to get part of string form the source string without using sub string function in SAS?
How to write duplicate records into a separate dataset using sort?
What will calendar procedure do?
What are the data types that sas contain?
How do you put a giraffe into the refrigerator?
Have you used macros? For what purpose you have used? : sas-macro
How do i read multiple spaces in datasets?
What are the different servers in sas? : sas-grid-administration
How would you include common or reuse code to be processed along with your statements?
How would you define the end of a macro?
Teradata 
