[Air-L] Instagram hashtag in date range?

Thomas Ball xtc283 at gmail.com
Thu Jul 27 07:55:28 PDT 2017


Here's a simple example of a range-based, 'fuzzy merge' using SAS SQL. This
code is easily translated into any SQL language or code.


data one;
  input time time5.  sample;
  format time datetime13.;
  time=dhms('23nov94'd,0,0,time);
datalines;
09:01   100
10:03   101
10:58   102
11:59   103
13:00   104
14:02   105
16:00   106
;

data two;
  input time time5.  sample;
  format time datetime13.;
  time=dhms('23nov94'd,0,0,time);
datalines;
09:00   200
09:59   201
11:04   202
12:02   203
14:01   204
14:59   205
15:59   206
16:59   207
18:00   208
;

proc sql;
  create table match2 as
    select *
      from one(rename=(time=time1 sample=sample1)) full join
           two(rename=(time=time2 sample=sample2))
              on abs(time1-time2)<=5*60;
quit;


On Thu, Jul 27, 2017 at 12:26 AM, Jonathon Hutchinson <
jonathon.hutchinson at sydney.edu.au> wrote:

> Hi AoIR list,
>
> Apologies if this has been answered previously, but I can’t seem to find
> the answer elsewhere.
>
> I have an honours student who is undertaking research on #mbfwa on
> Instagram.
>
> She is looking at the hashtag within the date range of April 6 - April 10
> 2017. She is manually accessing the content, which means she has to scroll
> back through a large amount of entries to access the required content.
>
> Just wondering if anyone knows of any methods or techniques (post API
> changes) that can enable us to search an Instagram hashtag via a date range?
>
> Thanks in advance
>
> Jonathon.
> DR JONATHON HUTCHINSON | Lecturer in Online and Social Media
> Department of Media and Communications | Faculty of Arts and Social
> Sciences
> THE UNIVERSITY OF SYDNEY
> Room N233, John Woolley Building A20 | The University of Sydney | NSW |
> 2006
> T +61 2 9351 2821  | F +61 2 9351 2434
> E jonathon.hutchinson at sydney.edu.au<mailto:grant.bollmer at sydney.edu.au>
> | W jonathonhutchinson.com<http://sydney.edu.au/arts/digital_cultures/>
>
> _______________________________________________
> The Air-L at listserv.aoir.org mailing list
> is provided by the Association of Internet Researchers http://aoir.org
> Subscribe, change options or unsubscribe at: http://listserv.aoir.org/
> listinfo.cgi/air-l-aoir.org
>
> Join the Association of Internet Researchers:
> http://www.aoir.org/



More information about the Air-L mailing list