title: SAS Invalid data for csv
body: <p>Im quite new to SAS and after many attempts Im still wondering how could import my csv file into SAS accurately.</p>
  <p>Here's my data</p>
  <pre><code>color, Description, price
  &quot;Black, blue, grey&quot;, &quot;Pipe, 16&quot; inch wide, PVC&quot;, 20.27
  </code></pre>
  <p>Here's my sas code</p>
  <pre><code>PROC IMPORT datafile='/home/..data.csv'
              out=data dbms=csv replace; 
              getnames=yes;
              guessingrows = max;
  RUN; 
  </code></pre>
  <p>Here's what SAS reads:</p>
  <pre><code>Color                 Description      Price 
  Black, blue, grey     &quot;Pipe             .
  </code></pre>
  <p>I suspect SAS treat &quot;Pipe under description instead of Pipe, 16&quot; inch wide, PVC. What could I do so that SAS can read the whole line?</p>