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 is the function of output statement in a SAS Program?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
if x=round(26.3,10)-1 then x= how much and how explain?
what is sas database server? : Sas-di
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
what is the function of catx syntax? : Sas-administrator
Are you involved in writing the inferential analysis plan? Tables specfications?
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
how to intersect the tables by using PROC MIXED?
what are all the reports you generated in your recent project?
0 Answers Accenture, Quintiles,
How to Rename Library?