Have a look into your EXCEL file: is that true what SAS says?
Maybe you could try DDE, if you want to extract a certain area of that
file. Mark it in EXCEL and go in SAS to the menu pint "Solutions - Tools"
(could be other, I have only german SAS here and don't know how they
translated that). There you find something like "DDE Triplet". That you
can copy (CTRL-C) and paste it into a filename like
filename xx DDE "---here the triplet ----";
Then you can read the file with
input a b c;
On Mon, 18 Jun 2007 23:56:11 -0700, hipul <hipull@GMAIL.COM> wrote:
>While trying to import an excel file into sas, i get the following
>error: "Unable to sample external file-no records exist in the first 5