Prev: 2 ways to import count data but get different results from
Next: Unneecessary quotes in proc format (was: Can't format names
From: Arthur Tabachneck on 29 Dec 2009 20:59
Boris,

A birdie offered a possible alternative solution that you really might
want to consider:

"you could suggest adding the 3 statements below prior to using the
tagset:

ods path work.tmplmst(update) sashelp.tmplmst(read);
filename tagset url 'http://support.sas.com/rnd/base/ods/odsmarkup/
excltags.tpl';
%include tagset;

This will install and use the latest publicly-available tagset (in
WORK), and not disrupt any other version already installed on their
system. Because the tagset is stored in WORK, this step only needs to
be done once per SAS session.

The complete code would look like this:

ods path work.tmplmst(update) sashelp.tmplmst(read);
filename tagset url 'http://support.sas.com/rnd/base/ods/odsmarkup/
excltags.tpl';
%include tagset;

ods listing close;
ods tagsets.ExcelXP file='Excelxp.xml';
proc reg data = final.regression_trades;
model result = return_cost holdtime_mins;
run; quit;
ods tagsets.ExcelXP close;
"

Although, I really liked the part of your post that stated that "Art's
version worked perfectly." Regardless, this particular birdie really
does know a lot more about this than I do.

Art
----------
On Dec 29, 11:21 am, "B.Abbey" <Abbe...(a)aol.com> wrote:
> Art's version worked perfectly.
>
> Andrew, I am using SAS 9.2 (on this computer - I was using another
> computer yesterday also with 9.2).
>
> On this computer I checked he tagset and I am using: (SAS 9.1.3,
> v1.75, 07/26/07). I did not get the error I received yesterday on the
> other computer but the original code I posted will not work on this
> system either. I will obtain the new tagset.
>
> I am currently on my desktop at work and my laptop has SAS installed
> (and that was the one that gave me the error message). I will post a
> screenshot of the error when I get home tonight.
>
> FYI I did see another post in this forum that states that the export
> to Excel will not work in windows x64 platforms. I have 64 bit Vista
> on this computer and XP Professional on the laptop.
>
> Boris
First  |  Prev  | 
Pages: 1 2
Prev: 2 ways to import count data but get different results from
Next: Unneecessary quotes in proc format (was: Can't format names