This paper may be helpful too.

http://www2.sas.com/proceedings/sugi31/020-31.pdf

Dennis

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of F J Kelley Sent: Wednesday, March 21, 2012 4:56 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Getting Started with SAS/Access and PROC IMPORT

Yes, Proc IMPORT is the way to read these. There is a "sheet=" (or "worksheet=" ) option that will take the individual worksheets. However, if the worksheets may vary in the names they will use, you may need some VB script or Powershell to get the info. If Alan Churchill or a few of the Windows folks are listening, they can tell you better than I.

My last experience with IMPORT was not so successful -- right now, I suspect the bitness of the version of SAS and the version of Office ... --Joe

________________________________________ From: SAS(r) Discussion [SAS-L@LISTSERV.UGA.EDU] on behalf of Mary Rosenbloom [mary.rosenbloom.sas@GMAIL.COM] Sent: Wednesday, March 21, 2012 4:44 PM To: SAS-L@LISTSERV.UGA.EDU Subject: [SAS-L] Getting Started with SAS/Access and PROC IMPORT

Hi all,

I was just given a multi-page Excel workbook that contains data on every page. I need to read each page in as a SAS dataset. I will need to do this weekly, so I don't want to take the time to convert this into several one-page .csv files.

I have SAS/Access and am told that I need to use PROC IMPORT. I've been asked to try to import this Excel file, and I'm not sure where to start. So far, I've looked at the online docs, but again am not sure where to look first.

Questions:

1. Could you please recommend a good online reference "starting point"? 2. Should I be focusing on PROC IMPORT or is there something else that I should try first?

Thanks in advance for your assistance.

Cheers, Mary R.