The Long and Winding Road to SAS Global Forum 2010
in [SAS]
|
Prev: Error in Proc Export (ERROR: Execute: Unable to insert row : )
Next: SAS/IntrNet not cleaning up sas.exe
From: Murphy Choy on 12 Feb 2010 11:09 Hi Mikeeee, I would be travelling about 17000 plus miles. Hope to catch your talk this year! ------Original Message------ From: Michael Raithel Sender: SAS(r) Discussion To: SAS-L(a)LISTSERV.UGA.EDU ReplyTo: Michael Raithel Subject: The Long and Winding Road to SAS Global Forum 2010 Sent: Feb 12, 2010 11:51 PM Dear SAS-L-ers, So, how long and winding is_YOUR_ road to SAS Global Forum 2010? Well, if you take the "winds" out of_MY_ "long and winding road", it is 2,315 miles from the sunny, snow draped SAS Mecca campus in beautiful Rockville Maryland to the Emerald City: data gointoseattle; sgf2010_dist = put(zipcitydistance(20850,98101),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; This should be a straight-forward calculation for the U.S. of A. SAS-L-ers, but those who hang their hats in other lands will likely have to go to this program: data gointoseattle; sgf2010_dist = put(geodist(39.085920,-77.174389,47.611330,-122.333219,"M"),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; Of course, many of these 'L-ers might choose to substitute "K" (kilometers) for "M" (miles) to keep the distance in their own perspective. Miles; kilometers; what's a few klicks between friends?!?!? So, will you be earning more Frequent Flyer miles/kilometers that I will in April? All, best of luck in all your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Not all who wander are lost. - J. R. R. Tolkien +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Sent from my BlackBerry Wireless Handheld -- Regards, Murphy Choy Certified Advanced Programmer for SAS V9 Certified Basic Programmer for SAS V9
From: Mike Rhoads on 12 Feb 2010 11:21 And, if you attend Mike Zdeb's talk on Monday morning, you can actually get information for everyone's "winding" (i.e. driving) roads on the way back (see below). Additional minor trivia note -- SAS Global Forum has 7 different speakers whose last names begin with the letter Z. ;-) Mike Rhoads RhoadsM1(a)Westat.com 050-2010 Driving Distances and Times Using SAS(r) and Google Maps SAS(r) 9.2 contains new functions (ZIPCITYDISTANCE, GEODIST) that allow a user to compute geodesic distance (the shortest distance between two point on the surface of a sphere). Both functions use the Vincenty distance formula. Prior to SAS 9.2, a user had to use a DATA step and write an equation to compute such distances. The most common method was to use the Haversine formula. Vincenty and Haversine distance estimates are straight line distances and there are occasions where that type of estimate is what you need. There are other occasions where what you want is not the straight line distance, but a driving distance. Given only one combination of locations, using Google Maps to get the driving distance and time is no problem. However, if you have a large number of location pairs, a FILENAME statement and the URL access method within SAS can be used to access Google Maps multiple times and extract both the driving distance and time each time the site is accessed. Speaker(s): Mike Zdeb, U(a)Albany School of Public Health Industry: Healthcare Providers Section: Coders' Corner Skill Level: Intermediate SAS user Category: Day/Time: Monday, April 12, 11:15 AM - 11:35 AM Location: WSCTC, Room 611 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Michael Raithel Sent: Friday, February 12, 2010 10:52 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: The Long and Winding Road to SAS Global Forum 2010 Dear SAS-L-ers, So, how long and winding is _YOUR_ road to SAS Global Forum 2010? Well, if you take the "winds" out of _MY_ "long and winding road", it is 2,315 miles from the sunny, snow draped SAS Mecca campus in beautiful Rockville Maryland to the Emerald City: data gointoseattle; sgf2010_dist = put(zipcitydistance(20850,98101),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; This should be a straight-forward calculation for the U.S. of A. SAS-L-ers, but those who hang their hats in other lands will likely have to go to this program: data gointoseattle; sgf2010_dist = put(geodist(39.085920,-77.174389,47.611330,-122.333219,"M"),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; Of course, many of these 'L-ers might choose to substitute "K" (kilometers) for "M" (miles) to keep the distance in their own perspective. Miles; kilometers; what's a few klicks between friends?!?!? So, will you be earning more Frequent Flyer miles/kilometers that I will in April? All, best of luck in all your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Not all who wander are lost. - J. R. R. Tolkien +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: Mike Rhoads on 12 Feb 2010 11:22 Maybe we should add special recognition at the SAS-L BOF for the attendee who travels the longest distance ... Mike Rhoads RhoadsM1(a)Westat.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Murphy Choy Sent: Friday, February 12, 2010 11:10 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: The Long and Winding Road to SAS Global Forum 2010 Hi Mikeeee, I would be travelling about 17000 plus miles. Hope to catch your talk this year! ------Original Message------ From: Michael Raithel Sender: SAS(r) Discussion To: SAS-L(a)LISTSERV.UGA.EDU ReplyTo: Michael Raithel Subject: The Long and Winding Road to SAS Global Forum 2010 Sent: Feb 12, 2010 11:51 PM Dear SAS-L-ers, So, how long and winding is_YOUR_ road to SAS Global Forum 2010? Well, if you take the "winds" out of_MY_ "long and winding road", it is 2,315 miles from the sunny, snow draped SAS Mecca campus in beautiful Rockville Maryland to the Emerald City: data gointoseattle; sgf2010_dist = put(zipcitydistance(20850,98101),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; This should be a straight-forward calculation for the U.S. of A. SAS-L-ers, but those who hang their hats in other lands will likely have to go to this program: data gointoseattle; sgf2010_dist = put(geodist(39.085920,-77.174389,47.611330,-122.333219,"M"),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; Of course, many of these 'L-ers might choose to substitute "K" (kilometers) for "M" (miles) to keep the distance in their own perspective. Miles; kilometers; what's a few klicks between friends?!?!? So, will you be earning more Frequent Flyer miles/kilometers that I will in April? All, best of luck in all your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Not all who wander are lost. - J. R. R. Tolkien +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Sent from my BlackBerry Wireless Handheld -- Regards, Murphy Choy Certified Advanced Programmer for SAS V9 Certified Basic Programmer for SAS V9
From: Mike Zdeb on 12 Feb 2010 11:21 hi Mike ... if you choose to drive ... http://www.sascommunity.org/wiki/Driving_Distances_and_Drive_Times_using_SAS_and_Google_Maps you'll find that ... DRIVING DISTANCE BETWEEN ZIPS 20850 AND 98101: 2743 MILES (TIME: 1 day 19 hours ) ps shameless self-promotion ... stop in at Coders' Corner on Monday at 11:15 AM and listen to ... Driving Distances and Times Using SAS� and Google Maps Mike Zdeb, U(a)Albany School of Public Health Paper 050-2010 SAS� 9.2 contains new functions (ZIPCITYDISTANCE, GEODIST) that allow a user to compute geodesic distance (the shortest distance between two point on the surface of a sphere). Both functions use the Vincenty distance formula. Prior to SAS 9.2, a user had to use a DATA step and write an equation to compute such distances. The most common method was to use the Haversine formula. Vincenty and Haversine distance estimates are straight line distances and there are occasions where that type of estimate is what you need. There are other occasions where what you want is not the straight line distance, but a driving distance. Given only one combination of locations, using Google Maps to get the driving distance and time is no problem. However, if you have a large number of location pairs, a FILENAME statement and the URL access method within SAS can be used to access Google Maps multiple times and extract both the driving distance and time each time the site is accessed. -- Mike Zdeb U(a)Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402-6479 F/630-604-1475 > Dear SAS-L-ers, > > So, how long and winding is _YOUR_ road to SAS Global Forum 2010? > > Well, if you take the "winds" out of _MY_ "long and winding road", it is 2,315 miles from the sunny, snow draped SAS Mecca campus in beautiful > Rockville Maryland to the Emerald City: > > data gointoseattle; > > sgf2010_dist = put(zipcitydistance(20850,98101),comma.); > > label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; > > put sgf2010_dist; > > run; > > proc print noobs data=gointoseattle label; > > run; > > This should be a straight-forward calculation for the U.S. of A. SAS-L-ers, but those who hang their hats in other lands will likely have to go to > this program: > > data gointoseattle; > > sgf2010_dist = put(geodist(39.085920,-77.174389,47.611330,-122.333219,"M"),comma.); > > label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; > > put sgf2010_dist; > > run; > > proc print noobs data=gointoseattle label; > > run; > > Of course, many of these 'L-ers might choose to substitute "K" (kilometers) for "M" (miles) to keep the distance in their own perspective. Miles; > kilometers; what's a few klicks between friends?!?!? > > So, will you be earning more Frequent Flyer miles/kilometers that I will in April? > > All, best of luck in all your SAS endeavors! > > > I hope that this suggestion proves helpful now, and in the future! > > Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or > methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or > applicability. People deciding to use information in this posting do so at their own risk. > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Michael A. Raithel > "The man who wrote the book on performance" > E-mail: MichaelRaithel(a)westat.com > > Author: Tuning SAS Applications in the MVS Environment > > Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition > http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 > > Author: The Complete Guide to SAS Indexes > http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Not all who wander are lost. - J. R. R. Tolkien > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >
From: toby dunn on 12 Feb 2010 12:17 Geez mikee we need to get you out more, calculating the distance to sgf.... ---Original Message----- Date: Friday, February 12, 2010 9:52:36 amee To: SAS-L(a)LISTSERV.UGA.EDU From: Michael Raithel <michaelraithel(a)WESTAT.COM> Subject: The Long and Winding Road to SAS Global Forum 2010 Dear SAS-L-ers, So, how long and winding is _YOUR_ road to SAS Global Forum 2010? Well, if you take the "winds" out of _MY_ "long and winding road", it is 2,315 miles from the sunny, snow draped SAS Mecca campus in beautiful Rockville Maryland to the Emerald City: data gointoseattle; sgf2010_dist = put(zipcitydistance(20850,98101),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; This should be a straight-forward calculation for the U.S. of A. SAS-L-ers, but those who hang their hats in other lands will likely have to go to this program: data gointoseattle; sgf2010_dist = put(geodist(39.085920,-77.174389,47.611330,-122.333219,"M"),comma.); label sgf2010_dist = "My Travel Distance to SAS Global Forum 2010"; put sgf2010_dist; run; proc print noobs data=gointoseattle label; run; Of course, many of these 'L-ers might choose to substitute "K" (kilometers) for "M" (miles) to keep the distance in their own perspective. Miles; kilometers; what's a few klicks between friends?!?!? So, will you be earning more Frequent Flyer miles/kilometers that I will in April? All, best of luck in all your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Not all who wander are lost. - J. R. R. Tolkien +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
Next
|
Last
Pages: 1 2 Prev: Error in Proc Export (ERROR: Execute: Unable to insert row : ) Next: SAS/IntrNet not cleaning up sas.exe |