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
the trick:

  date=input(substr(day,index(day,',')+1),anydtdte28.);

It produced a SASDATE from "Sunday, February 21, 2010"

I learned some useful stuff!!

Regards

On Tue, 23 Mar 2010 22:48:52 -0400, Francois van der Walt
<francoisw@GJI.COM.AU> wrote:

>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:
>
>Day                        Visitors
>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
>SAS date?
>
>Kind Regards
>Francois
>
>
>On Tue, 23 Mar 2010 07:30:20 -0400, Arthur Tabachneck <art297@NETSCAPE.NET>
>wrote:
>
>>Francois,
>>
>>I haven't tried it but, according to Google:
>>
>>"Data Export
>>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"
>>
>>HTH,
>>Art
>>---------
>>On Tue, 23 Mar 2010 01:08:18 -0400, Francois van der Walt
>><francoisw@GJI.COM.AU> wrote:
>>
>>>Dear Listers,
>>>
>>>I would like to read the data that Google analytics produced into a SAS
>>dataset.
>>>
>>>Any advice??
>>>
>>>Kind Regards
>>>
>>>Francois van der Walt