topic Re: Importing Using EG SAS in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96296#M27205 <HTML><HEAD></HEAD><BODY><P>What do you mean by "has issues"?</P><P>Do you get any error messages? Is your data corrupt?</P></BODY></HTML> Wed, 03 Apr 2013 14:26:42 GMT LinusH 2013-04-03T14:26:42Z Importing Using EG SAS https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96295#M27204 <HTML><HEAD></HEAD><BODY><P>The following import worked when I used PCSAS. I was converted to Enterprise Guide(EG) a few weeks ago.</P><P><STRONG style="color: navy; background: white; font-family: 'Courier New';">PROC</STRONG> <STRONG style="color: navy; background: white; font-family: 'Courier New';">IMPORT</STRONG> <SPAN style="font-family: 'Courier New'; background: white; color: blue;">OUT</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">= SRV_WORK.mylist1 </SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">DATAFILE</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">= </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"C:\SAS\March_2013.xlsx"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp; </SPAN></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">DBMS</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=EXCEL </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: blue;">REPLACE</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">GETNAMES</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=YES;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">RANGE</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple;">"Sheet1$"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">; </SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">MIXED</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=NO;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">SCANTEXT</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=YES;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">USEDATE</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=YES;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; background: white; color: blue;">SCANTIME</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black;">=YES;</SPAN></P><P><STRONG style="color: navy; background: white; font-family: 'Courier New';">RUN</STRONG><SPAN style="font-family: 'Courier New'; background: white; color: black;">;</SPAN></P><P></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black;">EG has issues with importing data and creating a work file.&nbsp; Other than going with a datalines options is there a work-around.&nbsp; I am using 5.1 version if that helps.</SPAN></P></BODY></HTML> Wed, 03 Apr 2013 14:15:34 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96295#M27204 omega1983 2013-04-03T14:15:34Z Re: Importing Using EG SAS https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96296#M27205 <HTML><HEAD></HEAD><BODY><P>What do you mean by "has issues"?</P><P>Do you get any error messages? Is your data corrupt?</P></BODY></HTML> Wed, 03 Apr 2013 14:26:42 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96296#M27205 LinusH 2013-04-03T14:26:42Z Re: Importing Using EG SAS https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96297#M27206 <HTML><HEAD></HEAD><BODY><P>check that your filename.extension of .xlsx</P><P>is in alignment with </P><P>dbms=Excel</P><P></P><P><A href="http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n0msy4hy1so0ren1acm90iijxn8j.htm" title="http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n0msy4hy1so0ren1acm90iijxn8j.htm">SAS/ACCESS(R) 9.3 Interface to PC Files: Reference</A></P><P></P><P>Microsoft Excel Workbook Files</P></BODY></HTML> Wed, 03 Apr 2013 14:38:26 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-Using-EG-SAS/m-p/96297#M27206 Ron_MacroMaven 2013-04-03T14:38:26Z