| Date: | Mon, 19 Jun 2006 13:15:41 +0200 |
|---|
| Reply-To: | Stéphane Colas <saslist@DATAMETRIC.FR> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Stéphane Colas <saslist@DATAMETRIC.FR> |
|---|
| Subject: | Re: Create a pivot table |
|---|
|
| In-Reply-To: | <1150552919.929360.175840@f6g2000cwb.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
I've found this paper interesting to read.
www2.sas.com/proceedings/sugi31/035-31.pdf
HTH
--
Stéphane.
http://www.datametric.fr
(translated).
Selon rakulak@GMAIL.COM:
> Hi,
>
> I read Phil Mason and Ted's Tips or paper on how to create a pivot
> table from SAS by using VBA. Does anyone have a idea how to use DDE
> and Excel's macro such as:
>
> pivot.table.wizard()
> pivot.add.fields()
> pivot.add.data()
> ...
>
> I thought they could make the SAS code short and neat, but I haven't
> make them worked yet.
> Thank you for your help!
>
> Allan
>
| 
