I am trying to send a sas dataset to google analytics for optimisation, has someone done it before or any pointer would be much appreciated.
Thank you in advance.
Is this a one-time process? Or something ongoing?
Perhaps if you provide a link to the Google Analytics documentation that describes how this data is to be formatted/sent, someone here can advise how you might transmit the records from your SAS data set appropriately.
Chris, It will be an ongoing process and ideally automated one so any format that is easier would be good.
My understanding is that to do this programmatically I should use the google Analytics measurement protocol
Thanks for that reference. SAS has a procedure called PROC HTTP that allows you to send data to web sites and interact with web-based APIs like this. I don't have any experience with this Google Analytics API so I can only guess at some things, but here is an example that uses some fields from an example in the Google Analytics developer's guide.
%macro echoResp(fn=); data _null_; infile &fn; input; put _infile_; run; %mend; filename resp temp; /* v=1 // Version. &tid=UA-XXXXX-Y // Tracking ID / Property ID. &cid=555 // Anonymous Client ID. &t= // Hit Type. */ proc http url='http://www.google-analytics.com/v=1&tid=UA-XXXXX-Y&cid=555&t=pageview&dp=%2Fhome' method='POST' out=resp ; run; /* Echo response content to the log */ %echoResp(resp);
You would need to form one call per record, or you can create a "batch" style call per the Google Analytics guide to issue multiple records within a single HTTP call.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.