关于input 语句 列指针 语法问题，恳请帮助

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

@400000004faa61e21e8e3e24       starting delivery 1820: msg 850901 to remote sunkang@189.cn


需要对以上的观测值提取邮件地址，我一开始用以下代码：

data a;

infile 'C:\Users\SHUO LIU\Desktop\maillog.txt';

input @'starting delivery ' + 28 email:$50;

run;

proc print;

run;

[backcolor=rgba(0, 0, 0, 0)]我的思路一开始是看到starting delivery 是目标邮件的关键词，所以就使用指针，找到starting delivery 后，再往右 加28个字符就是email address了，但是似乎是失败的代码，出来的变量email 是 'm'。  

后来用了以下语法就正确了：

input @' delivery ' id 4. @":" status $ massage & $50. ;

所以我的问题是： 首先告诉程序找到‘delivery’ 这个关键词之后一定要定义一个变量么？ @ delivery 后定义变量id, 而我是找到delivery之后再将指针往右28然后再定义第一个变量， 是不是后者语法上有错误？

万分感谢！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Input 语法问题 put Delivery Starting starting

下面这个是可以的：

1. data a;
   
2. infile cards truncover;
   
3. input @"starting delivery" +28 email $100.;
   
4. /*input @"remote "+1 massage: $50. ;*/
   
5. cards;
   
6. starting delivery 1820: msg 850901 to remote sunkang@189.cn
   
7. ;
   
8. run;
   
9. proc print;
   
10. run;

复制代码

多谢回复，但是您知道我的语法有什么错误么？

你的第一段代码我用了也是出来对的结果啊。。 是不是”input @'starting delivery ' + 28 email:$50;“ 这段中”$50“ 如果是”$50." 运行结果就是一样的

Starkville 发表于 2015-12-22 15:39
你的第一段代码我用了也是出来对的结果啊。。 是不是”input @'starting delivery ' + 28 email:$50;“ 这段 ...

请看附件，如果我用你的代码，然后读取附件里的数据，

data a;
infile 'C:\Users\SHUO LIU\Desktop\maillog.txt';
input @"starting delivery" +28 email $100.;
run;
proc print;
run;

出来的结果是

