zhengbo8 发表于 2015-10-23 23:07
完美解决。求币啦~
附上数据。
WARNING: The quoted string currently being processed has become more than 262 bytes long.
You might have unbalanced quotation marks.
19 length name temp $200;
20 retain temp;
7 RANGE="Sheet1[ DISCUZ_CODE_0 ]quot;;
--------------------------------------------
49
NOTE 49-169: 加引号字符串后的标识符的含义可能在将来的 SAS 版本中更改。
建议在加引号的字符串和其后的标识符之间插入空格。
21
22 if _n_=1 then temp=_COL1;
23 if _COL1='' then _COL1=temp; else temp=_COL1;
24
25 _COL4=tranwrd(_COL4,"、","|");
--
22
ERROR 22-322: 期望: ;.
26
27 i=1;
28 name=strip(scan(_COL4,i,'| '));
29
30 do while (strip(scan(_COL4,i,'| ')) ne '');
31 name=strip(scan(_COL4,i,'| '));
32 i=i+1;
33 output;
34 end;
35
36 keep _COL1 _COL2 _COL3 name;
37
38 run;