感觉70道题中有至少有40道是123题库中的。题库中出现的这里就不重复了，现就把我复习中没有遇到过的我能记得的考题列出来, 希望对大家有帮助。(真实中的data 和变量名等忘了，我只把框架摆出来)

1.      proc print;

by type breed;

sum number;

run; 

Q: what’s the SUM is used for?  

2. To print a summary of all the files stored in the library named SASUSER, using

PROC CONTENTS DATA=SASUSER._ALL_ or PROC CONTENTS LIB=SASUSER._ALL_?

 

3. dataset A has variable locationfee with format dollar9. and dataset B has variable countryfee with format dollar6. 

Data realeastate;

format locationfee countryfee dollar6.;

set A B;

locationfee=locationfee/100;

countryfee=countryfee/100;

run; 

Q: What is the format look like for locationfee and countryfee? 

       4.

DATA TWO

X  Y     Z

1  A     27

1  A     53

2  A     number1 /忘了/

2  B    number2

3  A  number3

4  A  number4

4  B  number5

            data one;   Set two;     By x y;    If first.y; run; 

Q; What’s the output look like? 

5. A dataset has two variables, A and B where B is character variable

A B

X 1

Y 2

Z 3 

   Q:  What’s the result after submitting  “proc print…;where B<2”? /**notice B is not numeric**/ 

     6.    data look like this (虚构的数据)

Name SSN

A 111111111

B 222222222

C 333333333  

data xxx;

set yyy;

file 'file-sepcification';

put A B;

<insert put statement here>

Run;

             Q: How can you make the double-spaced outuput like

 

 

Name SSN

A 111111111

 

B 222222222

 

C 333333333

 

 

a)      put double;

b)      put;

c)      put /;

 7.      User defined format should be stored in

 7.      User defined format should be stored in

a)      catalog

b)      work library

c)      permanent library 

8        data one has two variables var 1 and var2, the questions is asking you what’s wrong with the following codes

data two;

set one (keep=v1 v2 v3);

v3=v1+ v2;

run;

6. 最后就是一些论坛中已经提到过的find, transwrd, catx, 的用法, 比如

AA=”DRIVE”;

B=TRANWRD(“8901 LONDON DRIVE”, AA, “WAY”)

Q: What’s the output for B? 

            和

Liu

Isbella

Ireland

Lanei 

Proc print;

where name like (_i%);

run; 

Q: What's the output for name?

 

 

 

[此贴子已经被作者于2008-3-22 13:43:13编辑过]