注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
本帖最后由 蒋思覃 于 2021-11-22 13:38 编辑
第一次发帖 求大米呀
考试时界面不卡 输入也没有延迟 运行也很快
就是 control+v control+c 复制的粘贴的时候有点慢
提前半小时check-in check-in 完后也没有等到开始考试的时间 就可以开始考试了
第一次考 还是有点慌 第一题出来的时候还以为sample question
然后看到右上角的倒计时 才意识过来这已经是考试题目了
备考时间一个月 期间断断续续看了一下 本身在学sas软件 所以有一点基础知识 . From 1point 3acres bbs
做了以便120 50 做了四遍70 (超重要)然后四五遍机经每日一遍 968 out of 1000
考试用的 sas studio
lab 题目 和机经不太一样 但是在前辈的机经中都出现过
印象深刻的题目
proc import 中如果没有replace option 但是output已经存在 应该怎么办
A Sas will name it output2;
B sas will overwrite the dataset
C sas will not replace the dataset but write a note in the log
D sas will prompt user to rename the new data set.
还是import
如果import的 data set有1-10 observations have 10 characters long;
and the remaining observations have 30 character long;
and some observations have different attributes;-baidu 1point3acres
A format
B GUESSINGROWS
C lable
D length.--
就这两个新题
lab1 把full_name 分成last_name first_name (Smith, John)
1.哪个last_name出现最多次. Χ
2.出现了多少次
3.first_name=‘XU XIN’ 的出现了几次;
lab2 three data set june august july
1 stepC in june 3rd
2 min stepB in August 20-baidu 1point3acres
3 step A in june 15
lab3 给你一个input15, 查看enconding 和label
直接proc content data=
lab4 age <=39 young
40<age<=65 mid
age> 65 notasyoung
1 observations of young data set
2 #34 in mid;
3 忘了
lab5 给你一个input 然后用proc transpose 转成题目中给的表的样式(题目会告诉你转置后的rows=52)
*****所以一定要记清楚ID 是变成标题名字的 by 是不变的 var 是要转置的
1 the number of variable
2 #1595 observation
. 1point 3 acres
lab6 merge two data set and output 3 data set ..
a b 都包含的变量 then 输出. Χ
只在a then 输出
只在b then 输出
lab7 error 先复制code然后新建program
很简单 drop=age; 改成 drop age;
然后data set younger 改成young . .и
proc freq var 改成table;
选择题. check 1point3acres for more.
大部分都是70题变形
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;. From 1point 3acres bbs
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?
改成了填空 2. check 1point3acres for more.
The following SAS program is submitted:
data WORK.out;
var=mdy(1, 15,1960);
run;.--
Variable X contains what value?
A. 0.--
B.14. ----
C. 15
D.1/15/1960
ans b
A user-defined format has been created using the FORMAT procedure.How is it stored?
A. in a SAS catalog-baidu 1point3acres
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. Waral dи,
Answer: A
62.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 powerpoint file?
选择题
ods PowerPoint file='sales.html';
ods PowerPoint close;
|