| Date: | Wed, 28 Oct 2009 18:31:07 -0400 |
|---|
| Reply-To: | Arthur Tabachneck <art297@NETSCAPE.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Arthur Tabachneck <art297@NETSCAPE.NET> |
|---|
| Subject: | Re: Exclude first 2 rows in Proc Import step |
|---|
|
I don't think that Shiva's code will work unless the file is actually just a
delimited file, but with an xls extension.
You could, however, use an infile statement combined with DDE. E.g.,
OPTIONS NOXSYNC NOXWAIT;
X '"c:\test\temp.xls"';
FILENAME thedata DDE
'Excel|c:\test\[temp.xls]sheet1!R3C1:R7C2';
data want;
INFILE thedata NOTAB DLM='09'x DSD MISSOVER;
INPUT ID name $;
run;
HTH,
Art
--------
On Tue, 27 Oct 2009 06:41:18 -0700, Wataridori <wataridori@GMAIL.COM> wrote:
>Hi,
>
>I've never been able to use an infile command correctly with an .xls
>file. Can you provide a sample of what it should look like using the
>firstobs option?
>
>Thanks.
| 
