地里新农-请到考试中心学习规则
- 积分
- 0
- 大米
- 颗
- 鳄梨
- 个
- 水井
- 尺
- 蓝莓
- 颗
- 萝卜
- 根
- 小米
- 粒
- 学分
- 个
- 注册时间
- 2019-8-18
- 最后登录
- 1970-1-1
|
本帖最后由 江北一散人 于 2023-9-9 01:10 编辑 . 1point 3acres
楼主机器:联想拯救者Y7000P 2020H
设备名称 LAPTOP-1TKDGCB2
处理器 Intel(R) Core(TM) i7-10875H CPU @ 2.30GHz 2.30 GHz
机带 RAM 16.0 GB. 1point 3 acres
外接显示器和无线键鼠在家考的试;因为在美和机器的原因,考场中非常丝滑,并无任何明显卡顿;复制粘贴确实不能用,但我用SAS自带的copy paste用的很溜;
Lab 5题, 改错Error2题,22道选择题,符合或类似原题如下:
1.
ods html file = 'yyy.yyy';
print data = xxxx.xxx;
proc freq data = xxxx.xxx;
run;
ods html close;
问有几个procedure在html文件里,楼主最开始选只有freq,没想到后来去lab里一试,居然两个都能print出来,所以就选了both;.1point3acres
2. 原题
40.The following SAS program is submitted:
data WORK.PRODUCTS;.1point3acres
Prod=1;. Χ
do while(Prod LE 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?
A. 6
B. 7
C. 8
D. . (missing numeric)
42.The following SAS program is submitted:
data WORK.ONE;
Text='Australia, US, Denmark';
Pos=find(Text,'US','i',5);
run;
What value will SAS assign to Pos?
A. 0
. .и B. 1
C. 2
D. 12
变题问 Text = ‘She sells seashells on the seashore’Pos = find(Text,'she ') Pos等于几,lab试了下等于0,我还以为会报错呢...因为Pos里是小写的‘she’+空格;
3.. check 1point3acres for more.
Macro 定义 写一行 %let xxx_type = 8,擦, 我这道题可能忘记加分号了,大家一定要注意原题有没有给分号。
4.
Transpose连考两道选择题;第一题是问哪个选项用于生成数据,有什么by id idlabel 还有个啥很不靠谱的我忘了,反正只有by能选,因为按照国家分组;
第二题是填空题,需要依次填入 by var id,跟前一题的题干很像,但是有改动,如果我没记错我填的是:
. Χby country. .и
var sales (var是转置后列里面的数据变量).google и
id Type(id是转置后的行名称)
此题后面有分号所以就不用分号了;
5.put input 变化,有考,务必记熟了,我考的是numeric to character在lab里;
6.keep在括号里和括号外的用法,选择题,只有括号里是正确的,括号外它也加了=就错了;
7.原题:.google и
The following SAS program is submitted: B
data WORK.DATE_INFO; X='04jul2005'd; DayOfMonth=day(x); MonthOfYear=month(x); Year=year(x);.1point3acres
run;
What types of variables are DayOfMonth, MonthOfYear, and Year?
A. DayOfMonth, Year, and MonthOfYear are character.
B. DayOfMonth, Year, and MonthOfYear are numeric.. From 1point 3acres bbs
C. DayOfMonth and Year are numeric. MonthOfYear is character. D. DayOfMonth, Year,. .и
8. 原题
The following SAS program is submitted: B
data WORK.TEST;.google и
set WORK.PILOTS;
if Jobcode='Pilot2' then Description='Senior Pilot'; else Description='Unknown';
run;. check 1point3acres for more.
The value for the variable Jobcode is: PILOT2.What is the value of the variable Description?
A. PILOT2. 1point 3 acres
B. Unknown
C. Senior Pilot. Waral dи,
D. ' ' (missing character value).
我考的字符不是PILOT2,但是大同小异,答案仍然是Unknown;.
9.原题
A user-defined format has been created using the FORMAT procedure.How is it stored? A-baidu 1point3acres
A. in a SAS catalog
B. in a memory resident lookup table.. From 1point 3acres bbs
C. in a SAS dataset in the WORK library
D. in a SAS dataset in a permanent SAS data library.1point3acres
10.原题
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? B
A.
proc print data=SASUSER.HOUSES label;
label Open_Date "Starting Date"; run;
B..
proc print data=SASUSER.HOUSES label;.1point3acres
label Open_Date="Starting Date"; run;
C.
proc print data=SASUSER.HOUSES;
label Open_Date="Starting Date"; run;.google и
D.. Waral dи,
Xing Bob Jorge. ----
proc print data=SASUSER.HOUSES; Open_Date="Starting Date";
11.原题:
data WORK.PRODUCTS; Prod=1;. From 1point 3acres bbs
do while(Prod LE 6);
Prod + 1; end;
run;
What is the value of the variable Prod in the output data set?. ----
A. 6
B. 7 ..
C. 8 ..
D. . (missing numeric)
12.变题:
52.Given the SAS data set WORK.EMP_NAME:
Name EmpID
---- -----
Jill 1864
Jack 2121
Joan 4698
John 5463 ..
Given the SAS data set WORK.EMP_DEPT:
EmpID Department. ----
----- ----------
2121 Accounting
3567 Finance
4698 Marketing
5463 Accounting ..
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);-baidu 1point3acres
run;.1point3acres
How many observations are in data set WORK.ALL after submitting the program?
A. 1
B. 2
C. 3
D. 5
我考的这道变了一下,数据有变,我选的4个,上面2个,下面2个
Lab:
Lab部分
1.certXL定义并调用考了,问xlsx文件里面的文件各叫什么名字,我用proc contents调用的,实际上你从自动填充也能看出来,但保险起见我还是print了一下;. check 1point3acres for more.
2. 原题 数据集sashelp.class的属性里,encoding和label的值分别是什么。
proc contents data=sashelp.class;
run;
数据集变了下,最坑爹的是,要求type出encoding,我应该填的是 waltin 什么什么 (Windows). ----
3. 变题 在每个department中,挑出含有最高income的观测。sort和descending是老生常谈的考题了,我是让我sort两次,第一次和第二次的排序方式不一样,第一次是升升降 第二次是升降 问 CustomerID;
4. |
|