1.如何在sas中正确导入带分隔符的txt数据

data A ;

infile f1;

LENGTH ID TIME_STAMP $20;

LENGTH PAGE_NAME $50;

input;

A =tranwrd(tranwrd(_infile_, "ID~", "="), "TIME_STAMP~","=");

ID=SCAN(SCAN(A, 2, "="), 1, "|");

A =SCAN(A, 3, "=");

A =tranwrd(A, "PAGE_NAME~", "=");

TIME_STAMP = SCAN(SCAN(A, 1, "="), 1, "|");

A =SCAN(A, 2, "=");

A =tranwrd(A, "PORTLET_NAME~", "=");

PAGE_NAME = SCAN(SCAN(A, 1, "="), 1, "|");

A =SCAN(A, 2, "=");

run;

2.如何在sas中正确导入带分隔符的txt数据

data A ;infile f1;LENGTH ID TIME_STAMP $20;LENGTH PAGE_NAME $50;input;A =tranwrd(tranwrd(_infile_, "ID~", "="), "TIME_STAMP~","=");ID=SCAN(SCAN(A, 2, "="), 1, "|");A =SCAN(A, 3, "=");A =tranwrd(A, "PAGE_NAME~", "=");TIME_STAMP = SCAN(SCAN(A, 1, "="), 1, "|");A =SCAN(A, 2, "=");A =tranwrd(A, "PORTLET_NAME~", "=");PAGE_NAME = SCAN(SCAN(A, 1, "="), 1, "|");A =SCAN(A, 2, "=");run;。

3.sas导入数据

data abc;

infile 'D:sasab.txt';

input name $9. @12 jobhist $35. @48 manger :$9.;

**最后一个必须为冒号修正符；

run;

另外这里有几种方法，

也就是inflie 有好几个选项：MISSOVER TRUNCOVER PAD ； 自己试试看有什么不一样，

这三个选项各用法不一样，而系统默认为MISSOVER

这里必须改为

data abc;

infile 'D:sasab.txt' TRUNCOVER;

input name $9. @12 jobhist $35. @48 manger $9.;

run;