2020最新SAS BASE 机经8/28, 考了934分回来报恩,低分逆袭故事

看了一亩三分地很多人都说在一周内考过了SAS BASE, 我就给大家励志一下吧, 我是怎么拖拖拉拉花了3个月才考过SAS BASE的. 希望给正在彷徨的你一点激励
背景交代: 本科:会计  研究生:数据分析

考SAS BASE原因: 在学校学的是R PYTHON SQL,毕业面临找工作的问题, 我一朋友就推荐我学SAS 因为他们生物制药行业很缺会SAS的人,时薪也相对较高;(当然考完证才完成了1/3);

我是5月份就开始在udemy上一个sas base的课, 课的时间很长, 就断断续续的听, 听到一半放弃了. 然后我再捡起来的时候是8.11号, 打算10天内考过SAS,报了名后一下子就有了紧迫感. 不过我换了一个网课SAS官方课程:https:双斜杠support.sas.com斜杠edu/schedules.html?crs=PROG1&ctry=us 我也不知道是否能发站外链接, 把双斜杠去掉 换成 //就行了,斜杠去掉 换成 /.

这个课程就是短小精悍了, 讲的不多,一个知识点2-3分钟,然后就是很多习题, 这样能快速上手. 实话实说:我很多习题都卡住了, 还是看答案再打几遍加深记忆.  看完课程后我就开始刷机经了: 机经分为选择题 和lab;

选择题我用的是base 70,  有两个版本 Harrison 和 Crackman的, Harrison的只有59道题,推荐先刷他的 https:双斜杠worldwall.info/tag/70%E9%A2%98/ 他的答案很清晰明了;
然后再刷 Crackman的 他的解释很复杂,对新人相对不太友好 他的pdf版本我放在网盘里了 考虑到很多萌新可能积分不够 文末有提取码不用积分就能下载. 当然大家要是能积分鼓励,本攻感激不尽.

Lab 我用的是 机经每日一练  真的太好用了, 因为lab的题目基本上都没有变, 只要会了这些function( ) 基本上分数就跑不掉了; lab机经我也放在百度网盘里了 需要的可以自行下载;

本来是报名8.20号在家考的,但是那天系统出故障了, 我打电话给客服后,他给了我一个Voucher, 我就报了8.28的,所以考试系统出问题不要急,SAS会安排你重新考的.

好了下面是机经正文: 一共是40道题, 8个Lab 18题, 剩下22道选择题 一共40题

选择题:
1.The following SAS program is submitted:(考试的时候变形了 日期是01/15/1960, 用mdy()处理后,答案是14)

data WORK.DATE_INFO;
Month=”01″ ;
Yr=1960 ;
X=mdy(Month,01,Yr) ;
run;

What is the value of the variable X?
A. the numeric value 0
B. the character value “01011960”
C. a missing value due to syntax errors
D. the step will not compile because of the character argument in the mdy function.
Answer: A

2.After a SAS program is submitted, the following is written to the SAS log:

101 data WORK.JANUARY;
102 set WORK.ALLYEAR(keep=product month num_Sold Cost);
103 if Month=’Jan’ then output WORK.JANUARY;
104 Sales=Cost * Num_Sold;
105 keep=Product Sales;
-----
22
ERROR 22-322: Syntax error, expecting one of the following: !,!!, &, *, **, +, -, , <=, <>, =, >, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,NOTIN, OR, ^=, |, ||, ~=.
106 run;

What changes should be made to the KEEP statement to correct the errors in the LOG?
A. keep=(Product Sales);
B. keep Product, Sales;
C. keep=Product, Sales;
D. keep Product Sales;
Answer: D

3.The following SAS program is submitted:

data course;
input exam;
datalines;
50.15
;
run;

proc format;
value score 1 – 50 = ‘Fail’
51 – 100 = ‘Pass’;
run;

proc report data =course nowd;
column exam;
define exam / display format=score.;
run;

What is the value for exam?
A. Fail
B. Pass
C. 50.5
D. No output
Right Answer: C

4.Given the following data step:

data WORK.GEO;
infile datalines;
input City $20.;
if City=’Tulsa’ then
State=’OK’;
Region=’Central’;
if City=’Los Angeles’ then
State=’CA’;
Region=’Western’;
datalines;
Tulsa
Los Angeles
Bangor
;
run;

