title: How to create a table using `Proc SQL` without selecting from existing tables
body: <p>What is the SAS version of &quot;<code>select from dual</code>&quot;? I want to create a table using <code>Proc SQL</code> without selecting from excisting tables. for instance. Basically I want something like:</p>
  <pre><code>PROC SQL;
    CREATE TABLE tmptable AS
    SELECT 1 AS myvar FROM dual;
  QUIT;
  </code></pre>
  <p>This does not work. What choices do I have?</p>