https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497877#M132131 <P><STRONG>R</STRONG>ead <STRONG>T</STRONG>he <STRONG>F</STRONG>riendly <STRONG>M</STRONG>anual.</P> <P>&nbsp;</P> <P>Or use the import wizard and check the little box that says "save the generated code"</P> <P>&nbsp;</P> <P>From the online help:</P> <PRE>PROC IMPORT DATAFILE="filename " | TABLE="tablename " OUT=&lt;libref .&gt;SASdata set &lt;(SAS data set option(s))&gt; &lt;DBMS=identifier&gt; &lt;REPLACE&gt;; </PRE> <P>The basic syntax. Note: DATABASE is not an option, DATAFILE is. Also there is no ; in the middle of the statement.</P> <P>&nbsp;</P> Fri, 21 Sep 2018 15:47:17 GMT ballardw 2018-09-21T15:47:17Z https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497660#M131982 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23433i0C523CDAFD6E77C2/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>i wanted to import one access table like see above program but i got error&nbsp;</P><P>can you explain that how solve that error</P> Fri, 21 Sep 2018 03:52:18 GMT https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497660#M131982 thanikondharish 2018-09-21T03:52:18Z https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497666#M131988 <P>Did you search before asking? Did you see <A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/PROC-IMPORT-DBMS-ACCESS/td-p/53894" target="_self">this</A>?</P> Fri, 21 Sep 2018 04:03:43 GMT https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497666#M131988 ChrisNZ 2018-09-21T04:03:43Z https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497877#M132131 <P><STRONG>R</STRONG>ead <STRONG>T</STRONG>he <STRONG>F</STRONG>riendly <STRONG>M</STRONG>anual.</P> <P>&nbsp;</P> <P>Or use the import wizard and check the little box that says "save the generated code"</P> <P>&nbsp;</P> <P>From the online help:</P> <PRE>PROC IMPORT DATAFILE="filename " | TABLE="tablename " OUT=&lt;libref .&gt;SASdata set &lt;(SAS data set option(s))&gt; &lt;DBMS=identifier&gt; &lt;REPLACE&gt;; </PRE> <P>The basic syntax. Note: DATABASE is not an option, DATAFILE is. Also there is no ; in the middle of the statement.</P> <P>&nbsp;</P> Fri, 21 Sep 2018 15:47:17 GMT https://communities.sas.com/t5/SAS-Programming/how-to-solve-this-error/m-p/497877#M132131 ballardw 2018-09-21T15:47:17Z