After data step execution, what will data set WORK.GEO contain?

A.

Obs        City        State        Region
1        Tulsa        OK        Western
2        Los Angeles        CA        Western
3        Bangor                Western
选项太长了 我只列出正确选项A

5.Given the SAS data set WORK.PRODUCTS:

ProdId        Price        ProductType        Sales        Returns
K12S        95.50        OUTDOOR        15        2
B132S        2.99        CLOTHING        300        10
R18KY2        51.99        EQUIPMENT        25        5
3KL8BY        6.39        OUTDOOR        125        15
DY65DW        5.60        OUTDOOR        45        5
DGTY23        34.55        EQUIPMENT        67        2
The following SAS program is submitted:

data WORK.OUTDOOR WORK.CLOTH WORK.EQUIP;
set WORK.PRODUCTS;
if Sales GT 30;
if ProductType EQ ‘OUTDOOR’ then output WORK.OUTDOOR;
else if ProductType EQ ‘CLOTHING’ then output WORK.CLOTH;
else if ProductType EQ ‘EQUIPMENT’ then output WORK.EQUIP;
run;

How many observations does the WORK.OUTDOOR data set contain?
A. 1
B. 2
C. 3
D. 6

Right Answers:B 这里是出的选择题

6.The following SAS program is submitted:

data WORK.TEST;
set WORK.PILOTS;
if Jobcode=’Pilot2′ then Description=’Senior Pilot’;
else Description=’Unknown’;
run;

The value for the variable Jobcode is: PILOT2. What is the value of the variable Description?
A. PILOT2
B. Unknown
C. Senior Pilot
D. ‘ ‘ (missing character value)
Right Answer: B

7. A user-defined format has been created using the FORMAT procedure.How is it stored?
A. in a SAS catalog
B. in a memory resident lookup table
C. in a SAS dataset in the WORK library
D. in a SAS dataset in a permanent SAS data library
Right Answer: A

8.The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label of “Open Date”. Which SAS program temporarily replaces the label “Open Date” with the label “Starting Date” in the output?

A.
proc print data=SASUSER.HOUSES label;
label Open_Date “Starting Date”;
run;

B.
proc print data=SASUSER.HOUSES label;
label Open_Date=”Starting Date”;
run;

C.
proc print data=SASUSER.HOUSES;
label Open_Date=”Starting Date”;
run;

D.
proc print data=SASUSER.HOUSES;
Open_Date=”Starting Date”;
run;
Right Answer: B

9. data WORK.ONE;
Text=’Australia, US, Denmark’;
Pos=find(Text,’US’,'i');
run;

What value will SAS assign to Pos?

A. 0
B. 1
C. 2
D. 12
Right Answer: C 这里改了是直接从头开始找'US' 没分大小写,

10.Given the SAS data set WORK.ONE:

Id        Char1
111        A
158        B
329        C
644        D
and the SAS data set WORK.TWO:

Id        Char2
111        E
538        F
644        G
The following program is submitted:

data WORK.BOTH;
set WORK.ONE WORK.TWO;
by Id;
run;

What is the first observation in SAS data set WORK.BOTH?
A.Id        Char1        Char2
111        A       
B.Id        Char1        Char2
111        E       
C.Id        Char1        Char2
111        A         E
D.Id        Char1        Char2
644        D        G
Right Answer: A

11.Given the SAS data set WORK.EMP_NAME: 改成填空题了 答案不变2

Name        EmpID
Jill        1864
Jack        2121
Joan        4698
John        5463
Given the SAS data set WORK.EMP_DEPT:

EmpID        Department
2121        Accounti
3567        Finance
4698        Marketin
5463        Accounti
The following program is submitted:

data WORK.ALL;
merge WORK.EMP_NAME(in=Emp_N)
WORK.EMP_DEPT(in=Emp_D);
by Empid;
if (Emp_N and not Emp_D) or (Emp_D and not Emp_N);
run;

How many observations are in data set WORK.ALL after submitting the program?

A. 1
B. 2
C. 3
D. 5
Right Answer: B

12.The following output is created by the FREQUENCY procedure:

