data have; length yymm $4; input YYMM Y :percent8.2; format y percent8.2; datalines; 2201 0.18% 2202 0.19% 2203 0.22% 2204 0.04% 2205 0.23% 2206 0.27% 2207 0.26% 2208 0.04% 2209 0.06% 2210 0.09% 2211 0.03% 2212 0.04% 2301 0.03% 2302 5.3% ; data want; set have; length date_string $8; date_string='20'||trim(left(yymm))||'15'; format sasdate yymmn4.; sasdate = input(date_string,yymmdd8.); proc print data=want; format sasdate date9.; axis1 label=none minor=none offset=(0,0) order=(0 to .1 by .01); axis2 label=('YYMM') offset=(2pct,2pct) order=('15jan2022'd to '15feb2023'd by month); symbol1 value=circle height=2pct color=blue; title1 h=5pct "Values, by Month"; proc gplot data=want; format y percentn7.0; plot y*sasdate/ autovref lvref=33 cvref=gray33 vaxis=axis1 haxis=axis2 ; ... View more

data have; input ID Greetings; datalines; 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 10 1 11 1 12 2 13 2 14 2 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 . 23 . 24 . 25 2 ; Proc format; Value Gre 1 = 'Hello' 2 = 'Hi' 3 = 'Dear' ; axis1 label=none minor=none order=(0 to 60 by 20) offset=(0,0); axis2 label=('Type of Greeting') offset=(9,9); pattern1 color=cyan; title1 h=6pct font='albany amt/bold' "Customized 3d Chart"; proc Gchart Data=have; Format Greetings Gre. ; vbar3d Greetings / discrete space=7pct width=5pct raxis=axis1 autoref cref=gray33 lref=33 maxis=axis2 type=percent outside=percent statfmt=comma5.0 ; ... View more

@Quentin wrote: @gdb02 wrote: Great idea, but I was going for code readability over color consistency for the project I was working on. And if I really want to confuse myself, I can remap &green to resolve to a different color without changing my reporting code.  : ) Which seems to be what SAS has done, I assume by accident, replacing the color code for GREEN BLUE with the color code for RED. Someone should raise this as a bug report to SAS technical support team. data test; input colorname $20.; cards; RED BLUE GREEN YELLOW BLUE GREEN GREEN BLUE ; proc report data=test; title1 'What is going on with BLUE GREEN named color combinations?'; column colorname colorname=clr; define colorname/ 'Color Name'; define clr / 'Color'; compute clr /char length=200; call define(_col_,'style','style={background='||colorname||'}'); endcomp; run;   ... View more

Is there a way to get the lines to start at zero? ... View more

Or, you can use the VECTOR statement in SGPLOT procedure.   https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatproc/p1wtsx90517bf4n12fpaaeh6za0l.htm ... View more

As Jeff says, Alaska & Hawaii have been moved/projected/scaled differently from the rest of the US, in this particular map (mapsgfk.us). Therefore, there is no one/simple command that will move/project/scale arbitrary lat/long coordinates and have them line up with the map.   But ... mapsgfk.uscity has applied the same move/project/scale to all the mapsgfk.uscity locations, so they line up with mapsgfk.us ... and therefore if you find the closest city to each of your lat/long locations, you could look up the x/y from mapsgfk.uscity, and plot those locations on the map. Here's a small example showing all the mapsgfk.uscity locations overlaid on mapsgfk.us:   title "mapsgfk.us with mapsgfk.uscity locations overlaid"; proc sgmap mapdata=mapsgfk.us noautolegend plotdata=mapsgfk.uscity; choromap / mapid=statecode; scatter x=x y=y / markerattrs=(size=1px color=red symbol=circlefilled) transparency=0; run;     ... View more

You're correct. From my survey data, I only create one weight value for each observation when any respondent gives his/her answers for Day 1 and Day 30 and Day 60.   Thanks, ... View more

Why would you want any ticks on that axis at all? What purpose do they serve? ... View more

@tc  never disappoints! ... View more

Here's how to do it without combining/projecting/separating the map & data, by using the somewhat new feature of saving the projection parameters for the map and then applying them to the annotate dataset:   data zips; input c zip; cards; 1 65203 2 65211 3 65201 ; proc geocode data=zips out=geocodedzips (rename=(x=long y=lat)); run; data mocounties; set mapsgfk.us_counties (where=(statecode='MO')); run; proc gproject data=mocounties out=mocounties latlong eastlong degrees parmout=projparm; id county; run; proc gproject data=geocodedzips out=geocodedzips latlong eastlong degrees parmin=projparm parmentry=mocounties; id; run; data anno_locations; set geocodedzips; if c=1 then color="red"; if c=2 then color="bib"; if c=3 then color="viyg"; if c=4 then color="bippk"; xsys='2'; ysys='2'; hsys='3'; when='a'; function='pie'; rotate=360; size=.5; style='psolid'; output; length html $300; html='title='||quote(trim(left(c))||'0d'x||trim(left(put(zip,z5.)))); style='pempty'; color='deb'; output; run; pattern1 v=e; proc gmap map=mocounties data=mocounties anno=anno_locations; id county; choro segment / coutline=black levels=1 nolegend coutline=gray99; ... View more

Can you show an example of what you want for a 2-d version of your graph?   I would think most understandable might be just a box with the number of school mean programs. Something like this example: https://support.sas.com/kb/24/900.html only use the number to display instead of the state abbreviation. Use CBOX with CBACK=white to have the numbers appear on a white background for readability and to draw attention. Probably  still need to play with locations for some of the New England states like Connecticut and Rhode Island as may not be room   If you want to overlay a 2-dimensional rectangle then you could create an annotate data set drawing rectangles that look like a 2-d bar at each state.   Or maybe use a fill pattern to represent the bar information ... View more

Could you provide the code you used to produce your gchart pie chart? ... View more

If you go to lexjansen.com index of user group papers, there are lots of papers about mapping by zipcode: https://www.lexjansen.com/search/searchresults.php?q=map+zipcode   This isn't something I do, so can't recommend a specific approach. ... View more

The maps in the blog post show numeric (lat/long) axes - I've never seen Proc SGMAP do that. Are you 100% certain they were created with SGMAP?   ... View more

Thanks again. Really apreciate the help! ... View more