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..
Answers were Sorted based on User's Feedback
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 |
Answer / m.sivakumar
ata 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;
proc transpose data=abc out=atranabc;
run;
proc print;
title 'Simple Example of PROC TRANSPOSE';
run;
proc sort data=atranabc;
by _name_;
run;
proc print;
run;
proc transpose data=atranabc out=sortabc(drop=_name_);
run;
proc print data=sortabc;
run;
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / aravind9882
yeh neelima is rt...
u will get the variables in the order u mention in the var
statement in proc print.
proc print data =abc;
var a g k m o s t w;
run;
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / jose av
No need of doing Tedious codes, just use those variables in
the alphabetical order in a LENGTH statement before setting
(before set statement) .Try this..
data abc_01;
length a g k m o s t 3.;
set abc;
run;
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / hetal bhalani
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;
**Transpose your data by listing all the variables you want
to transpose in the VAR statement**
proc transpose data =abc ;
var s w k g o t a m;
run;
**Now you have to sort the values in _name_ variable in asc
**
proc sort data=data1;
by _name_ ;
run;
**now transpose again using _name_ in the ID statement**
proc transpose data=data1 out=data2(drop=_name_);
id _name_;
run;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / surendra
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;
proc transpose data=abc out=bca;
var s w k g o t a m;
run;
proc sort data=bca;
by _name_;
run;
proc transpose data=bca out=mca(drop=_name_);
id _name_;
var col1 col2;
run;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venu
/*Sorting order by variable*/
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;
proc print data=abc;
run;
proc contents data=abc out=xyz;
run;
proc sql;
select name into :mac separated by " " from xyz;
quit;
proc print data=abc;
var &mac;
run;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anuj verma
data abc;
infile cards flowover;
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;
proc transpose data =abc out= abcd;
run;
proc sort data=abcd; by _name_; run;
proc transpose data =abcd out= abcde;
run;
proc print; run;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashish
proc contents data=abc out=test;
quit;
proc sort data=test;
by name;
quit;
proc sql;
select name into: v_name separated by " " from test;
%put &v_name;
quit;
data abc2;
retain &v_name;
/*retain a g k m o s t w ;*/
set abc ;
run;
Is This Answer Correct ? | 0 Yes | 0 No |
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
What is the difference between Proc tabulate and Proc print
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
How we will Developing new reports Using Data step programming and Macros ?
Please write codes to merge two datasets and keep every record in the first dataset.
what are the different ways of merging two datasets.name atleast 4.
How do you write a test plan?
what is star schema? : Sas-di
how to intersect the tables by using PROC MIXED?
What are Dashboard reports?And significance of these in analysis?
How many versions came upto now in SAS?
What versions of SAS have you used (on which platforms)?