作者mkj (shadow )
看板Statistics
標題[問題] CSV匯入sas的問題
時間Mon Sep 28 19:36:31 2009
我將csv檔匯入sas
macro aa(i);
data HY.a&i.2005; infile "C:\Yan\031ai-x 037aa-an
2006,2005\I2009080013_037.c_a&i..csv" lrecl=300 missover ;
input HOSP_ID $ 2-11 HOSP_DATA_TYPE $ 15-16 FEE_YM 19-24 APPL_TYPE 27
CASE_TYPE $ 31-32 SEQ_NO 35-44 FUNC_TYPE $ 31-32
但是log顯示如下 (不過用一樣的方法做了幾十個檔 只有他有問題)
後來查了一下 在infile後面加了termstr=CRLF 還是一樣沒有改善
請問我該如何改好呢 有點緊急 謝謝 m(_ _)m
NOTE: Invalid data for HOSP_CNT_TYPE in line 247978 249-249.
NOTE: Invalid data for AREA_NO_HOSP in line 247978 253-256.
NOTE: Invalid data for AREA_NO_BASINS in line 247978 260-263.
NOTE: Invalid data for SEXAGE in line 247978 266-271.
NOTE: Invalid data for INS_AMT in line 247978 279-289.
NOTE: Invalid data for ID_SEX in line 247978 268-268.
NOTE: Invalid data for area_no in line 247978 253-254.
RULE:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
247978 "N06&Eg&cDx","12",200503,"1","04", 14753,"AB
",20050314,20050314,19261016,"5/ c*IMw@
101 E","40290 ","2720 ","43310 ",
$rr}j..tMEREE...Fj8.6*0)e:a$i5hp&'7`!2
ZONE
4222333332222222222222333322222222222222333332222222222222222227776107445440114631323263626367223623
NUMR
52C24029000000000002C22720000000000002C24331000000000002C00000422DA604D525553C6A856A095A149580677012
201 p6( hs;h.E..||"%.s:s..]t..WUF.._ED. %
0dk.~..vAGFVU...Po3.+(<)e+q3p9jc7V%`#"r:( yj)x.o.](.#L.yX>
ZONE
7322673604117722773700570055410544022222223667711744455111563122326273736635262273227627161520241753
NUMR
068083B8755BCC25F3A371D4E075654F54E000500004BFE826176654100F34B8C95B1309A37650322A809A987F7D8B3CE98E
HOSP_ID=N06&Eg&cDx HOSP_DATA_TYPE=12 FEE_YM=200503 APPL_TYPE=1 CASE_TYPE=04
SEQ_NO=14753 FUNC_TYPE=04 FUNC_DATE=*********
CURE_E_DATE=20050314 ID_BIRTHDAY=********* ID=5/ c*IMw@E ICD9_1=402
ICD9_2=272 ICD9_3=433 ICD9CM_CODE=40290 ICD9CM_CODE1=2720
ICD9CM_CODE2=43310 DRUG_DAYS=$rr}j DRUG_DOT= tMEREEAPPL_DOT=s:s
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.116.61.214
1F：→ kingbee:用infile 並非正確用法呢 那是匯入無格式資料用 09/29 09:34
2F：→ kingbee:你用excel檔因該是用import 或是 libname 方式 09/29 09:34