Prev: Population Stability Index - PSI
Next: Libname Function and Connection Strings
From: montura on 6 Jan 2010 09:24
Can you elaborate on how/why the excel formula get disturbed?

Kevin
From: montura on 6 Jan 2010 10:49
I'm still trying to get past the copy-and-paste part of the work
effort.
I want to know why a human needs to be involved and why a direct write
kills the excel formula.



From: Sudo Ku on 6 Jan 2010 11:40
Hi Montura:

I belIeve it was TUMU who stated the formulas became disturbed.



> Date: Tue, 5 Jan 2010 10:52:11 -0800
> From: rajiv468(a)GMAIL.COM
> Subject: SAS using advanced excel
> To: SAS-L(a)LISTSERV.UGA.EDU
>
> Hi,
>
> Im using SAS on Z/OS. I have advanced excel where i usually copy and
> paste the values from SAS table to excel.(because formulas get
> disturbed)
> Can anyone suggest me how to automate this.
>
> Regards,
> Tumu

the dde process can be setup to run as a scheduled task and therefore wouldn't require human involvement.

Regards,

Kevin


> Date: Wed, 6 Jan 2010 07:49:09 -0800
> From: monturainc(a)GMAIL.COM
> Subject: Re: SAS using advanced excel
> To: SAS-L(a)LISTSERV.UGA.EDU
>
> I'm still trying to get past the copy-and-paste part of the work
> effort.
> I want to know why a human needs to be involved and why a direct write
> kills the excel formula.

_________________________________________________________________
Windows Live: Make it easier for your friends to see what you�re up to on Facebook.
http://go.microsoft.com/?linkid=9691816
From: xlr82sas on 6 Jan 2010 16:23
On Jan 6, 8:40 am, crafty...(a)HOTMAIL.COM (Sudo Ku) wrote:
> Hi Montura:
>
> I belIeve it was TUMU who stated the formulas became disturbed.
>
> > Date: Tue, 5 Jan 2010 10:52:11 -0800
> > From: rajiv...(a)GMAIL.COM
> > Subject: SAS using advanced excel
> > To: SA...(a)LISTSERV.UGA.EDU
>
> > Hi,
>
> > Im using SAS on Z/OS. I have advanced excel where i usually copy and
> > paste the values from SAS table to excel.(because formulas get
> > disturbed)
> > Can anyone suggest me how to automate this.
>
> > Regards,
> > Tumu
>
> the dde process can be setup to run as a scheduled task and therefore wouldn't require human involvement.
>
> Regards,
>
> Kevin
>
> > Date: Wed, 6 Jan 2010 07:49:09 -0800
> > From: montura...(a)GMAIL.COM
> > Subject: Re: SAS using advanced excel
> > To: SA...(a)LISTSERV.UGA.EDU
>
> > I'm still trying to get past the copy-and-paste part of the work
> > effort.
> > I want to know why a human needs to be involved and why a direct write
> > kills the excel formula.
>
> _________________________________________________________________
> Windows Live: Make it easier for your friends to see what you re up to on Facebook.http://go.microsoft.com/?linkid=9691816

Just some ideas - may not be useful

Not sure this works with formulas, but I update excel named ranges in
an existing sheet using the libname engine.
I have predefined excel 'template' named ranges with all kinds of
formatting, ie merged cells, bolding, color..
I have not tried to predefine formulas.

All you need to do is drop the old table(named range)and repopulate.
The formulas and formatting are not dropped when you drop the table?
You have to put the data in the right cells.

libname xls excel "c:\xls\tmp.xls";
proc sql; drop table xls.class;quit;
data xls.class;
set sashelp.class;
run;

I have more info on this on my site.

http://homepage.mac.com/magdelina/.Public/utl.html
utl_tipweb.txt

