全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
1743 6
2013-07-05
如果我想取下面的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:
二维码

扫码加我 拉你入群

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

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

全部回复
2013-7-6 06:24:09
复制代码
二维码

扫码加我 拉你入群

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

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

2013-7-6 06:39:44
谢了 我试试
二维码

扫码加我 拉你入群

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

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

2013-7-6 06:46:47
这整个数据都是在txt文件上的... 要的导入到sas
二维码

扫码加我 拉你入群

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

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

2013-7-6 07:19:18
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
IP_address.JPG

二维码

扫码加我 拉你入群

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

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

2013-7-6 08:01:12
谢谢,不过这只是一部分数据,原数据要大于 是100Kb+ SAS存不下的
二维码

扫码加我 拉你入群

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

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

点击查看更多内容…
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群