| 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;  |
| 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;  |
| 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;  |
| Guest |
| |
| |
|
|
| |
| Answer | data xyz;
set abc;
retain a g k m o s t;
run;  |
| 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..  |
| 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.  |
| 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  |
| 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.  |
| Joe |
| |
| |
| Answer | we can generate many types of reports by using sas like RTF,
HTML. PDF , TABULATE FORMAT ,  |
| 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  |
| 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  |
| 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.  |
| 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.  |
| 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.  |
| Kiven |
| |
| |
| Answer | but even one error exisit it won't genrate the compalied
program to execuit  |
| 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.  |
| 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  |
| 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;  |
| 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.  |
| Rajaanku11 |
| |
| |
| Answer | we can use Merge and set statements to join the tables in
Data step  |
| 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.  |
| Suneetha |
| |
| |
|
| |
|
Back to Questions Page |