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