p**5 发帖数: 2544 | |
w****a 发帖数: 114 | |
d*******o 发帖数: 493 | 3 Transforming Excel to CSV , tab-delimited text or fixed-width text may be a
good option. You will have more control over there. |
p**5 发帖数: 2544 | 4 obs=5 是不是读取5个obs?
datarow = 5 ?
【在 w****a 的大作中提到】 : obs=5
|
p**5 发帖数: 2544 | 5 谁能看看这个error?谢谢
191
192 PROC IMPORT OUT= WORK.text
193 DATAFILE= "D:\Journal\2009_IF.xls"
194 DBMS=EXCEL REPLACE;
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
195 GETNAMES=NO;
NOTE: The previous statement has been deleted.
196 DATAROW=5;
-------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
197 MIXED=NO;
198 SCANTEXT=YES;
199 USEDATE=YES;
200 SCANTIME=YES;
201 RUN;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 second |
d**********r 发帖数: 24123 | 6 Excel import dont have that ability. You have to save as csv or remove the
rows yourself. |
p**5 发帖数: 2544 | 7 okay, I believe you. Thanks for all replies.
but what is the function of "DATAROW =" option?
【在 d**********r 的大作中提到】 : Excel import dont have that ability. You have to save as csv or remove the : rows yourself.
|
d**********r 发帖数: 24123 | 8 Datarow = is the starting row of import, but EXCEL import (DBMS=EXCEL) do
not allow this option.
Instead, you can use XLS import (DBMS=XLS) and use option
startrow=
endrow=
【在 p**5 的大作中提到】 : okay, I believe you. Thanks for all replies. : but what is the function of "DATAROW =" option?
|
p**5 发帖数: 2544 | 9 Thanks again.
【在 d**********r 的大作中提到】 : Datarow = is the starting row of import, but EXCEL import (DBMS=EXCEL) do : not allow this option. : Instead, you can use XLS import (DBMS=XLS) and use option : startrow= : endrow=
|
k*****u 发帖数: 1688 | 10 re
这个菜靠谱
我一次也琢磨这个好久
【在 d**********r 的大作中提到】 : Datarow = is the starting row of import, but EXCEL import (DBMS=EXCEL) do : not allow this option. : Instead, you can use XLS import (DBMS=XLS) and use option : startrow= : endrow=
|