登录
  • #数学|统计

sa‌‌‌‌‌‌‍‍‌‍‍‌‌‍‌‍‍‌‌‌‍‍‍‍‌‍‌‍‍‌‌‍s base 11/22/2021 在家考

蒋思覃
651
5
第一次发帖 求大米呀

考试时界面不卡 输入也没有延迟 运行也很快

就是 control+v control+c 复制的粘贴的时候有点慢

提前半小时check-in check-in 完后也没有等到开始考试的时间 就可以开始考试了

第一次考 还是有点慌 第一题出来的时候还以为sample question

然后看到右上角的倒计时 才意识过来这已经是考试题目了



备考时间一个月 期间断断续续看了一下 本身在学sas软件 所以有一点基础知识

做了以便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;

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

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

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;

选择题

大部分都是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;

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

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

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

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;
5条回复
热度排序

发表回复