由买买提看人间百态

topics

全部话题 - 话题: csvall
(共0页)
i*t
发帖数: 835
1
来自主题: Statistics版 - sas base 70的两道题
以前看人讨论过,今天考到了,发现和大家手上的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
来自主题: Statistics版 - sas base 70 key -errors
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
来自主题: Statistics版 - 求助: SAS BASE (70题) 第45题
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
来自主题: Statistics版 - SAS BASE 六一儿童节
几个小时前考了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
来自主题: Statistics版 - 问个SAS题
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
来自主题: Statistics版 - 求助: SAS BASE (70题) 第45题
请注意这里是‘cvs'
ods csvall file='c:\test.cvs'
这样的话正确答案是c
但是这个估计是typo.
因为在正式考试里我也碰到了这道题,他就变成了'csv'.
答案就是b
S********s
发帖数: 42
12
来自主题: Statistics版 - 求助: SAS BASE (70题) 第45题
我在考试的时候也碰到了这道题, 题目给的是:ods csvall file='c:\test.csv',答
案应该是b.
(共0页)