Date: Wed, 21 Mar 2012 14:01:48 -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
Content-Type: text/plain; charset=ISO-8859-1
So I tried Fareeza's suggestion and was able to see the data right away.
Thanks Fareeza! However, the datasets that I saw don't conform to the
dataset names that SAS requires. Does this mean that I now need to use
PROC IMPORT, as Joe suggests?
Thanks so much for your help. This is one of those situations where I am
not quite sure how to start, or where to look online.
On Wed, Mar 21, 2012 at 1:56 PM, F J Kelley <firstname.lastname@example.org> wrote:
> 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 ...
> 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.
> 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.
> Mary R.
Mary F. O. Rosenbloom