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
- 8446 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 |
What is connection profile? : sas-grid-administration
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
What is by-group processing?
How many missing values are available? When might you use them?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
in ods is there any lib's
What is the use of %include statement?
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
What is the maximum length of the macro variable?
To what type of programms have you used scratch macros?
Mention common programming errors committed in sas ?
Teradata 
