sas读取csv文件时，为什么只有第一列

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

哎，，csv文件无法作为附件上传、图片又显示不清楚：只能在下面黏贴了，求解答age,"job","marital","education","default","balance","housing","loan","contact","day","month","duration","campaign","pdays","previous","poutcome","y"
30,"unemployed","married","primary","no",1787,"no","no","cellular",19,"oct",79,1,-1,0,"unknown","no"
33,"services","married","secondary","no",4789,"yes","yes","cellular",11,"may",220,1,339,4,"failure","no"

说明：
1)第一行是字段名，后面是数据，缺失值=unknown.
2)用 import导出的结果是，逗号、引号都在
只有一个字段，显示为  ：age_job_marital_educa
后面的数据，跟csv一摸一样，都在第一列中。

代码如下：
PROC IMPORT OUT= SASUSER.Bank
            DATAFILE= "F:\bank.csv"
            DBMS=csv REPLACE ;  
     GETNAMES=YES;
     DATAROW=2;
RUN;


试了很多次都这样，，怎么回事啊？求解？csv是用EXCEl打开的

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Unemployed Secondary Education Cellular employed education default campaign previous services

我这边运行没有任何问题。
SAS9.3

我的是sas9.1,,难道是因为版本太老的问题？？目前还没新版本，，，不知这问题有救没