Hi All,
can i get answers for all this questions.
1) Which OPTION in Proc Freq list all possible combinations of the variables values for an n-way table when n>1 even if a combination does not occur in the data.
2) Which of the following is true with regards to Where and If
statements.
i) Where state works before the observations are brought into the data step whereas if statements work when the observations that are already in the data step.
ii) The where statement is not executable were as IF is
iii) The where statement but not if can be used in the sas proc
3) Explain the significance of using options missing=’ ‘.
4) Chose whether true or false with explanations.
i) No dupkey is used to eliminate the duplicate observations in proc
sort.
ii) Distinct is used to eliminate the duplicate observations in proc sql.
iii) First. And last. are also used for eliminating the dublications.
5) how many observation will be in the output when the below code is executed.
DATA X;
INPUT NUM;
CARDS;
99999999991111
99999999992222
99999999992222
99999999993333
99999999991111
;
DATA TEST;
SET X;
IDC=PUT(NUM,BEST.);
RUN;
6) What will be the output when u execute this program.
Data old;
Do k=1,23,3,4,5,5,5l;
Output;
End;
Run;
Data new;
Set old ;
By k;
If not (first.k or last.k);
Run;
7)what will be the output for the following questions.
Data _null_;
Do index=0;
Wjo;e (1);
Count+1;
End;
Put index= count=;
Run;
8) Explain the output.
Data test;
A=1;
B=.;
Plus=a+b;
Sum=sum(a,b);
Put plus= sum=;
Run;
9) when data set name is not given in the proc sort wt will happen.
10) Why does the transpose procedure produce more than one coloumn (like col1, col2,col3………….)
11) when do the sas system gives this error.
“ merge statement has more than one dataset with repeats of by values”
12) options fullstimer;
proc contents data=te6;
run;
proc contents data=te9;
run;
if they is a data set which is having 1 billion 9data set te6) and 1 million(data set te9) records, does the above code produce the output.
13) data testl;
input trtgrp $ std subject;
cards;
B 1001 4205
A 1001 8657
B 1003 7620
B 1004 1198
A 1002 2065
A 1003 6394
A 1004 9348
B 1002 4756
B 1004 1198
;
I need to get the following out put. Using proc transpose.
Obs trtgroup std1001 std1002 std1003 std1004
1 A 5657 2065 6394 9348
2 B 4205 4756 7620 1198
14)why is it always favorable to use the “ list all” options in the compare procedure
14) what is the difference between set and merge.
15) What is the difference betweet set and append.
16) Wt is the use of order option in the proc report.
ALL THE BEST.
RGds.........sudheer.
Office firewalls, cyber cafes, college labs, don't allow you to download CHAT? Here's a solution!
Offline 
Send Email