SAS BASE 归来， 话复习中没有遇到过的考题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

感觉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编辑过]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏2 回帖

关键词：SAS base Base Variables Character Location 复习 SAS 考题 Base

这样的好贴怎能不顶？！

给予奖励！

谢谢分享。。。谢谢！

1,Answer : sum is the total value of number variable and note that it has been grouped by type and breed .

或许有用