topic Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018 in SAS Global Forum 2018

How Far Are You Willing To Go To Get To SAS Global Forum 2018

MMMIIIIKKKKEEEE — Fri, 06 Apr 2018 13:19:43 GMT

SAS Programming Professionals,

I am looking forward to catching up with each and every one of you at the end of my 1,484 mile trip to Denver!

How do I know that it is 1,484 miles you ask? Well, I used the ZIPCITYDISTANCE function in this handy program to calculate my mileage:

/* Distance to Denver using US Zip Codes */

data gointodenver;

denver_dist = put(zipcitydistance(20850,80202),comma.);

label denver_dist = "My Travel Distance from Rockville to Denver";

run;

proc print noobs data=gointodenver label;

run;

Ah, I see my International friends shaking their heads because US Zip Codes don't really apply to them. No worries; I've got you covered! Get out your atlas, look up your longitude and latitude, and plug them into the GEODIST function in this program:

/* Distance to Denver using Longitude and Latitude */
data gointodenver;

denver_dist = put(geodist(39.085920,-77.174389,39.7392,104.9903,"M"),comma.);

label denver_dist = "My Travel Distance From Rockville to Denver";

run;

proc print noobs data=gointodenver label;

run;

Oh right; you like Kilometers more than Miles. Okay, then change the "M" to "K" and you've got it.

So, how far are Y-O-U willing to go to get to SAS Global Forum 2018?????

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

ptimusk — Fri, 06 Apr 2018 13:36:19 GMT

SAS Output

The SAS System

My Travel Distance >From Ottawa to Denver
1,534 Miles

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

LauraJean — Fri, 06 Apr 2018 13:40:29 GMT

Very cool code. I came up with 845 miles from McFarland WI to Denver Co.

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

ChrisHemedinger — Fri, 06 Apr 2018 13:44:32 GMT

Got a head start on you @MMMIIIIKKKKEEEE!

My Travel Distance from Raleigh to Denver
1,457

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

paulkaefer — Fri, 06 Apr 2018 13:44:46 GMT

Looks like I'm only going about half as far as you, @MMMIIIIKKKKEEEE. Keep in mind, I'm still a new SAS professional 🙂

SAS Output

My Travel Distance from Minneapolis to Denver
699

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

ShelleySessoms — Fri, 06 Apr 2018 13:47:17 GMT

Woo hoo! I can participate in this without being able to run the code. 🙂

If @ChrisHemedinger's distance is 1,457, then so is mine.

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

Vince_SAS — Fri, 06 Apr 2018 13:51:54 GMT

@ChrisHemedinger and @ShelleySessoms are taking the long way. My flight itinerary says it's only 1,445 miles

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

MMMIIIIKKKKEEEE — Fri, 06 Apr 2018 13:55:49 GMT

Chris,

Then, I guess we won't be sharing a taxi into town this year:-)!

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

hollandnumerics — Fri, 06 Apr 2018 13:55:53 GMT

I had to split my journey up, because we're driving to Gatwick tonight, then flying from Gatwick to Denver tomorrow, but I've left the distance in miles for easier comparison, but I'm sure I'll be beaten by the Aussies:

My Travel Distance From Royston to Gatwick	My Travel Distance From Gatwick to Denver	My Travel Distance From Royston to Denver
62	4,725	4,787

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

MMMIIIIKKKKEEEE — Fri, 06 Apr 2018 13:57:23 GMT

Shelley,
Hey, no fair!!!!

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

MMMIIIIKKKKEEEE — Fri, 06 Apr 2018 13:58:53 GMT

Paul,

It's not how far you travel; it's where you get to in the end that counts.

Um, at least that is what the meme on LinkedIn said...

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

MMMIIIIKKKKEEEE — Fri, 06 Apr 2018 14:01:51 GMT

Nicely done, Phil!
I'll bet that you get 3-times the benefits that I do from SAS Global Forum 2018--if distance traveled is any indicator...

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

sasus1 — Fri, 06 Apr 2018 14:03:20 GMT

My distance seems to be the shortest ..;-)

57107 to 80202

499 miles

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

ChrisHemedinger — Fri, 06 Apr 2018 14:03:33 GMT

Don't forget your commute to the airports @Vince_SAS.

RDU's ZIP code is 27560. It's ZIP code center is 5 miles closer than my home ZIP of 27613.

DEN's airport ZIP code is 80249, making it even closer. ZIP distance between the airports is 1,439 miles.

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

FriedEgg — Fri, 06 Apr 2018 14:05:47 GMT

Making a small adaption to the code I posted in a similar thread last year

Furthest Great Circle Distance to Denver, CO


City	Country	Distance (km)
Curepipe	Mauritius	17272.8

Location data from mapsgfk.world_cities

The furthest more populous area would, similar to Orlando, FL would be on the Western shore of Australia.

Personally, my travel distance is about 2,580km but had this been a few years ago, when I lived in Denver, it would've been easily walkable.

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

AaroninMN — Fri, 06 Apr 2018 20:10:45 GMT

695 Miles when calculating with ZipCityDistance, 694 when using GEODIST.

Thanks for posting this topic. I am presenting my E-poster on Monday with my topic being how I drew inspiration from a similar thread on who was traveling the furthest to last year's Global Forum. I implemented changes to a marketing program that increased sales by a million dollars. Similar code that you (MMMMIIIIKKKKEE) posted last year was an inspiration and I mention you and your post in my slides and paper.

My E-Poster presentation is on Monday at 1:30 and is titled: From Idea to Implementation: How a SAS Communities Thread Changed How Sleep Number Direct Markets.

Please stop by if you have a chance.

Best,

Aaronu

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

ChrisHemedinger — Fri, 06 Apr 2018 14:17:47 GMT

That topic sounds awesome @AaroninMN -- I'll definitely stop by for that!

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

dgritt — Fri, 06 Apr 2018 14:26:01 GMT

My Travel Distance from Des Moines to Denver
603

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

MMMIIIIKKKKEEEE — Fri, 06 Apr 2018 14:28:21 GMT

Aaron,

Wow; that is really great!

Thank you for the feedback; I am glad to have been able to provide the seed of an idea that you capitalized on.

Looking forward to meeting you at on Monday at 1:30!

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

agparsons — Fri, 06 Apr 2018 14:32:27 GMT

My Travel
Distance from
Portland ME
to Denver
1,778