These 2 samples from SAS' maps online website might help: http://support.sas.com/rnd/datavisualization/mapsonline/html/us-project6.html http://support.sas.com/rnd/datavisualization/mapsonline/html/us-project8.html ... View more

By default, gchart included zero in the response axis, and it is generally the "best practice" to do that. SAS does provide a way to over-ride the default with an axis statement (but make sure this is really/really/really sure this is what you want to do, and is a good way to display your data, before doing it!) data foo; barnum=_n_; input a; datalines; 60 70 60 100 120 110 ; run; axis1 order=(40 to 150 by 10); proc gchart data=foo; vbar barnum / discrete type=sum sumvar=a raxis=axis1; run; ... View more

One way to do 2 bars (aka, a "grouped bar chart") and a line is to use "proc gchart" to draw the bars, and use "annotate" to draw the line (this requires intermediate, to advanced, programming). Here's a minimal/simple example: http://robslink.com/SAS/democd29/barline.htm http://robslink.com/SAS/democd29/barline_info.htm ... View more

You might also look into "proc gbarline" for simple bar charts (ie, not grouped/paired bars) with lines overlaid. For both gbarline, and sgplot, you'll need a fairly recent version of SAS - I would recommend using the most recent version, as both of these fairly new procs had a lot of enhancements in 9.2. ... View more

I 'think' that's what it does, but I haven't really checked it out thoroughly. Your mission, should you choose to accept it ... Find out the definitive answer, and let us all know! 🙂 ... View more