/* T000160 INSERTING(IN PLACE) MULTIPLE ROWS INTO AN EXISTING EXCEL
NAMED RANGE WINDOWS ONLY
/* T003730 LITTLE KNOW TECHNIQUES FOR INERFACING WITH EXCEL UNDER
WINDOWS AND UNIX

and others





From: Sudo Ku on 7 Jan 2010 09:25
Hi XLR82SAS:

I have retrieved both programs you mentioned and will read through them a little more later. I have to admit a preference for using libname xls to import excel files and DDE/xl4ml to maniulate finished excel files. But the idea of using an SQl is possibility in future work.

Thanks for the tools.

Regards,

Kevin
> ----------------------------------------
>> Date: Wed, 6 Jan 2010 13:23:26 -0800
>> From: xlr82sas(a)AOL.COM
>> Subject: Re: SAS using advanced excel
>> To: SAS-L(a)LISTSERV.UGA.EDU
>>
>> On Jan 6, 8:40 am, crafty...(a)HOTMAIL.COM (Sudo Ku) wrote:
>>> Hi Montura:
>>>
>>> I belIeve it was TUMU who stated the formulas became disturbed.
>>>
>>>> Date: Tue, 5 Jan 2010 10:52:11 -0800
>>>> From: rajiv...(a)GMAIL.COM
>>>> Subject: SAS using advanced excel
>>>> To: SA...(a)LISTSERV.UGA.EDU
>>>
>>>> Hi,
>>>
>>>> Im using SAS on Z/OS. I have advanced excel where i usually copy and
>>>> paste the values from SAS table to excel.(because formulas get
>>>> disturbed)
>>>> Can anyone suggest me how to automate this.
>>>
>>>> Regards,
>>>> Tumu
>>>
>>> the dde process can be setup to run as a scheduled task and therefore wouldn't require human involvement.
>>>
>>> Regards,
>>>
>>> Kevin
>>>
>>>> Date: Wed, 6 Jan 2010 07:49:09 -0800
>>>> From: montura...(a)GMAIL.COM
>>>> Subject: Re: SAS using advanced excel
>>>> To: SA...(a)LISTSERV.UGA.EDU
>>>
>>>> I'm still trying to get past the copy-and-paste part of the work
>>>> effort.
>>>> I want to know why a human needs to be involved and why a direct write
>>>> kills the excel formula.
>>>
>>> _________________________________________________________________
>>> Windows Live: Make it easier for your friends to see what you re up to on Facebook.http://go.microsoft.com/?linkid=9691816
>>
>> Just some ideas - may not be useful
>>
>> Not sure this works with formulas, but I update excel named ranges in
>> an existing sheet using the libname engine.
>> I have predefined excel 'template' named ranges with all kinds of
>> formatting, ie merged cells, bolding, color..
>> I have not tried to predefine formulas.
>>
>> All you need to do is drop the old table(named range)and repopulate.
>> The formulas and formatting are not dropped when you drop the table?
>> You have to put the data in the right cells.
>>
>> libname xls excel "c:\xls\tmp.xls";
>> proc sql; drop table xls.class;quit;
>> data xls.class;
>> set sashelp.class;
>> run;
>>
>> I have more info on this on my site.
>>
>> http://homepage.mac.com/magdelina/.Public/utl.html
>> utl_tipweb.txt
>>
>> /* T000160 INSERTING(IN PLACE) MULTIPLE ROWS INTO AN EXISTING EXCEL
>> NAMED RANGE WINDOWS ONLY
>> /* T003730 LITTLE KNOW TECHNIQUES FOR INERFACING WITH EXCEL UNDER
>> WINDOWS AND UNIX
>>
>> and others
>
> _________________________________________________________________
> Eligible CDN College & University students can upgrade to Windows 7 before Jan 3 for only $39.99. Upgrade now!
> http://go.microsoft.com/?linkid=9691819

_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
http://go.microsoft.com/?linkid=9691817
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Population Stability Index - PSI
Next: Libname Function and Connection Strings