title: How many rows will SAS check to determine if the input data contains decimal?
body: <p>Recently I found a problem when uploading excel file to snow flake using SAS.</p>
  <p>My excel include 2 columns 1400 rows, in the first column only 11 rows have 2 decimal place, in the second column, most of the data have 2 decimal place.</p>
  <p>When I upload the file to snowflake, in the first column all 11 rows with 2 decimal place have been rounded to the nearest whole number. but in the second column all decimal numbers remains.</p>
  <p>I heard that the Power Query will check the first 200 rows, if all the first 200 rows are whole number it will round following decimal to whole number. What about SAS? Will SAS also check certain amount of rows to decide the data format for the rest of the file, and how many rows will SAS check?</p>
  <p>The code I used to upload the excel</p>
  <pre><code>FILENAME REFFILE '/sample.xlsx';
  
  PROC IMPORT DATAFILE=REFFILE
      DBMS=XLSX
      OUT=WS_CRA.output;
      GETNAMES=YES;
  RUN;
  </code></pre>