About P5C768

P5C768 · ‎04-12-2013

I am trying to map some street addresses and have them show up as icons (stars) using the maps.us table as my mapping table and the annotate process. I've found some great examples of what I want to do online: SAS/GRAPH(R) 9.2: Reference, Second Edition http://www.nesug.org/proceedings/nesug08/np/np05.pdf However, I can't seem to get my locations to show up. Here is my process: proc geocode method=STREET data=temp out=GEOCODED lookupstreet=SASHELP.GEOEXM attributevar=(TRACTCE00); run; data anno; set GEOCODED; length function style color text $8; format X Y comma12.10; xsys='2'; ysys='2'; hsys='3'; when='A'; function = 'label'; style='special'; text='M'; color='Red'; size=5; position='E'; segment=1; x=atan(1)/45 * x; y=atan(1)/45 * y * -1; run; proc gproject data=anno out=annop; id segment; run; proc gmap map=maps.us data=maps.us anno=annop; id statecode; choro statecode / nolegend; where statecode not in ("AK", "HI", "PR"); run; quit; I think the problem has something to do with the radians/degrees conversion, but I'm not sure if I need to have my map set and annotate set in the same table. Any help is appreciated. Thank you!

P5C768 · ‎01-18-2013

The variable is in the data set, but I want it to format based on variable that may or may not be in that variable. For example, I want a green shade for any values under 40%, so if there are not any values under 40%, I don't want green to show up.

P5C768 · ‎01-18-2013

I'm trying to create a basic heat map by regions using proc GMAP. I would like to create five fixed choro ranges that don't change, even if values aren't available for that particular month (i.e. in the code below, there are no values under 40% or above 70%). I created a ranking variable in my data set ("Change") to be modified by the proc format and in the choro statement. However, the choro continues to work on the range of available values, ignoring the format. Any help is appreciated. Thanks! proc format; value Change_Groups 1="Under 40%" 2="40%-49%" 3="50%-59%" 4="60%-69%" 5="70% and Up"; run; pattern1 v=ms c=Green; pattern2 v=ms c=Lig; pattern3 v=ms c=Yellow; pattern4 v=ms c=Red; pattern5 v=ms c=Maroon; proc gmap map=Data_Proj data=Data_Proj; format Change Change_Groups.; id maparea; choro Change / levels=6 legend=legend1 coutline=black html=Data_html; run; quit;

P5C768 · ‎01-02-2013

Thanks Cynthia, I believe the DESCRIPTION= is what I was looking for. I have noticed though that is I run the ODS PDF without exiting out of SAS, it appears the DOCUMENT object continues to add maps and directories. For example, the first time I run the code, it works perfectly, but the next time instead of having 2 maps for the 2 GMAP statements I am using, I have 4. Then 6, then 8 and so on. Is there a way to clear the prior results at run time? I have tried using ods PDF newfile=proc; with no results. Thanks again for all your help!

P5C768 · ‎12-28-2012

Thanks, Cynthia, that worked perfectly. One further question, when I use a similar process to combine numerous proc reports into one PDF, I use the "contents=" statement to set the text that will be displayed in the PDF. Is there a way to do that in the GMAP or Document procedure, so that the output doesn't say "Choropleth Map of..." and "The GMAP Procedure?" Thanks again.

P5C768 · ‎12-26-2012

I'm using the following code to PDF a GMAP procedure and I'm having multiple problems. First, my title doesn't show up in the PDF, only in the HTML. Second, I would like to repeat this procedure to include multiple maps in one document (I'm thinking of proc document using the move>to statement, but I'm not sure how to reference the individual maps). Any help is greatly appreciated. Thanks. goptions reset=all cback=white htitle=14pt htext=10pt hsize=4in vsize=4in; options GSTYLE; pattern1 v=ms c=VLIGB; pattern2 v=ms c=LIGB; pattern3 v=ms c=STGB; pattern4 v=ms c=BIGB; pattern5 v=ms c=VIGB; legend1 across=6 shape=bar(3,4)pct position= (middle bottom outside) label=("Percent" Position=(center top)); title 'My Title'; proc gmap map=Proj data=Proj; id maparea; choro Change_Group / levels=6 legend=legend1; run; quit; ods pdf file="Map.pdf" style=analysis pdftoc=2; ods pdf close; quit;

P5C768 · ‎12-21-2012

, yes I tried that as well , with no luck. , I am using EG.

P5C768 · ‎12-21-2012

When I remove the device = actximg and replace it with goptions reset=all; I get "ERROR: Device was not specified." How can I direct the html output to have the assigned style?

P5C768 · ‎12-21-2012