If you don't specify a length for a variable (in a length statement), it defaults to the length of the first value you assign to it. In this case, I suspect you're assigning ... text='X'; and this will make it default to a length of 1 character (which is too short for the other values you want to put into the text variable. You can define it as a longer length by adding a length statement near the beginning of your data step, such as ... length text $100; ... View more

Basically, you just have to add a test in the data step to see if it's the first observation for the city, and output an extra text (city label) at a higher position, in addition to the regular text. data users; length city name $50; statecode='NC'; city='Cary'; name='Robert'; output; statecode='NC'; city='Cary'; name='Ed'; output; statecode='NC'; city='Asheville'; name='Bill'; output; run; proc sql; create table users as select users.*, uscity.x, uscity.y from users left join maps.uscity on (users.statecode=uscity.statecode) and (users.city=uscity.city); quit; run; proc sort data=users out=users; by statecode city; run; data users; set users; by statecode city; if first.city then count=0; count+1; run; data anno_users; set users; length style $50; xsys='2'; ysys='2'; position='b'; when='a'; function='label'; color='black'; if count=1 then do; style='albany amt/bold'; position='2'; text=trim(left(city)); output; end; y=y-((count-1)*.013); style='albany amt'; position='5'; text=trim(left(name)); output; run; pattern value=solid color=white; proc gmap data=maps.us map=maps.us anno=anno_users; id state; choro state / levels=1 coutline=gray; run; ... View more

I've put together a little sample that should show you a basic technique for doing this: data users; length city name $50; statecode='NC'; city='Cary'; name='Robert'; output; statecode='NC'; city='Cary'; name='Ed'; output; statecode='NC'; city='Asheville'; name='Bill'; output; run; proc sql; create table users as select users.*, uscity.x, uscity.y from users left join maps.uscity on (users.statecode=uscity.statecode) and (users.city=uscity.city); quit; run; proc sort data=users out=users; by statecode city; run; data users; set users; by statecode city; if first.city then count=0; count+1; run; data anno_users; set users; xsys='2'; ysys='2'; position='b'; when='a'; function='label'; color='black'; y=y-((count-1)*.015); text=trim(left(name)); run; pattern value=solid color=white; proc gmap data=maps.us map=maps.us anno=anno_users; id state; choro state / levels=1 coutline=gray; run; ... View more

Annotated doesn't have any automated collision-avoidance (ie, no easy/automated solution). You would have to programmatically detect the locations with multiple users at the same location, and programmatically add an x-offset to the text for each of the multiple users. ... View more

I'm not sure exactly where your code goes wrong, but here is what I believe to be the corrected version (with hover-text to see the lat/long of each annotated point, and drilldowns for each point to see where google maps would plot that point ... to help validate whether they're in the correct location): data world; set maps.world; label x='x'; label y='y'; x=long; y=lat; run ; data ob_anno; input lat long; /* convert lat/long from degrees to radians, so they are same as map */ /* also, multiply longitude by -1, so it is 'westlong' like the map */ x=atan(1)/45*long*-1; y=atan(1)/45*lat; flag=1; datalines; 32.1404 -5.44198 32.4662 -5.05228 32.4662 -5.43449 32.4662 -5.78729 32.4913 -4.28729 32.4913 -4.69890 32.8422 -3.86762 32.8422 -4.27922 32.8422 -4.66143 32.8422 -5.04364 32.8422 -5.42584 33.1932 -4.24175 33.1932 -5.03556 33.2182 -4.62338 33.5441 -4.61589 33.5441 -5.38030 33.5441 -6.14471 33.5692 -3.88030 33.5692 -4.23311 33.5692 -4.99752 33.5943 -3.52692 33.8951 -3.84341 33.8951 -4.22561 33.8951 -4.57842 33.8951 -4.99002 33.8951 -6.16604 33.9201 -3.49002 33.9201 -5.37165 33.9201 -5.75386 34.2711 -4.62857 34.2711 -4.98138 34.2961 -3.80478 34.2961 -5.77461 34.5970 -3.47446 34.5970 -4.20947 34.5970 -4.62108 34.6220 -3.85609 34.9479 -3.46639 34.9479 -5.34802 34.9730 -3.84802 34.9730 -4.25962 34.9730 -4.55363 34.9730 -4.93583 35.2738 -5.39932 35.3239 -4.95716 35.6498 -4.94967 35.6498 -5.33188 36.3767 6.41563 36.3767 6.00402 36.3767 -4.90355 36.3767 -5.31516 36.4018 4.50517 36.4018 4.12297 36.4018 3.32915 36.4269 3.74134 36.7277 6.77650 36.7277 6.01209 36.7277 5.62988 36.7277 3.74826 36.7277 -4.57208 36.7277 -4.89548 36.7527 6.45367 36.7527 4.54264 36.7527 4.10164 36.7527 -5.33591 36.8280 8.77804 36.9032 -4.30344 37.0786 6.81397 37.0786 -4.18180 37.1037 6.46174 37.1037 -3.03460 37.1037 -3.44621 37.1037 -3.79902 37.1037 -7.23887 37.4546 -3.46754 37.4546 -3.76154 37.4546 -6.49579 37.4546 -7.23080 37.4797 -2.29095 37.4797 -3.05536 37.4797 -7.58303 37.5048 -2.61377 37.5048 -6.87684 37.8056 -2.60686 37.8056 -7.54613 37.8306 -2.28287 37.8306 -3.04729 37.8306 -3.42949 37.8306 -4.54671 37.8306 -4.89952 37.8306 -5.34052 37.8306 -7.19275 37.8808 -3.75174 38.1565 -7.47926 38.1816 -1.92200 38.1816 -2.27480 38.1816 -2.59821 38.1816 -3.77423 38.1816 -4.15643 38.1816 -4.53864 38.2067 -2.97984 38.2067 -3.39145 38.5325 -7.52942 38.5325 -7.94102 38.5576 -2.26616 38.5576 -3.00117 38.5576 -4.88280 38.8584 -4.87588 38.8584 -6.37530 38.8835 -1.11204 38.8835 -4.11089 38.8835 -4.49310 38.8835 -5.90432 38.8835 -7.13914 38.8835 -7.49194 38.9085 -0.78806 38.9085 -1.49367 38.9085 -3.72811 38.9085 -7.93238 38.9336 0.41793 39.1843 -6.42661 39.2094 -1.51616 39.2094 -4.48560 39.2094 -4.86781 39.2344 -1.86839 39.2344 -2.25059 39.2344 -6.01385 39.2344 -6.74886 39.2344 -7.13107 39.2595 -3.74944 39.2595 -4.13164 39.2595 -7.51270 39.2595 -7.86550 39.3096 -1.10224 39.5603 1.69656 39.5603 -6.35916 39.5854 -1.09590 39.5854 -1.50751 39.5854 -1.88972 39.5854 -2.27192 39.5854 -4.47696 39.5854 -6.74079 39.5854 -7.12300 39.5854 -7.50520 39.9363 2.61663 39.9363 -0.73503 39.9363 -1.11723 39.9363 -1.49944 39.9363 -4.08668 39.9363 -4.49829 39.9363 -4.85109 39.9363 -5.96831 39.9363 -6.35051 39.9363 -6.76212 39.9363 -7.49713 39.9614 -1.88107 39.9614 -2.26327 39.9614 -2.55728 39.9614 -7.11435 40.2873 -0.72696 40.2873 -1.10916 40.2873 -1.49137 40.2873 -1.87357 40.2873 -2.25578 40.2873 -2.54978 40.2873 -6.72465 40.2873 -7.10686 40.2873 -7.48906 40.3123 6.85894 40.3123 -3.69583 40.3123 -4.07803 40.3123 -4.46024 40.3123 -4.87184 40.3123 -5.25405 40.3123 -5.60686 40.3123 -5.98906 40.3123 -6.34187 40.6633 -0.30670 40.6633 -6.01039 40.6883 -0.71773 40.6883 -1.09994 40.6883 -2.24656 40.6883 -2.54056 40.6883 -4.86320 40.6883 -5.24540 40.6883 -5.62761 40.6883 -6.36262 40.6883 -6.74483 40.6883 -7.09763 40.6883 -7.47984 40.7134 6.86816 40.7134 6.48596 40.7134 6.10375 40.7134 -1.48157 40.7134 -1.86377 40.7134 -2.92219 40.7134 -3.33380 40.7134 -3.68660 40.7134 -4.09821 40.7385 -4.45044 41.0393 -0.29806 41.0393 -4.09071 41.0393 -4.44352 41.0393 -5.23733 41.0393 -6.00174 41.0393 -6.35455 41.0393 -6.70736 41.0393 -7.08956 41.0393 -7.47177 41.0643 6.46463 41.0643 0.08473 41.0643 -1.06189 41.0643 -1.85570 41.0643 -2.23791 41.0643 -2.56131 41.0643 -2.94352 41.0643 -3.35513 41.0643 -3.70793 41.0643 -4.85455 41.0643 -5.61896 41.0894 6.84741 41.0894 -1.47292 41.3651 0.09164 41.3902 0.47443 41.3902 -1.05440 41.3902 -4.43545 41.3902 -5.22926 41.3902 -5.99367 41.3902 -6.34648 41.3902 -6.72869 41.4153 9.91255 41.4153 0.85721 41.4153 -1.43603 41.4153 -2.55324 41.4153 -2.90605 41.4153 -3.67046 41.4153 -4.05267 41.4153 -4.84648 41.4153 -5.61089 41.4153 -7.08091 41.4153 -7.46312 41.4404 -3.34648 41.7412 9.50844 41.7412 9.12623 41.7412 1.24691 41.7412 0.89411 41.7412 0.48250 41.7412 -2.22234 41.7412 -2.54575 41.7412 -2.89855 41.7412 -3.31016 ; run; data all; set world ob_anno; run; proc gproject data=all out=all_projected latmin=30 latmax=55 longmin=-15 longmax=10 project=hammer dupok; id id; run; data world_projected ob_anno_projected; set all_projected; if flag=1 then output ob_anno_projected; else output world_projected; run ; /* Add the annotate variables after the grpoject (so the gproject will be lean & fast). */ data ob_anno_projected; set ob_anno_projected; length function color style $8 html $500; xsys='2'; ysys='2'; when='a'; function='pie'; size=0.2; rotate=360; color='red'; style='psolid'; output; html='title='||quote('lat: '||trim(left(lat))||', '||'0d'x||'long:'||trim(left(long)))|| ' href='||'http://maps.google.com/maps?ie=UTF8&ll='||trim(left(lat))||','||trim(left(long))||'&z=8'; color='gray'; style='pempty'; output; run; %let name=map; filename odsout '.'; goptions device=png xpixels=1200 ypixels=1200; goptions gunit=pct ftitle="arial/bo" ftext="arial" htitle=5 htext=3 ; ODS LISTING CLOSE; ODS HTML path=odsout body="&name..htm" style=minimal; pattern1 c=cx7f00ff v=solid; proc gmap data=world_projected map=world_projected; id id; choro id / nolegend levels=1 coutline=graycc anno=ob_anno_projected des='' name="&name"; run; quit; Message was edited by: Robert Allison @ SAS ... View more

It would really help if you could provide me with *one* data point that is very noticeably in the wrong location - otherwise I'll just be picking one at random (and I might randomly pick one that was not so bad). ... View more

Also, can you provide an example of 1 specific data point that's showing up in the wrong location? ... View more

As Darrell said, it's difficult to debug the problem, without the data to run the code & try out a few things. Here are 2 working examples that might help: This first example sounds like basically what you're doing ... applying an offset and re-scaling 1 map area: http://robslink.com/SAS/democd1/explod.htm http://robslink.com/SAS/democd1/explod_info.htm This second one uses a different technique ... using 'proc greplay' to draw the map in the inset area: http://robslink.com/SAS/democd41/peru_desert.htm http://robslink.com/SAS/democd41/peru_desert_info.htm Message was edited by: Robert Allison @ SAS ... View more