topic Re: Anyone need a diversion? in SAS Programming

Anyone need a diversion?

art297 — Thu, 19 Apr 2012 23:54:17 GMT

The SGF on-line agenda builder, this year, doesn't have a button to push that will allow one to transfer their personal schedule to their Outlook, Google, or phone calendar. Surely it can't be too difficult a program to write. Anyone up to the challenge? (p.s. you only have until tomorrow if anyone is going to be able to use it!)

Re: Anyone need a diversion?

Reeza — Fri, 20 Apr 2012 00:00:22 GMT

That's what the apps for isn't it?

Re: Anyone need a diversion?

art297 — Fri, 20 Apr 2012 00:07:33 GMT

Nope! The app is only (I think) for iphones and only includes sas author presentations. Not the bulk of presentations that are really offered!

Re: Anyone need a diversion?

Cynthia_sas — Fri, 20 Apr 2012 04:33:09 GMT

Hmmm -- did you allow the app to sync??? I just went into the app and clicked sessions and can see the sessions by non-SAS authors. So my version of the app seems to have more than just SAS authors.

cynthia

Re: Anyone need a diversion?

art297 — Fri, 20 Apr 2012 12:13:47 GMT

Apparently an update was issued that corrected the situation. However, I still would have liked code for downloading to Outlook and/or Google calendar. That always used to be included as part of the agenda builder's capabilities.

Re: Anyone need a diversion?

art297 — Fri, 20 Apr 2012 20:26:31 GMT

It's a bit late, and I don't have time to put it all together, but I found a 2009 paper by Clarke Thacher that does exactly what I had in mind: http://support.sas.com/resources/papers/proceedings09/086-2009.pdf

Re: Anyone need a diversion?

FriedEgg — Fri, 20 Apr 2012 21:30:13 GMT

I just saw this. Would have been fun to work on... The iPhone app was indeed updated and now has all the papers and can send you calender items, it is very nice.

Re: Anyone need a diversion?

art297 — Fri, 20 Apr 2012 21:43:14 GMT

If you have an IPhone. I've still got another year remaining on my current cell phone plan. See you in Orlando!

Re: Anyone need a diversion?

FriedEgg — Fri, 20 Apr 2012 22:09:34 GMT

Valid point. I am almost through with a solution.

Re: Anyone need a diversion?

art297 — Fri, 20 Apr 2012 22:41:28 GMT

Hey, if you can get it ready on time, I'd be quite happy test test it, run it, and load the results on my quite non-iphone. Too late for a paper this year, but 2013 isn't that far away

Re: Anyone need a diversion?

FriedEgg — Fri, 20 Apr 2012 23:07:53 GMT

barely tested, I do not expect it to be fully functional.

filename sgf url 'http://sgf2012.confnav.com/sgf2012/web/sessions/date/view.html';

data foo;

if _n_=1 then day='21APR2012'd;

id+1;

infile sgf lrecl=32767 truncover firstobs=62 obs=582;

input @;

_infile_=tranwrd(left(prxchange('s/<[^>]+>|\x26nbsp;/ /o',-1,_infile_)),'®',' ');

format start_time end_time time.;

start_time=input(scan(_infile_,1,'2D09'x,'r'),time.);

end_time=input(scan(_infile_,2,'2D09'x,'r'),time.);

title=scan(_infile_,2,'09'x,'r');

array author[3:9] $ 256 author1-author7;

do _n_=3 to countw(_infile_,'09'x)-1;

author[_n_]=scan(_infile_,_n_,'09'x,'r');

if author[_n_]='Gaylord Palms Resort,' then call missing(author[_n_]);

end;

room=scan(_infile_,_n_,'09'x,'r');

if lag(end_time)-start_time>13000 then day+1;

run;

filename ics '/path/to/write.ics';

data bar;

set foo(where=(id=1));

start_dt=dhms(day,hour(start_time),minute(start_time),0);

end_dt=dhms(day,hour(end_time),minute(end_time),0);

* file ics;

put 'BEGIN:VCALENDAR' /

'PRODID:-//http://sgf2012.confnav.com' /

'BEGIN:VEVENT' /

'DTSTART:' start_dt B8601DZ20. /

'DTEND:' end_dt B8601DZ20. /

'LOCATION:' room /

'DESCRIPTION:' title /

'Start Time:' start_dt mdyampm17. /

'End Time:' end_dt mdyampm17. /

'PRIORITY:3' /

'END:VEVENT' /

'END:VCALENDAR'

;

run;