error while importing file in sas
in [SAS]
|
Prev: ERROR: Permanent copy of file WORK.ZFMMEM.UTILITY was deleted.
Next: import variable names from delimited files
From: hipul on 19 Jun 2007 02:56 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 records" hipul
From: Gerhard Hellriegel on 19 Jun 2007 03:18 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 data a; infile xx; input a b c; run; Gerhard On Mon, 18 Jun 2007 23:56:11 -0700, hipul <hipull(a)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 >records" > >hipul
From: "Audimar P. Bangi" on 19 Jun 2007 20:00 You can open your Excel file (*.xls) using my Notebook (http://sas2themax.com/beta), and save it directly as a SAS dataset (*.sas7bdat), without the hassles of a DATA Step raw coding, or Wizard-based importing. If there are unsually wide columns of character variables, make sure you set the format length length correctly before saving to avoid column values being truncated. Notebook doesn't throw an error if there are no records in the first 5 rows. It can open multi-sheet Excel 97-2003 workbooks. As for Excel 2007, support is forthcoming. Regards, Audi http://sas2themax.com ----- Original Message ----- From: "hipul" <hipull(a)GMAIL.COM> To: <SAS-L(a)LISTSERV.UGA.EDU> Sent: Tuesday, June 19, 2007 2:56 AM Subject: error while importing file in sas > 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 > records" > > hipul
From: Nat Wooding on 19 Jun 2007 08:24
If you have V9 and SAS Access to pcs, you can use the new excel libname statement libname blank6 'c:\park\blank6.xls'; proc print data=blank6.'Sheet1$'n; run; libname blank6 clear; run; And the name hints, I set up this spreadsheet so that the first 6 lines were blank. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 ----- Original Message ----- From: "hipul" <hipull(a)GMAIL.COM> To: <SAS-L(a)LISTSERV.UGA.EDU> Sent: Tuesday, June 19, 2007 2:56 AM Subject: error while importing file in sas > 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 > records" > > hipul ----------------------------------------- CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you. |