测试数据。上传附件。

/* you can also use compress function to remove the double quote */
data test3;
infile datalines dlm=',' dsd;
input company $ Product $ price;
company=compress(company, ' " ');
product = compress(product, '"');
datalines;
"""ABC""","""PROD_A""",2031
"""ABC""","""PROD_A""",2032
"""ABC""","""PROD_A""",2033
"""ABC""","""PROD_A""",2034
"""ABC""","""PROD_A""",2035
; run;

* note: there is a dollar sign after company and product in the input statement;

使用函数COMPRESS(变量,'"')

这个是导入以后用吧 我想在导入的时候直接去掉不知道可不可以

data test;
infile cards dlm=',' dsd;
length company Product $8;
input company :$quote8. Product :$quote8. price;
cards;
"ABC","PROD_A",2031
"ABD","PROD_B",2032
"ABE","PROD_C",2033
"ABF","PROD_D",2034
"ABG","PROD_E",2035
;
run;