比如这样的:
contentid contenttype title userid extref datecreated Name content
cid6257044175862193153 Post Watch for AIR MILES specials at the grocery store. uid5638212984437526639 S6j/TWJ5vt1L88ya7hrktw== 2009-03-11 12:01:51.563 Featured tip "Watch for AIR MILES specials at the grocery store. If you see a non-perishable food item with extra Bonus miles, but don't think you need that much, consider purchasing it and donating the extras to your local food bank."
cid7816625057236859877 Post Get the new AIR MILES Toolbar uid5638212984437526639 S6j/TWJ5vt1L88ya7hrktw== 2009-03-11 12:06:34.707 Tips "Get the new AIR MILES Toolbar and get lots of free AIR MILES just for searching with Yahoo. You can get up to 30 reward miles each month!! And it's free to download. Just go to www.air.tool.cn"
cid8481937969092539422 Post Sign up for email updates. uid5638212984437526639 S6j/TWJ5vt1L88ya7hrktw== 2009-03-11 12:09:20.127 Tips ""
其中有很多缺失值 “” 里面没东西的,每个值的长度也相差很大,求问input, informat, format怎么写哇~Date那个地方也不知道怎么informat因为既有date又有时间~~
总共就是这样几项:contentid contenttype title userid extref datecreated Name content
下面内容怎么弄都是乱的 555, 我写的是:
DATA posts;
INFILE "/myfolders/airmiles2/posts.txt" FIRSTOBS=2 DSD DLM='09'x;
INPUT @'cid' contentid $ 1-22 contenttype $ title $
@'uid' userid $ extref $ Date Name $ content $;
INFORMAT contentid $30. contenttype $12. title $80.
userid $30. extref $25. Date E8601DT20.3 Name $30. content $255.;
FORMAT DATE DDMMYY10.;
RUN;