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 12:20
Hi mike,

Thanks. But I think we should give recognition on merit of SAS skills rather than the endurance of crossing the pacific/atlantic ocean.

Sent from my BlackBerry Wireless Handheld

--
Regards,
Murphy Choy

Certified Advanced Programmer for SAS V9
Certified Basic Programmer for SAS V9


-----Original Message-----
From: Mike Rhoads <RHOADSM1(a)WESTAT.com>
Date: Fri, 12 Feb 2010 11:22:55
To: goladin(a)gmail.com<goladin(a)gmail.com>; SAS-L(a)LISTSERV.UGA.EDU<SAS-L(a)LISTSERV.UGA.EDU>
Subject: RE: The Long and Winding Road to SAS Global Forum 2010

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: Mary on 12 Feb 2010 12:33
--- msz03(a)ALBANY.EDU wrote:

From: Mike Zdeb <msz03(a)ALBANY.EDU>
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: Re: The Long and Winding Road to SAS Global Forum 2010
Date: Fri, 12 Feb 2010 11:21:01 -0500

Prior to SAS 9.2, a user had to use a DATA step and write an equation
to compute such distances.

***************
Mike,

Yes, that is the case, and many of us don't yet have 9.2.

And thus here is the 9.1.3 solution (put in your zip code as the home zip code in the code below, don't know what to do about overseas guests).

proc contents data=sashelp.zipcode;
run;

data zipcodes;
set sashelp.zipcode;
run;

data set1;
informat id 8. home_zip 8. dest_zip 8.;
format home_zip z5. dest_zip z5.;
infile cards missover;
input id home_zip dest_zip;
cards;
001 52402 98101
;
run;

proc sql noprint;
create table set2 as
select set1.*,
zipcodes.x as home_zip_x,
zipcodes.y as home_zip_y
from set1
left outer join
zipcodes
on set1.home_zip=zipcodes.zip
order by id;
quit;

proc sql noprint;
create table set3 as
select set2.*,
zipcodes.x as service_zip_x,
zipcodes.y as service_zip_y
from set2
left outer join
zipcodes
on set2.dest_zip=zipcodes.zip
order by id;
quit;

data distances;
set set3;
home_zip_long=atan(1)/45*home_zip_x;
home_zip_lat=atan(1)/45*home_zip_y;
service_zip_long=atan(1)/45*service_zip_x;
service_zip_lat=atan(1)/45*service_zip_y;

Dist = 3949.99 * arcos(sin(home_zip_lat) * sin(service_zip_lat) +
cos(home_zip_lat) * cos(service_zip_lat) *
cos(home_zip_long - service_zip_long));
run;

proc print data=distances;
run;


Many thanks to SAS-L for helping me figure this out a few months ago!

-Mary
From: Michael Raithel on 12 Feb 2010 12:48
Dear SAS-L-ers,

Mike Rhoads posted the following:

>
> Maybe we should add special recognition at the SAS-L BOF for the
> attendee who travels the longest distance ...
>
Mike, good idea! We could create a new award named the TRAVEL:

Travel
Route
Available
Vexingly
Extra
Long

Mike, 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

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kilometers are shorter than miles. Save gas, take your next
trip in kilometers. - George Carlin
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: Arthur Tabachneck on 12 Feb 2010 14:54
I don't have anything to add to the discussion but, since we're into
shameless promotion and trivia:

Shameless promotion: See how a SAS-L post can turn into a (I think) nice
paper, come earlier to coder's corner (10:30 on Monday, Room 611) and
listen to: Automagically Copying and Pasting Variable Names

then, since you'll already be there, stay around for Mike's presentation.

Trivia: If you don't count "y" as a vowel, there are a total of two
presenters at this year's SGF who don't have any vowels in their last name.

Art
--------
On Fri, 12 Feb 2010 11:21:01 -0500, Mike Zdeb <msz03(a)ALBANY.EDU> wrote:

>hi Mike ... if you choose to drive ...
>
>http://www.sascommunity.org/wiki/Driving_Distances_and_Drive_Times_using_S
AS_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
>> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
First  |  Prev  | 
Pages: 1 2
Prev: Error in Proc Export (ERROR: Execute: Unable to insert row : )
Next: SAS/IntrNet not cleaning up sas.exe