一个SAS导入的问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

如果我想取下面的IP:后面的数字不要其他东西,如果用SAS读取数据呢



IP: 41.58.35.111 - DATE: Thursday 04 July 00:22:23 - [URL: /.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit//537.36] \nIP: 41.58.35.104 - DATE: Thursday 04 July 00:22:43 - [URL: /administrator/images/common/Logon.aspx.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36] \nIP: 41.58.35.104 - DATE: Thursday 04 July 00:22:43 - [URL: /administrator/images/common/confirm.aspx.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36] \nIP: 41.58.35.104 - DATE: Thursday 04 July 00:23:03 - [URL: /administrator/images/common/confirm.aspx.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36] \nIP: 41.58.35.104 - DATE: Thursday 04 July 00:23:10 - [URL: /administrator/images/common/confirm.aspx.php] | [Agent:

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Windows Window ADMINI Common images

1. /* try this */
   
2. data want;
   
3.     if _n_ = 1 then  pp1 = prxparse("/IP: \d{1,3}(\.\d{1,3}){3}/");
   
4.     retain pp1;
   
5.     set test;
   
6.       Leng = length(string);
   
7.       temp_str = string;
   
8.       pos = 1;
   
9.    do until (pos = 0);
   
10.       pos = prxmatch(pp1, temp_str);
    
11.          if pos then do;
    
12.            call prxsubstr(pp1, temp_str, position1, length1);
    
13.            IP = substr(temp_str, position1, length1);
    
14.            output;
    
15.       leng = leng - position1 - length1;
    
16.       temp_str=substr(temp_str, position1+length1, leng);
    
17.       end;
    
18.    end;
    
19.   keep IP;
    
20. run;

复制代码

谢了 我试试

这整个数据都是在txt文件上的... 要的导入到sas

gyambqt 发表于 2013-7-6 06:46
这整个数据都是在txt文件上的... 要的导入到sas

/* The following code works in my case that all the data are in one row */
/* if your data in text file has different format you may use infile statement */

data test;
  input string & : $1000.;
datalines4;
IP: 41.58.35.111 - DATE: Thursday 04 July 00:22:23 - [URL: /.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit//537.36] \nIP: 41.58.36.105 - DATE: Thursday 04 July 00:22:43 - [URL: /administrator/images/common/Logon.aspx.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36] \nIP: 41.58.37.107 - DATE: Thursday 04 July 00:22:43 - [URL: /administrator/images/common/confirm.aspx.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36] \nIP: 41.58.38.108 - DATE: Thursday 04 July 00:23:03 - [URL: /administrator/images/common/confirm.aspx.php] | [Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36] \nIP: 41.58.39.109 - DATE: Thursday 04 July 00:23:10 - [URL: /administrator/images/common/confirm.aspx.php] | [Agent:
;;;;


data test2;   /* this is another dataset you can try the code */
     input string & : $80. ;
datalines;
aAAAIP: 41.58.35.111 - DATE: Thursday 04 July 00:22:23 - [URL: /.php]
AaAA\nIP: 41.58.35.104 - DATE: Thursday -Safari/537.36] \nIP: 41.58.36.105 - DATE
;
run;

The result

谢谢,不过这只是一部分数据,原数据要大于 是100Kb+ SAS存不下的

最后的数据应该是:

IP: XX.XX.XX.XX

IP: XX.XX.XX.XX

IP: XX.XX.XX.XX


其他都不要..