|Date: ||Thu, 22 Mar 2012 15:20:21 +0000|
|Reply-To: ||"Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR)" <wfu4@CDC.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR)" <wfu4@CDC.GOV>|
|Subject: ||Re: Getting Started with SAS/Access and PROC IMPORT|
|Content-Type: ||text/plain; charset="us-ascii"|
This paper may be helpful too.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of F J Kelley
Sent: Wednesday, March 21, 2012 4:56 PM
Subject: Re: Getting Started with SAS/Access and PROC IMPORT
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
Subject: [SAS-L] Getting Started with SAS/Access and PROC IMPORT
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.