Date:         Wed, 21 Mar 2012 14:08:53 -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: Fareeza Khurshed <fkhurshed@gmail.com>
In-Reply-To:  <CAL9q9TreuH60xnK=PJAyWq=xwug74pX8PsRrj4xRRiRLxNnDxw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

This works great!  Thank you!


On Wed, Mar 21, 2012 at 2:05 PM, Fareeza Khurshed <fkhurshed@gmail.com>wrote:

> You should be able to use literals to refer to them (not sure of the exact
> terminology). Assuming you have something labelled Sheet1 in your workbook
> the following would work.
>
> ie
>
> data sheet1;
> set test.'Sheet1$'n;
> run;
>
> Fareeza
>
>
>
> On Wed, Mar 21, 2012 at 2:01 PM, Mary Rosenbloom <
> mary.rosenbloom.sas@gmail.com> wrote:
>
>> Hi all,
>>
>> 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.
>>
>> Cheers,
>> Mary R.
>>
>> On Wed, Mar 21, 2012 at 1:56 PM, F J Kelley <jkelley@uga.edu> wrote:
>>
>> > 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
>>
>
>


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