I'm using the code from the link attached above: proc template; define style styles.colorramp; parent=styles.default; /* Define a lighter and darker shade of blue for the starting and ending colors. */ style twocolorramp / startcolor=cxF3F7FE endcolor=cx6497EB; /* When there are fewer than 3 response levels, GraphData1 and GraphData2 are used for the colors */ style graphdata1 from graphdata1 / color=cxF3F7FE; style graphdata2 from graphdata2 / color=cx6497EB; end; run; /* Reference the style using the STYLE= option on the ODS destination statement */ goptions device=actximg; ods listing style=styles.colorramp; title 'Map with colors defined from a color ramp'; proc gmap data=maps.us map=maps.us; id state; choro state; run; quit;

P5C768 · ‎12-21-2012

In case anyone else ever needs to use X/Y data from a Map Info File, you can use the maparea variable as an ID variable to map and at least in my case, it creates a much cleaner map than using other ID variables. Thanks.

P5C768 · ‎12-21-2012

I've been trying to add a color ramp to a map using the suggested coding from: 41776 - Create a map with colors defined from a color ramp However, I can't get anything other then the basic green choro (so the proc template I use it not being applied). I tried adding a goptions device=actximg; statement to remove a warning, but I still can only get the basic green. I'm on 9.2. Any ideas? I've just been using a predefined set of 5 colors instead, but a color ramp would work much better since I may not always have 5 levels. Thanks.

P5C768 · ‎12-13-2012

Follow up: I was able to get a Map Info File which contains a drastically reduced data set that covers the same regions. Is there a way to map using X Center, Y Center and a Polygon shape area using GMAP?

P5C768 · ‎11-29-2012

That does explain a lot more of what happened. Before using PROC GREMOVE, I was trying to reduce the records by sorting X and Y and taking every 10th record. Now that I have reverted to the original shapefile source, it is looking better, but I an still getting a lot of lines running back and forth over the map. I believe this is because some of my regions, while in the same region, are not continuous (for example, having WA, OR and NM in a "West" region, but not CA). I am thinking I may be able to get around this be defining labels for only continuous regions and then just using the annotate step to label them, but is there a better way to do this? So that SAS doesn't draw lines back and forth over the regions.

P5C768 · ‎11-28-2012

It's getting closer, but at density = 2, I am still getting a lot of lines running across the region. Is that because there are still too many data points?

P5C768 · ‎11-28-2012

I am trying to map some custom regions all of which are in the US. Unfortunately, the only geographic locations I have are zip codes. I imported my zip code list into ArcGIS and ran a dissolve to get the appropriate regions, then exported to a shape file and imported to SAS using PROC MAPIMPORT. I am facing two problems though: 1) The data is "too detailed" i.e. I am getting approx. 7 mm records to map 5 regions across the US. Since the SAS loaded US map only has 1,500, I figure this is too many. I have tried reducing some of the records by taking every 10th record (just as a starting point) and limiting to only one region but the map I am getting isn't right (see attached). 2) My second problem is how to make my regions appear on a US map when I don't have a State Code, just a zip. Do I need to use the zipstate function to be able to link to the maps.us? Currently I am just using a basic GMAP procedure. I have been using this article as a starting point, and it has been extremely helpful, I am wondering if I just have way more records then the sample and that is why I am having trouble: http://support.sas.com/resources/papers/proceedings09/232-2009.pdf. Any help is appreciated. Thanks.

Online Status	Offline
Date Last Visited	‎09-14-2020 08:35 PM

ODS HTML5 Tool-Tips Working in SAS EG Results Viewer Only

Re: Running Count by Multiple Variables Where One Variable is NotSorte...

Running Count by Multiple Variables Where One Variable is NotSorted

Format Billions as '$0.0 B'

Multiple By Statements with First./Last.

Macro Loop to Append Columns to a Base Table from a every table in a L...

Embed SGPLOT and Proc Report in Email

Re: List All Distinct Values of a Font

List All Distinct Values of a Font

Re: Collapse Transactional Data by Customer and Preserve Order of Tran...

Re: Collapse Transactional Data by Customer and Preserve Order of Tran...

Re: Posting SAS GMAP HTML to Jive Website

Help with GEOCODE/GPROJECT/Annotate

Re: Create Static Choro GMAP

Create Static Choro GMAP

Re: PDF Multiple GMAPs into one Document

Re: PDF Multiple GMAPs into one Document

PDF Multiple GMAPs into one Document

Re: Color Ramp for GMAP

Re: Color Ramp for GMAP

Re: Color Ramp for GMAP

Re: Adding ESRI Shapefiles to US Map

Color Ramp for GMAP

Re: Adding ESRI Shapefiles to US Map

Re: Adding ESRI Shapefiles to US Map

Re: Adding ESRI Shapefiles to US Map

Adding ESRI Shapefiles to US Map