sas导入.csv格式数据时首尾都有双引号 怎么在导入的时候可以去掉 请教高手

sas导入.csv格式数据时首尾都有双引号 怎么在导入的时候可以去掉 请教高手 spss可以添加文本限定符来去掉双引号 可是sas不知道怎么去掉

测试数据。上传附件。

1. /* try this */
   
2. data test;
   
3. infile datalines dlm=',' dsd;
   
4. input company $ Product $ price;
   
5. datalines;
   
6. "ABC","PROD_A",2031
   
7. "ABD","PROD_B",2032
   
8. "ABE","PROD_C",2033
   
9. "ABF","PROD_D",2034
   
10. "ABG","PROD_E",2035
    
11. ; run;

复制代码

/* 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(变量,'"')

jacky1842 发表于 2014-4-12 21:56
使用函数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;

learsaas 发表于 2014-4-22 13:28
data test;
infile cards dlm=',' dsd;
length company Product $8;

谢谢 这个我也试过 dsd可以去掉双引号  但导入csv还是显示有双引号 不知道怎么回事

beijingdizheng 发表于 2014-4-23 08:32
谢谢 这个我也试过 dsd可以去掉双引号  但导入csv还是显示有双引号 不知道怎么回事

不知道你什么意思，你可以把文本文件上传

Beside, you can use DEQUOTE function in data step to compress paired quotes.

1. data test;
   
2. infile datalines dlm=',';
   
3. input company $ Product $ price;
   
4. re_comp = dequote(company);
   
5. re_prod = dequote(Product);
   
6. datalines;
   
7. "ABC",'PROD_A',2031
   
8. "ABD",'PROD_B',2032
   
9. "ABE",'PROD_C',2033
   
10. "ABF",'PROD_D',2034
    
11. "ABG",'PROD_E',2035
    
12. ; run;

复制代码