Date:         Wed, 21 Mar 2012 21:54:10 -0400
Reply-To:     Gabriel Farkas <g.farkas@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gabriel Farkas <g.farkas@GMAIL.COM>
Subject:      Re: Getting Started with SAS/Access and PROC IMPORT

Try the autoimporterv9 programs:
http://support.sas.com/kb/13/348.html

I've found that it helps to read through the code to understand what they do
and where, and then I've tweaked them for my specific needs. For example,
only reading in sheets whose names meet certain criteria, or using PROC
DATASETS to append together certain sheets, or things like that.

Also, in general, the root directory on SAS's FTP site is good to skim
through to see what other tools they have available:
http://ftp.sas.com/techsup/download/base/

The README.TXT file lists short descriptions of the various programs found
there.




On Wed, 21 Mar 2012 16:44:58 -0400, Mary Rosenbloom
<mary.rosenbloom.sas@GMAIL.COM> wrote:

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