About matt_beyers

matt_beyers · ‎09-07-2018

I forgot to say, I have dozens of sheets in the Excel file and I didn't want to export to CSV or other. Based on these two replies, however, it seems I must do so and can't get around that without using SAS/ACCESS. I can write a VBA script to export them all to the same directory and then call them by referencing every CSV file in that directory in a list. I do like the idea of creating an ODBC connection but want to make this easy on the users.

matt_beyers · ‎09-05-2018

I'm trying to import my Excel files into SAS without SAS/ACCESS. Is this possible other than the SAS Enterprise Guide import wizard? I'm a newbie but I've checked around in here and on other sites with no luck. I'm using base SAS 9.4 with SAS/STAT on a Windows 10 64-bit machine. From the import wizard, I'm not seeing a way to use the syntax generated directly. From https://libguides.library.kent.edu/SAS/ImportData#s-lg-box-wrapper-18345498: This uses PCFILES, which seems to be part of SAS/ACCESS. I get the error, "ERROR: The PCFILES engine cannot be found." From https://stats.idre.ucla.edu/sas/faq/how-do-i-readwrite-excel-files-in-sas/: This uses PROC IMPORT with DBMS=XLSX (I've used DBMS=EXCEL, too). I get the error, "ERROR: DBMS type XLSX not valid for import."

Online Status	Offline
Date Last Visited	‎09-07-2018 06:23 PM

Re: Importing Excel files in syntax without SAS/ACCESS

Importing Excel files in syntax without SAS/ACCESS

Re: Importing Excel files in syntax without SAS/ACCESS

Re: Importing Excel files in syntax without SAS/ACCESS

Importing Excel files in syntax without SAS/ACCESS