Answer / 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;

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;

Answer / neelima

simple..in the proc print statement use VAR statement and
give the variables in ur order...u'll get the ouput with
variables ordered in ur VAR statement..

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;

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;

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;

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;

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;

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;

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;

what is the difference between unique key and primary key? : Sas-di

0 Answers  

There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

what r the job openings SAS for fresher graduates !

0 Answers   TetraSoft, Wipro,

What are SAS/ACCESS and SAS/CONNECT?

0 Answers  

What are the criticality that you have faced during your project in SAS?

2 Answers  

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 Answers  

Name validation tools used in SAS

0 Answers  

What are the default statistics that proc means produce?

0 Answers  

What versions of SAS have you used (on which platforms)?

0 Answers   Quintiles,

how does sas handle missing values in functions? : Sas programming

0 Answers  

Explain what Proc glm does?

0 Answers