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?
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 |
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
Do you think professionally?
Name types of category in which SAS Informats are placed?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
what are validation tools that are used in sas? : Sas-administrator
What is the difference between order and group variable in proc report?
Mention few capabilities of sas framework.
Mention sas system options to debug sas macros.
How do you read in the variables that you need?
what is option year cuttoff in sas
how to delete the duplicates by using proc sql?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?