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 |
: and & modifiers.
How do you add a number to a macro variable?
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
what is portability of sas programmes?
How does proc sql work?
what are the different ways of merging two datasets.name atleast 4.
How would you combine 3 or more tables with different structures?
Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?
Compare sas with other data analytics tools.
"What is the difference between proc sort nodup and proc sort nodupkey?"
Write a SAS macro to calculate number of numbers in an email address