Frequency
Percent
Row Pct
Col Pct       
Table of Region by Product
Region        Product
Corn        Cotton        Oranges        Total
East       
2
22.22
50.00
50.00       
1
11.11
25.00
33.33       
1
11.11
25.00
50.00       
4
44.44
South       
2
22.22
40.00
50.00       
2
22.22
40.00
66.67       
1
11.11
20.00
50.00       
5
55.56
Total       
4
44.44       
3
33.33       
2
22.22       
9
100.00
Which TABLES statement was used to completed the following program
that produced the output?

proc freq data=sales;
<_insert_code_>
. From 1point 3acres bbsrun;

A. tables region product;
B. tables region,product;
C. tables region/product;
D. tables region*product;
Right Answers: D

13. The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements, inserted in the two locations above,create a report stored in an html file?
A.
ods html open='sales.html';
ods html close;
B.
ods file='sales.html' / html;
ods file close;
C.
ods html file='sales.html';
ods html close;
D.ods file html='sales.html';
ods file close;
Right Answers: C

14. data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
label Jobcode='Job Description';
run;
Which statement is true about the output dataset?
A. The label of the variable Jobcode is Job (only the first word).
B. The label of the variable Jobcode is Job Desc (only the first 8 characters).
C. The label of the variable Jobcode is Job Description.
D. The program fails to execute due to errors. Labels must be defined in a PROC step.
Right Answer: C

15.The following SAS program is submitted: 这题改成填空题了 答案是1
data WORK.SALES;
do Year=1 to 5;
do Month=1 to 12;
. 1point3acres.com X + 1;
end;
end;
run;
How many observations are written to the WORK.SALES data set?
A. 0
B. 1
C. 5
D. 60
Right Answer: B

16. The SAS data set named WORK.SALARY contains 10 observations for each department,and is currently ordered by Department. The following SAS program is submitted:

data WORK.TOTAL;
set WORK.SALARY(keep=Department MonthlyWageRate);
by Department;
if First.Department=1 then Payroll=0;
Payroll+(MonthlyWageRate*12);
if Last.Department=1;
run;

Which statement is true?
A. The by statement in the DATA step causes a syntax error.
B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
C. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.
D. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.
Right Answer: C

17: 填空题考的 Macro Variables 问 给出 %let __________  答案是 number = 8
问如何把8给Age                              Age = &number

18-19 考了两道 transpose的题目 都是填空题  记住transpose基本上要你填  by____  var____ ID____ 后面接什么变量
记住ID 是在横轴 也就是variable name,你看他之前属于哪个variable里面的变量,你就填这个variable name,  by在纵轴 同理, var是内容;

. 1point 3 acres20. The following SAS program is submitted:

data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First.<_insert_code_> then Payroll=0;
Payroll+Wagerate;
if Last.<_insert_code_>;
run;

The SAS data set WORK.SALARY is currently ordered by Gender within Department.
. ----
Which inserted code will accumulate subtotals for each Gender within Department?
A. Gender
B. Department
C. Gender Department
D. Department Gender
Right Answer: A

21. 填空题: 文件名fox2.sas7bdat 问 dbms 填什么
这个我没搞懂 蒙的tab;

22.The following SAS program is submitted:

data WORK.TEST;
set WORK.MEASLES(keep=Janpt Febpt Marpt);
array Diff{3} Difcount1-Difcount3;
array Patients{3} Janpt Febpt Marpt;
run;

What new variables are created?
A. Difcount1, Difcount2 and Difcount3
B. Diff1, Diff2 and Diff3
C. Janpt, Febpt, and Marpt
D. Patients1, Patients2 and Patients3
Right Answer: A

剩下的Lab 改天更新 考完太累了 准备睡了.
资料都放在百度网盘里了 https:双斜杠pan.baidu.com斜杠s斜杠11f9GBqhBSDqorp53BLLSiA
提取码：49id

感谢！请教楼主第21题：.sas7bdat file 本身是sas file为什么要填dbms呢？

鲁大师 发表于 2020-08-30 02:25:17
感谢！请教楼主第21题：.sas7bdat file 本身是sas file为什么要填dbms呢？

是不要填 能跑出来就好了

正需要，谢谢楼主分享！

感谢🙏

21题我也有问题，如果用proc import才需要填DBMS，但是好像没有import sas7bdat格式文件的

感谢分享， 我也从来没学过数据或统计， 也是在Coursera 上报了课， 定了两个月后考 Base Cert， 看了你的分享很受鼓励。

谢谢楼主，终于找到含原始数据的机经了，之前的没有原始数据光有答案看得一头雾水