ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories >> Software >> Data-Warehouse >> SAS
 
 


 

Back to Questions Page
 
Question
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..
Rank Answer Posted By  
 Question Submitted By :: Murali
I also faced this Question!!   © ALL Interview .com
Answer
Proc sort data=dataset;
by idnumber ;
run;
 
0
Amar
 
 
Answer
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;
 
0
Natraj Boga
 
 
Answer
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 sort data=abc;
run;
 
0
Guest
 
 
 
Answer
data xyz;
set abc;
retain a g k m o s t;
run;
 
0
Sravan
 
 
Answer
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..
 
0
Neelima
 
 
Question
What does a PROC TRANSPOSE do?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Accenture
I also faced this Question!!   © ALL Interview .com
Answer
The TRANSPOSE procedure creates an output data set by 
restructuring the values in a SAS data set, transposing 
selected variables into observations.
 
0
Raveendranath
 
 
Answer
To make this crosstabulation of time of day and choice of
radio programming, you must have a data set that contains a
variable for time of day and a variable for programming
preference. PROC TRANSPOSE reshapes the data into a new data
set that contains these variables
 
0
Amar
 
 
Question
What report output formats can you generate using SAS?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Accenture
I also faced this Question!!   © ALL Interview .com
Answer
Sas generates output formats like RTF,HTML,listings using 
Sas ods.
 
0
Joe
 
 
Answer
we can generate many types of reports by using sas like RTF,
HTML. PDF , TABULATE FORMAT ,
 
0
Kumarra
 
 
Question
What is the difference between a PROC step and a DATA step?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Accenture
I also faced this Question!!   © ALL Interview .com
Answer
proc to produce output

data to read the information
 
0
Ram
 
 
Answer
we can create the sas data set from raw data file in data step

Then in proc step we can do the analysis on sas data set and
also we can get o/p
 
0
Kumarrd
 
 
Answer
Data step to read and modify data , creates a SAS data set 
and begin with DATA statement.
Proc step to perform specific analysis , produce results 
and begin with PROC statement.
 
0
Subrahmanyam
 
 
Answer
A Data step can be used to:
1)Put your data into SAs dataset
2)Create and format values for new variables
3)Creating new dataset in terms of sub setting,merging and 
updating existing dataset.
A Proc step can be used to:
1)To print a report
2)Derive descriptive statistics,charts and plots
3)To create tabular report,create frequency chart etc.
 
0
Simky
 
 
Question
What does error:1 mean?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Accenture
I also faced this Question!!   © ALL Interview .com
Answer
It will just neglect the 1st error in your code & it will 
execute the rest of the code.
 
0
Kiven
 
 
Answer
but even one error exisit it won't genrate the compalied 
program to execuit
 
0
Druva Kumar G.
 
 
Question
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE 
REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER?
AND DEFERENCIATE THESE TWO ?
1).   REPORT PROCEDURE
2).   TABULATE PROCEDURE

Rank Answer Posted By  
 Question Submitted By :: Natrajboga
This Interview Question Asked @   CybAge
I also faced this Question!!   © ALL Interview .com
Answer
I basically prefer Proc report. By using proc report also 
you can create a Tabular format report and its pretty 
simple.
 
0
Kiven
 
 
Question
WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS 
FUNCTION?
Rank Answer Posted By  
 Question Submitted By :: Natrajboga
This Interview Question Asked @   Zensar
I also faced this Question!!   © ALL Interview .com
Answer
Returns values from the queues
 
0
Hari
 
 
Answer
Lag() function returns the value of the first previous 
observation in a time series. It could be used in Auto 
Regression analysis for time series. 

For example, Let y be the cloumn name for the original time 
series, the analysis for AR(2) could be:

data test;
set test;
m = lag(y);
n = lag(m);
run;
proc reg data = test;
model y = m n;
run;
 
0
Zyin2
[-------------------------]
 
 
Question
how can u join the two tables without using proc sql Joins 
and nested queries ?
Rank Answer Posted By  
 Question Submitted By :: Natrajboga
This Interview Question Asked @   IBM
I also faced this Question!!   © ALL Interview .com
Answer
By using the DATA step Merge.
 
3
Rajaanku11
 
 
Answer
we can use Merge and set statements to join the tables in
Data step
 
0
Kumarravi111
[-------------------------]
 
 
Question
wt is a-z and a--z?
Rank Answer Posted By  
 Question Submitted By :: Natrajboga
This Interview Question Asked @   Accenture
I also faced this Question!!   © ALL Interview .com
Answer
If we consider 'a' as lower limit and 'z' as upper limit,
a-z is used to refer numeric variables and a--z is used to
refer to character variables.
 
0
Suneetha
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com