SAS中文论坛
标题:
sas导入数据时如何可以跳过不想导入的数据列
[打印本页]
作者:
shiyiming
时间:
2007-11-14 16:48
标题:
sas导入数据时如何可以跳过不想导入的数据列
我要将txt文件导入sas，由于后面有些列的中文有乱码，总是读到有乱码的地方就停下了，比如该文件共有1000行，第50行第60列的中文乱码，则导成的sas数据是50行。
由于我要的变量都不存在中文列，所以我想能不能跳过这些中文列，直接读入下一行呢？
我的code如下
[code:3qftdi43]
filename data 'e:\txtdata\B10311000H00012005032011000.txt';
data temp;
infile data lrecl = 1000 firstobs = 3;
input v3 $ 6-19 v5 $ 21-22 v6 $ 23-62 v7 $ 63-68 v8d $ 69-76
v9d $ 77-84 v11n $ 88-97 v14 $ 118 v15 $ 119-120 v16n $ 121-123
v17n $ 124-126 v18d $ 127-134 v19d $ 135-142 v21n $ 153-162 v22n $ 163-172
v23n $ 173-174 v24n $ 175-184 v25n $ 185-194 v26n $ 195-204 v27n $ 205-214
v28n $ 215-224 v29n $ 225-227 v31n $ 230 v32 $ 231;
run;
[/code:3qftdi43]
有中文的是在231列后面，所以有办法我每一行只读到231列就停止然后去下一行么？
否则我要一个一个改乱码，很多文件。
多谢
作者:
shiyiming
时间:
2007-11-15 13:52
标题:
Re: sas导入数据时如何可以跳过不想导入的数据列
传2行数据上来看看呢
作者:
shiyiming
时间:
2007-11-15 14:09
标题:
Re: sas导入数据时如何可以跳过不想导入的数据列
我paste一行有问题的数据，sas读到这一行就不往下读了，
[quote:399wo9fe]0983AB20325840B0001111476690000100037585 4403011999122420191224CNY000075000000007500000000750000203240178200503192005031900000026370000002637000032439000000000000000000000000000000000000000000000000000000020211NNN*NNNNNNNNNNNNNNNNNNNN00000000001 0440301630717295 B11901010110209 0 振华路芊雅阁１Ａ＊ B区 C栋 406407 518017０ C4深圳 Z深圳市文锦 518000 120000000000 D０ 5180172
[/quote:399wo9fe]
出问题的就是
[quote:399wo9fe]406407 [/quote:399wo9fe]
这个箭头在原始数据中是个方框框，还有其他的中文乱码等
多谢
作者:
shiyiming
时间:
2007-11-15 16:19
标题:
Re: sas导入数据时如何可以跳过不想导入的数据列
我用你的程序读了你贴出的一行记录，貌似没有问题啊？
作者:
shiyiming
时间:
2007-11-15 17:28
标题:
Re: sas导入数据时如何可以跳过不想导入的数据列
因为数据太长，我只贴了有问题的一行，sas读到这里就停下来了。后面的obs就不读了
我刚才找了个人解决了这个问题，但是新问题又有了
用infile data recfm = f lrecl = 985;就可以忽略那些乱码，但是由于数据中有些行不足983的字节，或多于983个字节，这样又不行了。
我来paste一下多行的数据看能不能行
[quote:1pr6anld]0983AB20325840B0001111476690000100037469 4403011999122420091224CNY000032000000003200000000320000903120057200503242005012400000034460000000000000018125003000000795200000026560000002628000000000000000000000141422NNNNNNNNNNNNNNNNNNNNN3210000000000 0440301660103581 B11901010110209 0 深圳湾汇景花园海逸阁１５Ｂ＊ 518053０ C4深圳市华侨城华清美容美发院 Z０ 518000 120000000000 D０ 5180532
0983AB20325840B0001111476690000100037472 4403011999122420191224CNY000017000000001700000000170000903240177200503242005032400000011520000001152000014119700000000000000000000000000000000000000000000000000000010111NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0650105691217192 B21901010110209 0 水径村中海怡翠山庄１０－２－１Ａ＊ 518049０ C4深圳市中美企业家交流协会 Z０ 518000 120000000000 D０ 5180492
0983AB20325840B0001111476690000100037483 4403011999122420141224CNY000078000000007800000000780000903156093200503252005032500000062670000006267000047701300000000000000000000000000000000000000000000000000000040411NNNNNNNNNNNNNNNNNNNNNNNN0000000000 2G140811(8) B11901010140209 2 深圳湾汇景花园海典阁８Ａ＊ 999999深圳 C4高星科技有限公司 Z中国东莞塘厦镇石潭埔 518000 120000000000 D深圳市福田区彩男南路海滨广场福家 5180002
0983AB20325840B0001111476690000100037494 4403011999122420071224CNY000006000000000600000000060000903096033200503242005032400000007690000000769000002357400000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 2D261209(8) B21901010190999 香港鲷鱼涌海湾街 2号 3/F 999999暂缺 暂缺 X暂缺 CZ暂缺 Z香港铜锣湾时代广场 B201 999999 990000000000 D香港鲷鱼涌海湾街 2号 3/F 9999992
0983AB20325840B0001111476690000100037538 4403011999122420191224CNY000018000000001800000000180000903240177200503242005032400000012200000001220000014950200000000000000000000000000000000000000000000000000000010111NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0360111681102005 B1196811022020928530838 13808853637 水径村中海怡翠山庄１２－７Ｆ＊ 518001０ 暂缺 X暂缺 C4深圳义达会计师事务所 Z０ 518000 190000120000 D福田区深南大道北侧浩铭财富广场Ａ－５Ｅ 5180011
0983AB20325840B0001111476690000100037549 4403011999122420061224CNY000016000000001600000000160000903084021200503242005032400000044680000004468000004577600000000000000000000000000000000000000000000000000000010121NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0440204660226332 B2190101014020982230013 83407606 水径村中海怡翠山庄８－３－６Ｂ＊ 518000０ C4深圳中国长城计算机股份有限公司 Z深圳科技园长城大厦 518000 120000000000 D０ 5180002
0983AB20325840B0001111476690000100037552 4403011999122420091224CNY000022000000002200000000220000203120057200503242005032400000023690000002369000011914200000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0430503760106002 B21901010110209 0 坂田村五合大道万科四季花米兰Ｊ３０２＊ 518048０ C4深圳市华为集成电路设计有限公司 Z福田区车公庙 518000 120000000000 D万科四季花城米兰苑Ｆ座３０２＃ 5181292
0983AB20325840B0001111476690000100037585 4403011999122420191224CNY000075000000007500000000750000203240178200503192005031900000026370000002637000032439000000000000000000000000000000000000000000000000000000020211NNN*NNNNNNNNNNNNNNNNNNNN0000000000 0440301630717295 B11901010110209 0 振华路富怡雅居芊雅阁１Ａ＊ B区 C栋 406407 518017０ C4深圳海关走私犯罪侦查分局 Z深圳市文锦渡过海关办公楼 518000 120000000000 D０ 5180172
0983AB20325840B0001111476690000100037618 4403011999122420191224CNY000086000000008600000000860000203240177200503242005032400000058280000005828000071428900000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0440301681005291 B11901010110209 0 振华路富怡雅居芊雅阁１１Ｄ＊ 518000０ C4深圳市粤华企业公司 Z０ 518000 120000000000 D０ 5180002
0983AB20325840B0001111476690000100037629 4403011999122420191224CNY000093000000009300000000930000203240177200503242005032400000063020000006302000077242900000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0420107600118101 B11901010110209 0 振华路富怡雅居ＦＡＮ雅阁８Ｆ＊ 518035０ C4深圳市珞珈投资咨询有限公司 Z０ 518000 120000000000 D０ 5180352aaaaaaaaa
0983AB20325840B0001111476690000100037654 4403011999122420191224CNY000059000000005900000000590000203240177200503242005032400000062000000006200000049003600000000000000000000000000000000000000000000000000000050521NNNNNNNNNNNNNNNNNNNNNNNN0000000000 04403011972013180 B21901010110209 0 振华路富怡雅居ＦＡＮ雅阁１Ｃ＊ 1-712号 999999０ C4深圳市黄贝岭靖实业股份有限公司 Z深圳市深南东路 518000 120000000000 D０ 5180002
0983AB20325840B0001111476690000100037676 4403011999122720061227CNY000027000000002700000000270000203084021200503272005030900000038600000004200000008358702000000634100000028390000000000000000000000000000000141422NNNNNNNNNNNNNNNNNNNNNN210000000000 2E171083 8 B1190101011020928779175 0 坂田村五合大道万科四季花城杜鹃３Ｌ１０１＊ 999999０ C4长沙湾广场 Z０ 518000 120000000000 D０ 5180002
0983AB20325840B0001111476690000100037687 4403011999122720091227CNY000024000000002400000000240000203120057200503272005032700000025850000002376000013123601000000126600000000000000000000000000000000000000000040422NNNNNNNNNNNNNNNNNNNNNNN10000000000 0430219680403160 B21901010110209 0 坂田村五合大道万科四季花城牡丹７Ｆ３０１＊ 518003００ C4市广利恒投资有限公司 Z０ 518000 120000000000 D０ 5180032
0983AB20325840B0001111476690000100037698 4403011999122720141227CNY000029000000002900000000290000203180117200503272005032700000023420000002342000021357900000000000000000000000000000000000000000000000000000010121NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0210221700713074 B21901010110209 0 坂田村五合大道万科四季花城海棠２Ｅ５０２＊ 518002０ C4深圳市鑫宝殿珠宝首饰有限公司 Z０ 518000 120000000000 D０ 5180022
0983AB20325840B0001111476690000100037709 4403011999122720141227CNY000021000000002100000000210000203180117200503272005032700000016960000001696000015466100000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0432621700423001 B11901010110209 0 坂田村五合大道万科四季花城牡丹苑６Ｖ３０２＊ 518029０ C4深圳市万科房地产有限公司 Z红岭中路荔景大厦九楼 518000 120000000000 D八卦岭一路鹏盟村九栋 5180292
0983AB20325840B0001111476690000100037712 4403011999122720191227CNY000028000000002800000000280000203240177200503272005032700000018970000000524000023341901000000086500000000000000000000000000000000000000000101022NNNNNNNNNNNNNNNNNNNNNNN10000000000 0440301700809231 B11901010110209 0 坂田村五合大道万科四季花城紫薇苑９Ａ４０２＊ 999999０ C4深圳市公安局罗湖巡警大队九中队 Z深圳市莲塘西岭下罗湖巡警九中队 518000 120000000000 D０ 5180002
0983AB20325840B0001111476690000100037767 4403011999122720141227CNY000019000000001900000000190000203180117200503272005032700000015350000001535000013993100000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0420202620919004 B21901010110209 0 坂田村五合大道万科四季花城紫薇９Ｄ１０１＊ 518038０ C4深圳市教育学院附中 Z深圳市益田村教院附中初中部 518000 120000000000 D０ 5180382
0983AB20325840B0001111476690000100037836 4403011999122720191227CNY000020000000002000000000200000203240177200503272005032700000013550000001355000016611000000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0510211700818002 B21901010110209 20 坂田村五合大道万科四季花城牡丹７Ｆ１０２＊ 999999００ C4深圳市金翼实业股份有限公司 Z０ 518000 120000000000 D０ 5180002
0983AB20325840B0001111476690000100037847 4403011999122720141227CNY000019000000001900000000190000203180117200503272005032700000015350000001535000013993100000000000000000000000000000000000000000000000000000010111NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0352225690205001 B11901010110209 0 坂田村五合大道万科四季花城海棠１Ｒ２０２＊ 518031０ C4深圳新宝景消防化工有限公司爱华电 Z脑配套市场展销部 518000 120000000000 D０ 5180312
0983AB20325840B0001111476690000100037858 4403011999122720191227CNY000027000000002700000000270000203240177200503272005032700000018300000001830000022424800000000000000000000000000000000000000000000000000000010111NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0360102731110381 B11901010110209 20 坂田村五合大道万科四季花城海棠２Ｈ３０１＊ 518001０ C4中国对外建设深圳园林设计公司 Z０ 518000 120000000000
0983AB20325840B0001111476690000100037869 4403011999122720191227CNY000021000000002100000000210000203240177200503272005032700000014230000001423000017441500000000000000000000000000000000000000000000000000000020221NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0430404721116101 B11901010110209 13008859356 0 坂田村五合大道万科四季花城海棠１Ｊ４０１＊ 518048０ C4深圳永华液压器材有限公司 Z０ 518000 120000000000 D０ 5180482
0983AB20325840B0001111476690000100037872 4403011999122720191227CNY000030000000003000000000300000203240177200503272005032700000020330000002033000024916500000000000000000000000000000000000000000000000000000000011NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0440301560526231 B11901010110209 20 暂缺 999999０ C4深圳市恒耀电器设备有限公司 Z深圳市福田区振兴路华匀大厅首层 518000 120000000000 D０ 5180402
0983AB20325840B0001111476690000100037894 4403011999122720191227CNY000019000000001900000000190000203240177200503272005032700000024800000002480000015780400000000000000000000000000000000000000000000000000000010121NNNNNNNNNNNNNNNNNNNNNNNN0000000000 0430103720314203 B11901010110209 0 坂田村五合大道万科四季花城牡丹７Ａ５０１＊ 410007０ C4湖南省电视制作中心 Z０ 518000 120000000000 [/quote:1pr6anld]
我把数据中名字去掉了，应该只剩968个字节
因为数据量太大，实在手工太麻烦，要不就手工删了
多谢多谢啊
作者:
shiyiming
时间:
2007-11-15 17:52
标题:
Re: sas导入数据时如何可以跳过不想导入的数据列
哦，这个问题我曾经碰到过，算你走运咯，哈哈哈。 <!-- s8) --><img src="{SMILIES_PATH}/icon_cool.gif" alt="8)" title="Cool" /><!-- s8) -->
[code:34jo4exc]infile data lrecl = 1000 IGNOREDOSEOF;[/code:34jo4exc]
作者:
shiyiming
时间:
2007-11-16 09:12
标题:
Re: sas导入数据时如何可以跳过不想导入的数据列
以后我管你叫老大了啊
真是太感谢了，我google, baidu了一天多呢，
多谢多谢，有机会请你吃饭啊
<!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D --> <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D --> <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D --> <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D --> <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D --> <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D -->
欢迎光临 SAS中文论坛 (https://mysas.net/forum/)
Powered by Discuz! X3.2