[問題]SAS讀取資料問題
我是SAS新手 現在我想把excel檔讀進去SAS中 但我總共有255欄要讀進去
filename bk11 dde 'excel|D:\123\bank1.xls!r3c1:r557c26';
filename bk12 dde 'excel|D:\123\bank1.xls!r3c27:r557c52';
filename bk13 dde 'excel|D:\123\bank1.xls!r3c53:r557c78';
filename bk14 dde 'excel|D:\123\bank1.xls!r3c79:r557c104';
filename bk15 dde 'excel|D:\123\bank1.xls!r3c105:r557c130';
filename bk16 dde 'excel|D:\123\bank1.xls!r3c131:r557c156';
filename bk17 dde 'excel|D:\123\bank1.xls!r3c157:r557c182';
filename bk18 dde 'excel|D:\123\bank1.xls!r3c183:r557c208';
filename bk19 dde 'excel|D:\123\bank1.xls!r3c209:r557c234';
filename bk110 dde 'excel|D:\123\ank1.xls!r3c235:r255c';
做完這個動作後 我將這些檔案合併成bk1
之後就是主要問題所在了
總共有255欄 但是我要的只有其中幾個變數 假如255欄中
我只要 code name shortloan debt asset 這幾個column 那我該如何做呢
code date season stinv dlinv liqasset loan ....
2801 200303 1 71715752 0 360465991 764083049
2801 200306 2 60583772 0 357447074 788755947
2801 200309 3 51588029 0 412943119 770355726
2801 200312 4 210608111 0 423526914 832747979
2801 200403 1 195478391 0 377261857 850253739
2801 200406 2 179920914 0 357672408 875206274
2801 200409 3 191285878 0 363847025 877081406
像這樣的原始data 共255欄
請大大幫幫忙@@..
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.127.20.236
→
08/24 00:03, , 1F
08/24 00:03, 1F
→
08/24 00:17, , 2F
08/24 00:17, 2F
→
08/24 00:19, , 3F
08/24 00:19, 3F
→
08/24 00:19, , 4F
08/24 00:19, 4F
→
08/24 00:20, , 5F
08/24 00:20, 5F
→
08/24 09:19, , 6F
08/24 09:19, 6F
→
08/24 09:20, , 7F
08/24 09:20, 7F
→
08/24 09:20, , 8F
08/24 09:20, 8F
→
08/26 15:17, , 9F
08/26 15:17, 9F
→
08/26 17:29, , 10F
08/26 17:29, 10F
→
08/26 17:30, , 11F
08/26 17:30, 11F
→
08/28 01:18, , 12F
08/28 01:18, 12F
→
01/02 14:57,
7年前
, 13F
01/02 14:57, 13F