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
- 8481 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 are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
What is the difference between %put and symbolgen? : sas-macro
What is the difference between %local and %global? : sas-macro
How experienced are you with customized reporting and use of Data _Null_ features?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
what is fact table and factless table?
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
what is the purpose of _error_? : Sas programming
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
Can we replace a dataset into view?
Teradata 
