Re: Importing and exporting to Excel while Excel 2007 installed

Jim;

I have Excel 2007. If I save the Excel files in the Excel 2003 format, SAS can read from them and write to them just fine.

If I ask SAS to create an Excel file (via the LibName statement) I can open it in Excel 2007 just fine.

I only wonder when I will be able to stop saving my Excel files in the much larger 2003 format. That is, when will the SAS/ACCESS excel engine be able to read files in the Excel 2007 format.

Ed

Edward Heaton, Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1650 Research Boulevard, TB-286, Rockville, MD 20850-3195
Voice: (301) 610-4818 Fax: (301) 294-2085
mailto:EdHeaton@Westat.com http://www.Westat.com




-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jim Groeneveld
Sent: Wednesday, September 17, 2008 5:28 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Importing and exporting to Excel while Excel 2007 installed


Hi friends,

I don't have Excel 2007 installed myself. I still use 2003, but one of our users has Excel 2007 installed and is using SAS 9.1.3. He does not succeed in importing and exporting (via the GUI) from and to Excel format (e.g. Error in LIBNAME statement). I have several questions:

1. In what way does SAS need (parts of) the installed Excel? I mean would SAS be able to import from and to export to Excel format (.xls) without an existing Excel installation? If SAS needs Excel then skip to question 7.

If SAS doesn't actually need Excel then the following questions apply:

2. Why does it fail importing and exporting from/to the "old" 2003 format
(xls) if Excel 2007 installed and files saved to old (2003) format?

3. Would it help to read the 2003 formatted Excel files with Excel 2003 and to resave them before importing to SAS?

4. Would we have to revert to Excel 2003 (deinstalling 2007)?

5. Is it possible to have both Excel 2003 and 2007 installed and working?

6. Which SAS version would be compatible with the (possibly yet deviant) 2003 format of Excel 2007?

If SAS needs (parts of) an Excel installation then:

7. What is the simplest way to import and export (mainly from a batch
program) to the XLS 2003 format with Excel 2007 installed?

8. Is it possible to have both Excel 2003 and 2007 installed and working and would SAS work correctly with Excel files that way?

Regards - Jim.
--
Jim Groeneveld, Netherlands
Statistician, SAS consultant
home.hccnet.nl/jim.groeneveld

My computer and I present macro Count with SPSS-like syntax at PhUSE 2008.

On Sep 17, 11:19*pm, EdHea...@WESTAT.COM (Ed Heaton) wrote:
> Jim;
>
> I have Excel 2007. *If I save the Excel files in the Excel 2003 format,SAS can read from them and write to them just fine.
>
> If I ask SAS to create an Excel file (via the LibName statement) I can open it in Excel 2007 just fine.
>
> I only wonder when I will be able to stop saving my Excel files in the much larger 2003 format. *That is, when will the SAS/ACCESS excel engine beable to read files in the Excel 2007 format.
>
> Ed
>
> Edward Heaton, Senior Systems Analyst,
> Westat (An Employee-Owned Research Corporation),
> 1650 Research Boulevard, TB-286, Rockville, MD 20850-3195
> Voice: (301) 610-4818 * * * * * * * * Fax: (301) 294-2085
> mailto:EdHea...@Westat.com * * * * *http://www.Westat.com
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of Jim Groeneveld
> Sent: Wednesday, September 17, 2008 5:28 AM
> To: SA...@LISTSERV.UGA.EDU
> Subject: Importing and exporting to Excel while Excel 2007 installed
>
> Hi friends,
>
> I don't have Excel 2007 installed myself. I still use 2003, but one of our users has Excel 2007 installed and is using SAS 9.1.3. He does not succeed in importing and exporting (via the GUI) from and to Excel format (e.g. Error in LIBNAME statement). I have several questions:
>
> 1. In what way does SAS need (parts of) the installed Excel? I mean wouldSAS be able to import from and to export to Excel format (.xls) without anexisting Excel installation? If SAS needs Excel then skip to question 7.
>
> If SAS doesn't actually need Excel then the following questions apply:
>
> 2. Why does it fail importing and exporting from/to the "old" 2003 format
> (xls) if Excel 2007 installed and files saved to old (2003) format?
>
> 3. Would it help to read the 2003 formatted Excel files with Excel 2003 and to resave them before importing to SAS?
>
> 4. Would we have to revert to Excel 2003 (deinstalling 2007)?
>
> 5. Is it possible to have both Excel 2003 and 2007 installed and working?
>
> 6. Which SAS version would be compatible with the (possibly yet deviant) 2003 format of Excel 2007?
>
> If SAS needs (parts of) an Excel installation then:
>
> 7. What is the simplest way to import and export (mainly from a batch
> program) to the XLS 2003 format with Excel 2007 installed?
>
> 8. Is it possible to have both Excel 2003 and 2007 installed and working and would SAS work correctly with Excel files that way?
>
> Regards - Jim.
> --
> Jim Groeneveld, Netherlands
> Statistician, SAS consultant
> home.hccnet.nl/jim.groeneveld
>
> My computer and I present macro Count with SPSS-like syntax at PhUSE 2008..

Do you have all the latest SAS patches installed? There was an issue
with importing Excel files that was fixed by a recent patch.
R