n*****a
发帖数: 169 | 1 第29题有人做过吗？
上机运行的话，至少要为文件准备3个records才不会出错，所以我觉得正确答案是3
records for each iteraction。但不知如何解释。
Item 29 of 70 Mark item for review
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;
input NumEmployees;
run;
How many raw data records are read during each iteration of the DATA step?
答案为什么是2 records for each iteraction呢？是否一个RECORD是company, state
, ... 阅读全帖 |
|
D**0
发帖数: 195 | 2 总是被这类的题弄晕。请大侠解释一下下面这些题。能解释几道都可以。多谢！
Item 6 of 63 Mark item for review
The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average
salary based on jobcode:
Jobcode Salary ... 阅读全帖 |
|
s*****p
发帖数: 299 | 3 data work.GEO;
infile datalines;
input city $20.;
if city = 'Tulsa' then
state = 'ok';
Region = 'central';
if city = 'Los Angeles' then
state = 'CA'
Region='western';
datalines;
Tulsa
Los Angeles
Bangor
;
run;
after data step execution, what will data set work.GEO contain?
Answer:
City state Region
Tulsa ok Western
Los Angeles CA Western
Bangor Western
为什么Tulsa 的Region会是 Western？不是CENTRAL?为什么Bangor 的 ... 阅读全帖 |
|
s*****p
发帖数: 299 | 4 Given the contents of the raw data file TYPECOLOR.DAT
daisyyellow
the following SAS program is submitted:
data FLOWERS;
infile 'TYPECOLOR.DAT' truncover;
lenth
Type$5
color $11;
input
Type $
Color $;
run;
What is the value of the variables Type and color?
answer: Type=daisy, color=
多谢！！ |
|
b*****e
发帖数: 223 | 5 数据有 500 columns，大多数是 numeric，个别是 char。其实只需要其中十个左右
columns。我想这样弄的，试图把所有 columns 都读成 char，但是不行。有没有什么
好办法？我不想把 char column 一个个人为找出来单独列出来读，因为其实大部分都
用不到。
或者，有什么只读我需要的那些 columns 的读数据的方法?以前没读过这么多列的数据
，没经验
data ALLPAGE;
infile "\....\My Documents\MYDATA.txt" delimiter='09'x
firstobs=4 obs=1410 dsd lrecl=10000 missover;
input COL1-COL500 ; /* 这样 char col 都是空白 */
input COL1-COL500 $ ; /* 这样不行？ */
input COL1-COL222 COL223 $ ..... COLxxx-COL500; /* 嫌麻烦 */
run; |
|
d*******o
发帖数: 493 | 6 data one;
infile whatever;
informat col300-col310 $varying.;
input col1-col500;
run; |
|
d*******o
发帖数: 493 | 7 *****Request: 试图把所有 columns 都读成 char，但是不行。有没有什么
好办法？******;
data one;
infile whatever;
informat col1-col500 $varying.;
input col1-col500;
run;
***Tested**********; |
|
p****8
发帖数: 50 | 8 data WORK.TEST;
drop City;
infile datalines;
input
Name $ 1-14 /
Address $ 1-14 /
City $ 1-12 ;
if City='New York ' then input @1 State $2.;
else input;
datalines;
Joe Conley
123 Main St.
Janesville
WI
Jane Ngyuen
555 Alpha Ave.
New York
NY
Jennifer Jason
666 Mt. Diablo
Eureka
CA
;
What will the data set WORK.TEST contain?
A.
Name Address State |
|
s*********y
发帖数: 34 | 9 ADV -63 :
data temp errors/view=temp;
infile "D:\Hui Documents\STAT 2008\SAS Certificate\advance\Practice data\Q11
.txt";
input Xa Xb Xc;
if Xa=. then output errors;
else output temp;
run;
为什么work.errors有语法错误不能创建? 这个TEMP(view) 和 temp(data)有什么区别? |
|
p********a
发帖数: 5352 | 10 You can do it by SAS
first read the folder name, and you can select all the file names into marco
variables. Then use x command to unzip the files
Use the following to get file names-
%sysexec cd &dir; %sysexec dir *.txt /b/o:n >flist;
data indexfile;
length filen $200 ;
infile "&dir./flist" length=reclen;
input filen $varying256. reclen;
run; |
|
h****w
发帖数: 14 | 11 呵呵，retain貌似是在infile时有用，我现在work里已有样本数据集，想用set或其他
方法来得到新的数据集，retain不行啊...
呵呵，oloolo前辈，其实我就是想做mysas坛子里那个汇率转换问题 |
|
p****8
发帖数: 50 | 12 答案给C， 可我认为是B。把我弄糊涂了！
The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;
Which of the following is true of
the WORK.ERRORS data set?
A.
The data set is created when the
DATA step is submitted.
B.
The data set is created when the view
TEMP is used in another SAS step.
C.
The data set is not cr... 阅读全帖 |
|
m****r
发帖数: 202 | 13 目的是用infile input 输入数据，原始数据在Excel里。
为不影响数据格式，使用方法
1、把Excel另存为CSV 2、SAS import CSV 3、从log里复制input
问题：如何去掉复制后的数字表记例如
172 input
173 Study_Number $
174 Patient_Id $
175 Patient_Study_Id $
176 Visit_Name $
希望把前面的数字172－176去除，请问能否用SAS执行，还是只能手工做？
多谢回复 |
|
r******m
发帖数: 369 | 14 你的第三行第三个数据格式错了吧
data test (drop=i);
infile cards;
input id T1:mmddyy10. T2:mmddyy10. T3:mmddyy10. T4:mmddyy10.;
array T{1:4} T1-T4;
do i=4 to 2 by -1;
if T{i}=T{i-1} then T{i}=.;
end;
format T1-T4 mmddyy10.;
cards;
1 1/1/2011 1/1/2011 3/1/2011 5/1/2011
2 3/1/2009 8/1/2009 8/1/2009 10/1/2009
3 5/1/2008 8/1/2008 5/12008 11/2/2008
run; |
|
p****8
发帖数: 50 | 15 答案给C， 可我认为是B。把我弄糊涂了！
The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;
Which of the following is true of
the WORK.ERRORS data set?
A.
The data set is created when the
DATA step is submitted.
B.
The data set is created when the view
TEMP is used in another SAS step.
C.
The data set is not cr... 阅读全帖 |
|
p****8
发帖数: 50 | 16 答案给C， 可我认为是B。把我弄糊涂了！
The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;
Which of the following is true of
the WORK.ERRORS data set?
A.
The data set is created when the
DATA step is submitted.
B.
The data set is created when the view
TEMP is used in another SAS step.
C.
The data set is not cr... 阅读全帖 |
|
s********p
发帖数: 637 | 17 if you know the layout of this text file, you had better use infile in
datastep to avoid any potential data reading error. |
|
N****n
发帖数: 1208 | 18 .txt file不是用infile来读入的吗？ |
|
a********i
发帖数: 205 | 19 你直接用proc sql调用这个表的话就input(varibale,dateformat，)
如果用infile建立dataset就在input后面加informat就行了 |
|
j*****7
发帖数: 4348 | 20 我的这段小code（把目录下所有的log文件集中起来), 在 Windows下运行没问题， 在
UNIX下就不行了。
filename getdir pipe "dir/b &dirname.*.log";
* Determine total number of LOG files to be processed;
data dirlist;
infile getdir length=len;
length fname $200;
input @;
input @1 fname $varying200. len;
fname=upcase(fname);
if substr(upcase(fname),1,1) in (&fprefix);
run;
是不是这个dir/b 在UNIX下不好使啊？
谢谢了。 |
|
a***r
发帖数: 420 | 21 raw文本是genomestudio产生的final report，text file，20G
用infile，input读入SAS，生成的dataset 30G...
SNP是char变量，还没有code成num，现在是“G G”的形式，所以level要说的话，应该
认为有16个
我原来也怀疑这么大的dataset行不行，因为这个读入就花了4,5个小时，但后来还是硬
着头皮上了
如果需要学习其他的软件来做data management，我也很乐意，但是不知道学什么好？
因为后面还有一个778G的final report，转成dataset380G，我还没有处理 ...
谢谢! |
|
s******y
发帖数: 352 | 22 you need to specify option DSD in your infile statement. by default, the
double quotation marks will be stripped off. in order to retain the
quotation marks as part of the value, use the tilde (~) format modifier in
an INPUT statement.
08
commas. |
|
d*******o
发帖数: 493 | 23 data have;
infile datalines dlm = ',';
retain row;
input myvar $ @@ ;
if prxmatch("/10\d/", myvar) ne 0 then row +1;
if missing(myvar) then delete;
datalines;
100, Grace, 3,1,5,2,6
101, Martin, 1,2,4
102, Scott, 9,10,4,
5, 6
103, Bob,2 ,1, 2, 2,4
;
run;
proc transpose data=have out=want(drop = row _name_);
by row;
var myvar;
run; |
|
s******y
发帖数: 352 | 24 DATA HAVE;
INFILE CARDS TRUNCOVER;
INPUT A B C D;
ROWID=_N_;
CARDS;
1
7
3 3
2 5
. 5
. 5 3
. . 4 5
. . 5 8
. . 2 3
. . . 1
;
RUN;
PROC TRANSPOSE DATA=HAVE OUT=HAVE1(WHERE=(NOT MISSING(COL1)));
BY ROWID;
VAR A B C D;
RUN;
PROC SORT DATA=HAVE1;
BY _NAME_ ROWID;
RUN;
DATA HAVE2;
SET HAVE1;
BY _NAME_;
ID+1-(FIRST._NAME_)*ID;
RUN;
PROC SORT DATA=HAVE2;
BY ID _NAME_ ;
RUN;
PROC TRANSPOSE DATA=HAVE2 OUT=WANT(DROP=_NAME_ ID);
BY ID ;
VAR COL1;
ID _NAME_;
RUN; |
|
h****y
发帖数: 14 | 25 最近刚开始研究SAS
问题非常非常NC
刚开始混MIT，不知道啥是包子。。。也没得送了。。额。好心人路过帮我一下吧
数据两个observations：
Adriana 21 3/21/2000 MP 7
Nathan 14 3/21/2000 CD 19
我打算把日期作为字符变量读入：
data class;
infile 'XXXXX';
input name $ number date $9. type id;
Proc Print data = class;
run;
我的问题是那个日期不就是9位嘛？为什么我用“date $9.”数据就总读乱；
如果我改成 “date $10.”就没问题了。
为啥会酱紫哩？ |
|
o****o
发帖数: 8077 | 26 libname y "c:";
%let path=%sysfunc(pathname(y));
filename getfiles pipe "dir/b /on &path.mas_*.sas";
data filenams;
infile getfiles length=l end=eof;
length filename $200;
input @;
input @1 filename $varying200. l;
filename=upcase(filename);
if eof then put filename=;
run; |
|
D******n
发帖数: 2836 | 27 create a .vim directory under you home directory(there is a dot before
vim)
and then create a syntax directory under it
and then create a sas.vim file under the syntax directory
==============sas.vim======================
if version < 600
syntax clear
elseif exists("b:current_syntax")
finish
endif
syn case ignore
syn region sasString start=+"+ skip=+\\|\"+ end=+"+
syn region sasString start=+'+ skip=+\\|\"+ end=+'+
" Want region from 'cards;' to ';' to be captured (Bob Heckel)
sy... 阅读全帖 |
|
k*******a
发帖数: 772 | 28 data a;
infile datalines missover;
input x y;
datalines;
1 1
2 3
3 5
4 7
5
6
7
8
9
10
;
run;
proc sql;
create table b as
select x as z
from a
where x not in (select y from a);
quit;
data a;
merge a b;
run;
proc print data=a;run; |
|
b******y
发帖数: 499 | 29 base 123里第29题：
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;
input NumEmployees;
run;
How many raw data records are read during each iteration of the DATA step?
A. 1
B. 2
C. 3
D. 4
答案是B，为什么呢？是哪两条RECORDS? |
|
b******y
发帖数: 499 | 30 我也是这么想的，可是又看见另一道题跟这个基本一样，但是答案却是A。请问这两道
题差别在那里？
The following SAS program is submitted:
data numrecords;
infile 'file-specification';
input @1 patient $15.
relative $ 16-26 @;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15.
clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step
during execution?
A. 1
B. 2
C. 3
D. 4
City and Year both, from the same record, de... 阅读全帖 |
|
o**********a
发帖数: 330 | 31 我有个space.dat的文件，内容如下：
fafa fafa 232
efaf llfji 45
我用如下方法想把它读到sas里面，总是不成功，请高手指教
data a;
infile 'E:\Programming_Practice\sas\Read_DAT\space.dat';
input name $ 1-4
gender $ 6-10
num 12-14;
run;
proc print data=a;
run;
这样只读出 了第一条记录，第2条没读进来 |
|
t*****d
发帖数: 131 | 32 我想读入一组数据，用了以下的code，但是有错运行不了，想请问下大家该怎么改才能
把中间的引号去掉并正确读入数据呢？最近刚开始学sas，好多东西弄不太明白，谢谢
大家了！
data list;
infile datalines;
input id height weight;
datalines;
"1" "68" "144"
"2" "78" "202"
;
run; |
|
s*********r
发帖数: 909 | 33 infile datalines dlm='" "'; |
|
t*****2
发帖数: 94 | 34 ID Name Sex Age Date Height Weight ActLevel Fee
2458 Murray, W M 27 1 72 168 HIGH 85.2
2462 Almers, C F 34 3 66 152 HIGH 124.8
There is an embeded comma in the names. I tried many input methods, but it
still didn't work. Can anybody help me out here?
The code I used:
DATA newadmit;
INFILE 'C:\Users\labuser\Desktop\newadmit.txt' FIRSTOBS = 2 OBS = max;
INPUT ID 1-4 Name : $40. Sex $ 26 Age Date Height Weight ActLevel ... 阅读全帖 |
|
o**********a
发帖数: 330 | 35 我有个present.dat如下
Adams F 2
Lincoln R 16
Grant R 18
Kennedy D 35
用下列方法
data a;
infile 'E:\Programming_Practice\sas\Read_DAT\prisent.dat';
input name $ 1-7 femail $ 9 age 11-12;
run;
proc print data=a;
run;
为什么每次运行数据都不能准确读出来呢 |
|
h********o
发帖数: 103 | 36 DATA TEST;
INFILE CARDS DLM = ",";
INPUT FNAME $ LNAME $ BIRTH $ 23-30 PHONE $ 31-40;
CARDS;
SMITH ,BOB 01/03/668845333883
JACKSON ,ANDREW 03/09/779917736612
ALICE ,KIM 02/24/542243226673
;
PROC PRINT DATA = TEST NOOBS;
RUN;
===========================================================
FNAME LNAME BIRTH PHONE
SMITH BOB 01/03/66 8845333883
JACKSON ANDREW 03/09/77 9917736612
... 阅读全帖 |
|
u*********r
发帖数: 1181 | 37 在run 一个程序，用csv 文件读入数据
但是 发现程序隔行读数据，本来灭个变量有24个数据，最后读了12个
不晓得发生什么问题，我是SAS 蝌蚪
请大牛指教
现贴开始的一段code
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile 'k:\Kaiwang\run20\run20.CSV' delimiter = ',' firstobs=2 dsd ;
informat LVCYP1A1 best32. ; |
|
s******r
发帖数: 1524 | 38 data test;
LENGTH key1 8 key2 8 id1 8 id2 8;
FORMAT key1 BEST6. key2 BEST6. id1 $19. id2 $19.;
INFORMAT key1 BEST6. key2 BEST6. id1 $19. id2 $19.;
INPUT key1 : BEST6. key2 : BEST3. id1 : $19. id2 : $19.;
INFILE datalines DLM='7C'x MISSOVER DSD;
datalines;
18949|21|1942303098494173209 |1368841116323724091
;
run; |
|
h********o
发帖数: 103 | 39 You can use character instead:
Suppose your text file have a numeric value: 123456789012345678
====================
data test;
infile "h:\test.txt";
input score : $18.;
run;
proc print data = test;
run;
=====================
Obs score
1 123456789012345678 |
|
p********a
发帖数: 5352 | 40 Assume you are using Windows system. Here is an example
%let dir=c:\test;
libname dict "&dir.";
%sysexec cd &dir; %sysexec dir * /b/o:n >flist;
data indexfile;
length filen $200 ;
infile "&dir./flist" length=reclen;
input filen $varying256. reclen;
run;
data indexfile;
set indexfile;
length type $5;
dataname=upcase(scan(filen,1,'.'));
if find(dataname,'RXCLAIMS') then type='RX';
if find(dataname,'MEDCLAIMS') then type='MED';
if find(dataname,'DM_MEMBER') then type='MBR';
if find(dataname,'ENROL... 阅读全帖 |
|
n****o
发帖数: 1167 | 41 用infile，但不知道input哪些variable，求教 |
|
p********r
发帖数: 1465 | 42 要用SAS读取一个很大的CSV文档，我猜里面有些中文或者日文之类的记录，SAS是英文
版的读不出来，反而影响了数据的读取。我想请教这种情况应该如何处理啊？
（我就是用data infile input做的。）
多谢了 |
|
t******m
发帖数: 58 | 43 郁闷了。。楼上2为大虾的办法我之前都尝试过，都不行，sex都是missing的。我现在
贴点code出来，恳请大虾继续指点。。。
OPTIONS LS=132 PS=10000 NOCENTER;
/*
Fromat
DIN=DIN
CD=Claim Date
DS=Days Supply
NU=Number of Units
UP=UNIT_PRICE
ICP=Ingredient Cost Paid
DFP=Dispensing Fee Paid
TAP=Total Amount Paid
RPS=Random Pharmacy Store
RPN=Random Patient Number
PDOB=Patient DOB
PG=Patient Gender
*/
data f1;
/*INFORMAT CD YYMMDD13.2; FORMAT CD YYMMDD10.;
INFORMAT PDOB YYMMDD13.2; FORMAT PDOB YYMMDD10.;*/
INFORMAT UP ICP DFP TAP DOLLAR7.2; FORMAT UP ICP DFP... 阅读全帖 |
|
l***i
发帖数: 8 | 44 The contests of the raw data file Product are listed below;
----|----10--
2461 $25.31
The following sas program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the price variable?
A. 25.31
B. $25.31
C. .(missing numeric vales)
D. No value is stored as the program fails to excute due to errors.
The Answer:C
我不太明白为什么是C这个答案，price是从第十个位置开始读的，那么读出来的结果应
该是.31。但是答案中没有这个答案。 |
|
t*****2
发帖数: 94 | 45 QUESTION
A raw data file is listed below:
---|---10---|---20---|----30
John McCloskey 35 71
June Rosesette 10 43
Tineke Jones 9 37
The following SAS program is submitted using the raw data file as input:
data work.homework;
infile 'file-specification';
input name $ age height;
if age LE 10;
run;
How many observations will the WORK.HOMEWORK data set contain?
A. 0 B. 2 C. 3
为什么答案是3个呢？我觉得读数据的时候就应该会出现ERROR呀， 即便不出现问题，
也只可能是2个呀。
求赐教！ 先谢谢了！ |
|
l***i
发帖数: 8 | 46 Item 17 of 70 Mark item for review
Given the following data step:
data WORK.GEO;
infile datalines;
input City $20.;
if City='Tulsa' then
State='OK';
Region='Central';
if City='Los Angeles' then
State='CA';
Region='Western';
datalines;
Tulsa
Los Angeles
Bangor
;
run;
After data step execution, what will data set WORK.GEO contain?
The Answer is :
A.
City State Region
----------- ----- -------
Tulsa OK Wes... 阅读全帖 |
|
t*****2
发帖数: 94 | 47 Data(employee) 如下：
ruth 39 11
jose 32 22
sue 30 33
john 40 44
输入以下程序：
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name='ruth' then input idnum 10-11;
else input age 7-8;
run;
Which one of the following values does the variable AGE contain when the
name of the employee is "sue"?
A 30 B 33 C 40 D missing numeric value
搞不清楚为什么答案是 C 呢。
请大家帮忙想想。
在这里先谢谢了。 |
|
l***i
发帖数: 8 | 48 The following SAS program is submitted:
data test;
set sasuser.employees;
if 2 le years_service le 10 then amount=1000;
else if years_service gt 10 then amount=2000;
else amount=0;
amount_per_year=years_service/amount;
run;
Which one of the following values does the variable Amount_per_year contain
if an employee has been with the company for one year?
A.0
B. 1000
C.2000
D.(missing numeric value)
Why the answer is C? I can not understand. Can any body explain to me why?
Thanks!
#################... 阅读全帖 |
|
o*******w
发帖数: 2310 | 49 很多都是故意弄陷阱,治马虎人.
很象国内的某些人出的,估计是华人出的.
当然,很有必要.
例子: The following SAS program is submitted:
data employees;
infile 'file-specification';
input @1 name $10.
@15 date date9
@25 department $;
run;
How many numeric variables are created?
a. 0
b. 1
c. 2
d. 3
data work.staff;
JobCategory = 'FA';
JobLevel = '1';
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?
A. FA
B. FA1
C. FA 1
D. ' ' (missing... 阅读全帖 |
|
o*******w
发帖数: 2310 | 50 A raw data file is listed below.
----|----10---|----20---|----30
son Frank 01/31/89
daughter June 12-25-87
brother Samuel 01/17/51
The following program is submitted using this file as input.
data work.family;
infile file-specification;
run;
Which INPUT statement correctly reads the values for the variable BIRTHDATE
as SAS date values?
A. input relation $ first_name $ birthdate date9.;
B. input relation $ first_name $ birthdate mmddyy8.;
C. input relation $ first_na... 阅读全帖 |
|
