hi guys ...i have one query...
data abc;
input s w k g o t a m;
cards;
1 2 3 4 5 6 7 8
2 3 4 5 6 7 8 9
;
run;
i want the output to be the sorted order(only
variables).observations should not be changed..
Answer Posted / natraj boga
here is solution to ur problem
options formdlim='.';
data abc;
input s w k g o t a m;
cards;
1 2 3 4 5 6 7 8
2 3 4 5 6 7 8 9
;
run;
**** create a dummy variable by assigning the values of any
one of ur variable;
**** here I have taken the values of S variable of your ABC
data set;
data setabc;
set abc;
l=s;
run;
proc print;run;
* transpose the variables into observations of a transposed
data set by using the ID statement;
proc transpose data=setabc out=T1_abc let;
id l;
run;
proc print;run;
**sort the transposed data set by using _name_ variable
inorder to get varibales in a ascending order;
proc sort data=T1_abc;
by _name_;
run;
proc print;run;
** once again transpose the sorted data set with the _name_
variable in ID statement;
proc transpose data=t1_abc out=t2_abc(drop=_name_) let;
id _name_;
run;
proc print noobs;
title 'sorting the variables in Ascending order';
run;
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
Name some categories in sas 9? : sas-grid-administration
what is factor analysis? : Sas-administrator
How many ways to overcome a missing values???
How can sas program be validated?
what are input dataset and output dataset options? : Sas programming
What are types of transport files?
What is the general format of function in sas? : sas-grid-administration
What are the statements in proc sql?
How do you debug and test your SAS programs?
Explain the difference between nodup and nodupkey options?
what is the purpose of _error_? : Sas programming
what is business intelligence? : Sas-bi
What are the differences between sum function and using “+” operator?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro