Date: Wed, 24 Mar 2010 02:45:03 -0400
Reply-To: Francois van der Walt <francoisw@GJI.COM.AU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Francois van der Walt <francoisw@GJI.COM.AU>
Subject: Re: Google analytics read into SAS
Thanks to everybody that responded directly to me.
Just for everybody's information the following combination of functions did
It produced a SASDATE from "Sunday, February 21, 2010"
I learned some useful stuff!!
On Tue, 23 Mar 2010 22:48:52 -0400, Francois van der Walt
>Woohoo, I got some data!
>On the Google Analytics page towards the top left is an option to export the
>data. One can choose between PDF, XML, CSV, CSV for Excel, TSV. One can also
>choose to e-mail it to a recipient. I emailed the CSV version.
>Would any of the other versions be better?
>Next step, Opening the data in excel one gets:
>Sunday, February 21, 2010 9
>Monday, February 22, 2010 45
>Tuesday, February 23, 2010 40
>Any clever listers with a neat SAS function to convert the Day field into a
>On Tue, 23 Mar 2010 07:30:20 -0400, Arthur Tabachneck <art297@NETSCAPE.NET>
>>I haven't tried it but, according to Google:
>>Export your data with the Google Analytics Data Export API or email and
>>export your data directly from the Google Analytics interface into Excel,
>>CSV, PDF and tab delimited files"
>>On Tue, 23 Mar 2010 01:08:18 -0400, Francois van der Walt
>>>I would like to read the data that Google analytics produced into a SAS
>>>Francois van der Walt