sas：csv文件在逗号之前有空格，但在引号之外 [英] sas: csv file has spaces before the comma but outside the quotes

问题描述

一个csv文件我想用SAS读取在两个字段之间有双引号。

A csv file I am trying to read with SAS has spaces between fields with double quotes.

例如：

"ok","bad spaces ahead"        ,"more data"  
_______________________^spaces^____________  

我如何获得SAS阅读本正确？我需要有CSV更换吗？

How do I get SAS to read this correctly? Do I need to have the csv replaced?

推荐答案

添加DSD和missover在INFILE语句的作品？

adding dsd and missover in your infile statement works?

data badspaces;
    infile datalines dlm=',' dsd missover;
    format Var1 $2.
        Var2 $20.
        Var3 $10.;
    input var1-var3;
    put 'x' var1 'x'
    /   'x' var2 'x'
    /   'x' var3 'x'
    /;
datalines;
"ok","bad spaces ahead"        ,"more data"
"ok","no spaces ahead","more data"
run;

：

xok x
xbad spaces ahead x
xmore data x

xok x
xno spaces ahead x
xmore data x

这篇关于sas：csv文件在逗号之前有空格，但在引号之外的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！