Date: Wed, 18 Nov 2009 13:12:46 -0600
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: ODS output to Excel
In-Reply-To: <he1fci$8fb$1@pesto.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1
If you select 'Yes' then it should open up okay, I'd think... at least for
me.
-Joe
On Wed, Nov 18, 2009 at 12:45 PM, Steve Cramer <cramer@uga.edu> wrote:
> You're right. The first line of the file is
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> Excel 2003 opens it fine, but I do get a message from Excel 2007 that
> it's not an Excel file and should I open it anyway.
>
> Thanks,
> Steve
>
>
> Joe Matise wrote:
>
>> You've never been producing an excel formatted file, in the sense of 'an
>> Excel Binary file' or even OfficeML or whatever the 2003 format is.
>> You've
>> always been producing a web page; excel simply reads that in and figures
>> things out on its own what should match up to what. Open it up in a text
>> editor if you want to see what's under the hood :)
>>
>> As I have no problem with Excel 2007 reading HTML files, you may have some
>> setting incorrect on the input; Excel 2007 is a bit pickier about the
>> extension, and if it sees .xls and then sees an HTML file, it tends to
>> give
>> you a warning. It's possible your security settings prevent it from being
>> loaded properly in that case.
>>
>> You might try ODS TAGSETS.EXCELXP - that will produce XML files, which you
>> can use .XML for, and excel is typically the default tool for opening XML
>> files on many machines; if not, it's easy to open it in excel and convert
>> it
>> via 'Save As...'.
>>
>> -Joe
>>
>> On Wed, Nov 18, 2009 at 11:22 AM, Steve Cramer <cramer@uga.edu> wrote:
>>
>> I have been running programs for several years using syntax like this:
>>>
>>> ODS HTML FILE="HSGT_INVALIDFORMCODES_WINTER09.XLS"
>>> RS=NONE STYLE=MINIMAL;
>>> PROC PRINT DATA=OUT NOOBS;
>>> VAR SCHOOL SCHCODE STUDENT GTID LITHCODE ELA_FORM SCI_FORM;
>>> TITLE "INVALID HSGT FORM CODES WINTER, 2009";
>>> TITLE2 "CORRECT AND RETURN";
>>> RUN;
>>> ODS HTML CLOSE;
>>> RUN;
>>>
>>> It produced plain vanilla .xls files. Then I installed MS Office 2007.
>>> Now I get .xls files, but formatted as web pages. Short of uninstalling
>>> Office 2007 (which may be impossible) can I get a PROC PRINT output into
>>> an Excel file formatted as a spreadsheet?
>>>
>>> Thanks,
>>> Steve
>>> --
>>> Stephen E. Cramer, Ph.D.
>>> Associate Director
>>> Georgia Center for Assessment /
>>> Test Scoring and Reporting Services
>>> University of Georgia
>>> 1985 New Jimmy Daniel Road
>>> Athens, GA 30602-9593
>>> 706-542-5589
>>> 888-392-8977
>>> 706-542-5681 Fax
>>>
>>>
>
> --
> Stephen E. Cramer, Ph.D.
> Associate Director
> Georgia Center for Assessment /
> Test Scoring and Reporting Services
> University of Georgia
> 1985 New Jimmy Daniel Road
> Athens, GA 30602-9593
> 706-542-5589
> 888-392-8977
> 706-542-5681 Fax
>
| 
