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;

How do you debug and test your SAS programs?

0 Answers   Quintiles,

Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.

2 Answers   Accenture,

how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.

1 Answers   TCS,

what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers  

Intern stastical programmer written test

0 Answers  

Difference between sum function and using “+” operator?

0 Answers  

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?

6 Answers  

Explain the use of proc gplot? : sas-grid-administration

0 Answers  

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

0 Answers  

How would you delete observations with duplicate keys?

6 Answers  

what are the three main credit bureau names

1 Answers   Synchrony Financial,

What are the data types in sas?

0 Answers