1 @400000004faa61e21e8e420c status: local 0/10 remote 8/20
2 @400000004faa61e31e92d9d4 status: local 0/10 remote 9/20
3 @400000004faa61e4202db584 status: local 0/10 remote 10/20
4 @400000004faa61e5201dbbac status: local 0/10 remote 10/20
5 @400000004faa61e621225a6c status: local 0/10 remote 9/20
6 @400000004faa61e721d86fb4 status: local 0/10 remote 7/20
7 @400000004faa61e725ed4ffc status: local 1/10 remote 6/20
8 @400000004faa61e82180ca34 status: local 0/10 remote 6/20
9 @400000004faa61e92467446c status: local 0/10 remote 6/20
10 @400000004faa61ea226f643c status: local 0/10 remote 6/20
11 @400000004faa61eb23794a8c status: local 0/10 remote 7/20
12 @400000004faa61ec241cc234 status: local 0/10 remote 7/20
13 @400000004faa61ed20245afc status: local 1/10 remote 6/20
14 @400000004faa61ed25077824 status: local 0/10 remote 7/20
15 @400000004faa61ee25879504 status: local 0/10 remote 8/20
16 @400000004faa61ef24e72e84 status: local 0/10 remote 8/20
17 @400000004faa61ef309ba82c status: local 1/10 remote 7/20
18 @400000004faa61f025cc3b3c status: local 0/10 remote 8/20
19 @400000004faa61f1260c4d94 status: local 0/10 remote 8/20
20 @400000004faa61f12f8a017c status: local 1/10 remote 7/20
21 @400000004faa61f21c67e384 status: local 0/10 remote 7/20
22 @400000004faa61f220b3be04 status: local 1/10 remote 7/20
23 @400000004faa61f22805990c status: local 0/10 remote 8/20
24 @400000004faa61f32919b4a4 status: local 0/10 remote 9/20
25 @400000004faa61f4294fc47c status: local 0/10 remote 10/20
26 @400000004faa61f4294fcc4c status: local 0/10 remote 11/20
27 @400000004faa61f51e12c8ac status: local 0/10 remote 11/20
28 @400000004faa61f52afaeff4 status: local 0/10 remote 12/20
29 @400000004faa61f705fbbb0c status: local 1/10 remote 10/20
30 @400000004faa61f7088dfeac status: local 1/10 remote 11/20
31 @400000004faa61f72e66af5c status: local 0/10 remote 9/20
32 @400000004faa61f82d35631c status: local 0/10 remote 9/20
33 @400000004faa61f92e5cc064 status: local 0/10 remote 10/20
34 @400000004faa61f92e5cc44c status: local 0/10 remote 11/20
35 @400000004faa61fa2fddbb14 status: local 0/10 remote 10/20
36 @400000004faa61fb066cdfe4 status: local 0/10 remote 10/20
37 @400000004faa61fb2fa32ecc status: local 0/10 remote 11/20
38 @400000004faa61fc028f6734 status: local 1/10 remote 10/20
39 @400000004faa61fc2f5600fc status: local 0/10 remote 10/20
40 @400000004faa61fd2ec3bf94 status: local 0/10 remote 10/20
41 @400000004faa61fe060cfd04 status: local 1/10 remote 8/20
42 @400000004faa61fe3094264c status: local 0/10 remote 9/20
43 @400000004faa61ff078b7714 status: local 0/10 remote 8/20
44 @400000004faa61ff3154901c status: local 0/10 remote 9/20
45 @400000004faa62003239911c status: local 0/10 remote 9/20
46 @400000004faa62010cb17554 status: local 1/10 remote 8/20
47 @400000004faa62013089878c status: local 0/10 remote 8/20
48 @400000004faa620233bc31ac status: local 0/10 remote 9/20
49 @400000004faa620333747a4c status: local 0/10 remote 9/20
50 @400000004faa6204076c4e84 status: local 0/10 remote 9/20
51 @400000004faa6204156a9cd4 status: local 1/10 remote 8/20
52 @400000004faa620433ca915c status: local 0/10 remote 9/20
53 @400000004faa6205360185fc status: local 0/10 remote 9/20
54 @400000004faa62061b4cda7c status: local 1/10 remote 8/20
55 @400000004faa62063423a9f4 status: local 0/10 remote 9/20
56 @400000004faa620737f9950c status: local 0/10 remote 10/20
57 @400000004faa620837398514 status: local 0/10 remote 11/20
58 @400000004faa62090fbe4fc4 status: local 1/10 remote 9/20
59 @400000004faa62093698863c status: local 0/10 remote 10/20
60 @400000004faa620a372c6d84 status: local 0/10 remote 11/20
61 @400000004faa620a38bb087c status: local 0/10 remote 12/20
62 @400000004faa620b3b02c9e4 status: local 0/10 remote 13/20
63 @400000004faa620b3b02cdcc status: local 0/10 remote 14/20
64 @400000004faa620c3a03d074 status: local 0/10 remote 12/20
65 @400000004faa620d23718644 status: local 0/10 remote 12/20
66 @400000004faa620d269f4a7c status: local 1/10 remote 12/20
67 @400000004faa620d3ace3cc4 status: local 0/10 remote 13/20
68 @400000004faa620e101950a4 status: local 0/10 remote 13/20
69 @400000004faa620e13d8f0b4 status: local 1/10 remote 13/20
70 @400000004faa620e3b740244 status: local 0/10 remote 14/20
71 @400000004faa6210018a301c status: local 0/10 remote 15/20
72 @400000004faa62110178abbc status: local 0/10 remote 16/20
73 @400000004faa62110178b38c status: local 0/10 remote 17/20
74 @400000004faa621200b115fc status: local 0/10 remote 16/20
75 @400000004faa621201511304 status: local 0/10 remote 17/20
76 @400000004faa621218e29cf4 status: local 1/10 remote 16/20
77 @400000004faa6212256dfa54 status: local 1/10 remote 15/20
78 @400000004faa62130296d974 status: local 0/10 remote 16/20
79 @400000004faa621402d06fa4 status: local 0/10 remote 16/20
80 @400000004faa621403d3743c status: local 0/10 remote 17/20
81 @400000004faa621418a9974c status: local 1/10 remote 16/20
82 @400000004faa6215025465bc status: local 0/10 remote 17/20
83 @400000004faa6215038037a4 status: local 0/10 remote 18/20
84 @400000004faa62151dd9da74 status: local 1/10 remote 17/20
85 @400000004faa6215369f0264 status: local 1/10 remote 16/20
86 @400000004faa621602f028bc status: local 0/10 remote 17/20
87 @400000004faa6216118079f4 status: local 1/10 remote 16/20
88 @400000004faa62163b83e4ac status: local 1/10 remote 15/20
89 @400000004faa6217045955ac status: local 0/10 remote 16/20
90 @400000004faa62180708c224 status: local 0/10 remote 15/20
91 @400000004faa6219017af1c4 status: local 1/10 remote 14/20
92 @400000004faa6219017af5ac status: local 1/10 remote 15/20
93 @400000004faa6219079d8bfc status: local 0/10 remote 16/20
94 @400000004faa621a05a5369c status: local 0/10 remote 17/20
95 @400000004faa621a07858b74 status: local 0/10 remote 18/20
96 @400000004faa621b08389b4c status: local 0/10 remote 18/20
97 @400000004faa621c0714cc2c status: local 0/10 remote 19/20
98 @400000004faa621c0954447c status: local 0/10 remote 20/20
99 @400000004faa621d0c37cccc status: local 0/10 remote 20/20
100 @400000004faa621d0db869bc status: local 1/10 remote 20/20
101 @400000004faa621e042e32b4 status: local 0/10 remote 20/20
102 @400000004faa621f2383a2fc status: local 0/10 remote 20/20
103 @400000004faa621f248c21ec status: local 1/10 remote 20/20
104 @400000004faa622022413fbc status: local 0/10 remote 20/20
105 @400000004faa62210d019cdc status: local 0/10 remote 20/20
106 @400000004faa62220c452e94 status: local 0/10 remote 20/20
107 @400000004faa62221240eb94 status: local 0/10 remote 20/20
108 @400000004faa622538c948ec status: local 0/10 remote 20/20
109 @400000004faa622809e178ec status: local 0/10 remote 20/20
110 @400000004faa622a01c37c14 status: local 1/10 remote 19/20
111 @400000004faa622a01c37ffc status: local 1/10 remote 20/20
112 @400000004faa622d12e88da4 status: local 0/10 remote 20/20
113 @400000004faa622e09fa216c status: local 0/10 remote 20/20
114 @400000004faa622e296abad4 status: local 0/10 remote 20/20
115 @400000004faa622f2a482a54 status: local 1/10 remote 19/20
116 @400000004faa622f2a483224 status: local 1/10 remote 20/20
117 @400000004faa623003d50e64 status: local 0/10 remote 20/20
118 @400000004faa6230051264ac status: local 1/10 remote 20/20
119 @400000004faa6230125e5abc status: local 0/10 remote 20/20
120 @400000004faa623102632ee4 status: local 0/10 remote 20/20
121 @400000004faa6231026336b4 status: local 1/10 remote 20/20
122 @400000004faa62310a18d0e4 status: local 0/10 remote 20/20
123 @400000004faa62310c7293ac status: local 0/10 remote 20/20
124 @400000004faa62311e3bc8c4 status: local 0/10 remote 20/20
125 @400000004faa62322fcb580c status: local 0/10 remote 20/20
126 @400000004faa62342d12c7bc status: local 0/10 remote 20/20
127 @400000004faa62352038e4cc status: local 0/10 remote 20/20
128 @400000004faa623537f2e61c status: local 0/10 remote 20/20
129 @400000004faa623538b7dfe4 status: local 1/10 remote 20/20
130 @400000004faa623638eede04 status: local 0/10 remote 20/20
131 @400000004faa62363a92d1d4 status: local 1/10 remote 20/20

还不太清楚，不过有两点：
1。要用 $50.; 50后面加点，前面不要冒号（否则会在分隔符前面自动停止）
2。要用truncover免得到下一行

teqel 发表于 2015-12-23 00:45
还不太清楚，不过有两点：
1。要用 $50.; 50后面加点，前面不要冒号（否则会在分隔符前面自动停止）
2。要 ...

好， 我再试试，谢谢！