Date:         Wed, 28 Mar 2012 11:44:51 -0700
Reply-To:     Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Subject:      Re: Getting Started with SAS/Access and PROC IMPORT
Comments: To: "Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR)" <wfu4@cdc.gov>
In-Reply-To:  <E9AED27F4BE8564F9A38F0A7899BDCCA01EF14A2@EMBX-CLFT2.cdc.gov>
Content-Type: text/plain; charset=ISO-8859-1

Thanks everyone!

On Thu, Mar 22, 2012 at 8:20 AM, Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR) <
wfu4@cdc.gov> wrote:

> 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.
>



--
Cheers,
Mary F. O. Rosenbloom
http://www.sascommunity.org/wiki/User:Otterm1