title: SQL error using INSERT INTO to build a table
body: <p>I'm trying to put together a table in SAS Enterprise Guide using INSERT INTO using online tutorials but keep getting errors when I do the same thing as the tutorial. What could be going wrong?</p>
  <p>My code:</p>
  <pre><code>/* Create the table */ 
     CREATE TABLE Summary_1920 (
        Variable VARCHAR(255), 
        Count INT, 
        Percentage FLOAT ); 
  /* Create and insert the variable names */
     INSERT INTO Summary_1920 
        (Variable, Count, Percentage)
     VALUES 
        (&quot;Variable1&quot;, 100, 90.8),
        (&quot;Variable2&quot;, 8, 7.0);
  
  QUIT; 
  </code></pre>
  <p>The error:</p>
  <pre class="lang-none prettyprint-override"><code>28               (&quot;IntName&quot;, 100, 90.8),
                                         _
                                         22
                                         200
  ERROR 22-322: Syntax error, expecting one of the following: ;, VALUES.  
  
  ERROR 200-322: The symbol is not recognized and will be ignored.
  </code></pre>
  <p>This is my first time using SAS EG/SQL so it's probably very obvious but I've been trying to fix this for ages. Thanks for any insight.</p>