i*t
发帖数: 835 | 1 以前看人讨论过，今天考到了，发现和大家手上的70题有点不一样。大家考试准备的时
候可以注意。一个是45.The following SAS program is submitted:
ods csvall file='c:\test.cvs';
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
我见到的是ods csvall file='c:\test.csv';
29.The following SAS program is sumbitted:
data WORK.INFO;
infile 'DATAFILE.TXT';
input @1 Company $20. @25 State $2. @;
if State=' ' then input @30 Year;
else input @30 City Year;
inp... 阅读全帖 |
|
t*****2
发帖数: 94 | 2 ods csvall file='c:\test.cvs';
proc print data=work.one;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
what is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS.
在网上搜了半天还是没有得到确定的答案。请各位高手赐教！ |
|
t*****2
发帖数: 94 | 3 ods csvall file='c:\test.cvs';
proc print data=work.one;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
what is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS.
在网上搜了半天还是没有得到确定的答案。请各位高手赐教！ |
|
p***7
发帖数: 535 | 4 another one:
45.The following SAS program is submitted:
ods csvall file=’c:\test.cvs’;
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by... 阅读全帖 |
|
x*c
发帖数: 156 | 5 45.The following SAS program is submitted:
ods csvall file='c:\test.cvs';
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS
70题里的答案是C, crakm... 阅读全帖 |
|
x******7
发帖数: 122 | 6 几个小时前考了BASE， 内容几乎可以认为全部来自题库50＋70+123，62题中大概20题
可以认为是变体
错了3题，大概知道错了下面两题／三题 顺便回忆了其它的一些题
1.
data temp;
infile xxx;
date="01feb1980"d
how to generate ship_note in the form “Feb 01, 1980”
A.ship_note=put(date,date9.)
B.ship_note=put(date,date9.,worddate20.)
C.ship_note=put(date,worddate20.)
D.ship_note=input(.....)
我选了错误答案B,
2.
x y
5 1
4 6
5 4
data one two other;
if x ge 5 then output one;
else if y le 5 then output two;
else output other;
How many obs in dataset one, two and other?
毫不犹豫选... 阅读全帖 |
|
c*****s
发帖数: 180 | 7 我也考了，但都忘了。楼主说的很全，我补充几点：
4.text="句子";
Find(text',US'i, 5 )问i=?;
5.是给出几个单词，然后问用什么命令能成一个他要求的例子：貌似catx的对。
6.debug还是debuger加在data语句后，好像选项有data sasuser.xxx debug; data....
/debug; data...debuger; data.../debuger;
13 没有PROC REPORT考试内容，大纲不考了。
14.题目特别长，然后问题大体是dlm=还是dsd 和dlm一起用。
16.考点在rename用法还有set a b，set a set b 和merge的区别。还有一题问set a b
的第一行输出是什么。
17.ods csvall "file"...
ods close;
问输出结果的文件是用什么格式读的。选项貌似有excel only.excel, txt and csv
;csv only.
20.如何输出这个lib里的文件名。貌似proc data=something _all_.
其他：
1. |
|
z****e
发帖数: 2024 | 8 Which of the following choices is an unacceptable ODS
destination for producing output that can be viewed in Microsoft Excel?
A. MSOFFICE2K
B. EXCELXP
C. CSVALL
D. WINXP |
|
l****u
发帖数: 199 | 9 要输出，used下列CODES：
不WROK method1：
proc export data=febdaily06 outfile='H:\death\test.xls' replace;
run;
ERROR: The target file contains unmatched range name and sheet name. You may
use other name or remove the unmatched range/sheet in the file.
不WROK method1：
尝试了最笨的方法：EXPORT，不WORK。
ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: ????????.
WORK的 method1：
proc export
outfile = "H:\death\test.dbf"
data = febdaily06
dbms = dbf replace;
run;
WORK的 method2：
ods csvall file="H:\d |
|
y******e
发帖数: 33 | 10 早上basic 归来。因为暑假实习开始正式的使用SAS，就想趁着这个机会把考试都考了
。于是报名了今早的BASIC. 因为是学生有半价，90大洋。
具体学生半价介绍如下：http://support.sas.com/certify/faq.html# Q2
约的9点半，但是8点半就到了。然后没人考，小秘很nice，9点就开始考了。用了一个
小时不到答题，然后检查了半个小时，结果是87%。比预计的差一点，不过过了就够啦
：）
真正的接触SAS 3个月，但是正式的备考不到两周吧。因为每天白天要上班上学没法看
，只能用晚上。看完了那个BASIC 的书，22章大概一天看个4章左右，用了7天吧。然后
123题用了一天，70题一天，50题一天。最后两个晚上看了看每一章的summary。其实每
次都是看着电视剧准备的，所以这个结果还是挺满意的。
考试刚开始有个tutorial，就是给你一个直观的印象。我之前是没有用过online的，所
以这个tutorial还是满有用的。
开始答题，不确定的就mark，答完不到50分钟，回头数了数mark大概二十多个，这个比
较恐怖啊，又重新过一遍mark，减少到1... 阅读全帖 |
|
p******m
发帖数: 65 | 11 请注意这里是‘cvs'
ods csvall file='c:\test.cvs'
这样的话正确答案是c
但是这个估计是typo.
因为在正式考试里我也碰到了这道题，他就变成了'csv'.
答案就是b |
|
S********s
发帖数: 42 | 12 我在考试的时候也碰到了这道题， 题目给的是：ods csvall file='c:\test.csv',答
案应该是b. |
|
