About P5C768

P5C768 · ‎10-11-2012

I have a report where I set the colors of the header by certain groupings. I just added total to the report using RBREAK AFTER /SUMMARIZE and I would like to color the summary row to match the corresponding header. I know I need to use the compute statement, but I can't figure out how to set the color by the column the data is in rather than by the value of the data. Any ideas? Thanks! define tot/ analysis format=comma12. 'Total' style(header) = [background = midnightblue foreground = white] ; define Change/ analysis format=comma12. 'Total Changed' style(header) = [background = midnightblue foreground = white] ; define Per_Change/ computed format=percent8.2 '% of Changed' style(header) = [background = midnightblue foreground = white] ; define Impact/ analysis format=comma12. 'Count of Changed' style(header) = [background = MediumBlue foreground = white]; define NoImpact/ analysis format=comma12. 'Count of Changed' style(header) = [background = RoyalBlue foreground = white] ; define Per_Impact/ computed format=percent8.2 '% of Changed' style(header) = [background = MediumBlue foreground = white]; define Per_NoImpact/ computed format=percent8.2 '% of Changed' style(header) = [background = RoyalBlue foreground = white]];

P5C768 · ‎07-09-2012

But can you use the %annomac to annotate multiple items per county?

P5C768 · ‎07-09-2012

I have a follow up question: is the same thing possible using US county, even though there is no US county center map? I would like to limit my results by state and county, and then display several pieces of information by county, one of which being COUNTYNM from the maps.cntyname table. Thanks.

P5C768 · ‎06-15-2012

Interesting. Out of curiosity, why can't you use the SASHELP.ZIPCODE as a map data set? Is it because the use center of zip rather than a shape file like U.S. States? I'm looking into creating our own shape files for the different regions we want to map.

P5C768 · ‎06-14-2012

I changed the first part to: proc format; value cou2hsa 99501, 99502, 99503, 99504, 99505, 99506, 99507, 99508, 99509, 99510, 99511, 99513, 99514, 99515, 99516, 99517, 99518, 99519, 99520, 99521, 99522, 99523, 99524, 99529, 99530, 99540, 99556, 99557, 99566, 99567, 99568, 99572, 99573, 99574, 99575, 99577, 99586, 99587, 99588, 99599, 99603, 99605, 99610, 99611, 99615, 99619, 99627, 99629, 99631, 99635, 99639, 99640, 99645, 99647, 99652, 99653, 99654, 99656, 99663, 99664, 99667, 99668, 99669, 99672, 99674, 99675, 99676, 99677, 99682, 99683, 99686, 99687, 99688, 99689, 99691, 99693, 99694, 99695, 99697, 99701, 99702, 99703, 99704, 99705, 99706, 99707, 99708, 99709, 99710, 99711, 99712, 99714, 99716, 99720, 99724, 99725, 99729, 99730, 99731, 99732, 99733, 99737, 99738, 99740, 99743, 99744, 99755, 99756, 99757, 99758, 99760, 99764, 99767, 99768, 99774, 99775, 99776, 99777, 99779, 99780, 99781, 99790, 99801, 99802, 99803, 99811, 99820, 99821, 99824, 99825, 99826, 99827, 99829, 99830, 99832, 99833, 99835, 99836, 99840, 99841, 99850, 99901, 99903, 99918, 99919, 99921, 99922, 99923, 99925, 99926, 99927, 99928, 99929, 99950 = 'Region1' other = 'Other Regions'; Run; data hsatemp; set sashelp.zipcode; hsa = put(ZIP,cou2hsa.); run; That seems to work up until gproject, where I get this error: ERROR: At least one value is out of range for polar radian coordinates. Data may already be projected. ERROR: Expected range is (-3.141592654, 3.1415926536) for X and (-1.570796327, 1.5707963268) for Y. ERROR: Actual range is (-176.658889, 171.062651) for X and (5.310246, 70.66976) for Y. I think the problem comes from the fact that all these examples use shapefiles whereas the sashelp.zipcode uses center of zip

P5C768 · ‎06-14-2012

I have a mapping of zip codes to regions, but I have 9 regions and 40k zip codes, so my choro variable will be repeated 40k times. My thought was to use the zip codes to create my regions on the map, then add the data by region, but I guess that won't work. My other idea was to try and concatenate all the zip codes into a string so that the format option would work. However, one of my regions has nearly 10k zip codes, so at 5 digits a piece, it exceeds the maximum string length. I guess this just won't work. It sound like I need to work on getting data by zip code, rather than region. Then maybe I can use the format option to create my regions and sum my data by region.

P5C768 · ‎06-13-2012

I see how this would work, but if I'm correct you would need data by zip code for this to work, correct? I have data by my region label and I am trying to use a separate data set that links zip codes to my regions.

P5C768 · ‎06-13-2012

Correct, but my regions don't contain continuous zip codes. I can't do this: proc format; value $zipfmt '07002'-'61378' = 'Region 1' '00544'-'88595' = 'Region 2' run; because the regions would overlap. That is why I was thinking of an array.

P5C768 · ‎06-13-2012

The methods that alpay and Robert listed work, I guess I'm just struggling with how to convert the 40k plus zip codes into an array. Alpay's example assumes region include sequential zip codes, which mine do not. Here is an output of a proc means to show the range: Analysis Variable : ZIP The 5-digit ZIP Code Region N Minimum Maximum Region1 5802 7002 61378 Region2 9786 544 88595 Region3 154 99501 99950 Region4 5191 19930 74966 Region5 7386 1005 78962 Region6 4709 59001 99403 Region7 1649 24314 49289 Region8 1159 501 93599 Region9 5498 39426 96158 Robert's example assumes that you only want to change a handful amount of zip or counties, rather then setting the region by a range of zip codes. I ran a proc transpose to convert my data to be in columns with each row representing a region. I'm thinking maybe I can create an array of each row, though some regions have nearly 10k records and I'm not sure what the limit would be. That way I could use Robert's method to set my regions by the zipcodes in my data.

P5C768 · ‎06-11-2012

Some of my regions are not defined by states unfortunately. California is split between two regions for example. That is why I thought of defining my regions by zip code.

P5C768 · ‎06-11-2012

What I am trying to do is similar to what is done in this example: http://support.sas.com/kb/24/902.html But instead of writing out all 40,000 zipcodes, could I just group them somehow so the regions are assigned by a region field that is related to a zip code.

P5C768 · ‎06-11-2012

Sorry, I should have been more clear. Once you have the data summarized by region, how can I link the zip codes with a map file, say sashelp.zipcode and only display regions rather than zip codes. Basically I want to define my map parameter by zip code, but display region rather than zip code, using proc gmap.

P5C768 · ‎06-06-2012

I have a data set that is listed out by zip code as the mapping coordinate but I would like to group those zip codes into a small number of regions (say 5 or 10). Is there a way to do this using the zipcodes or do I need to develop a shape file to define the regions? For example, my data is similar to this: Zip Region Count 90001 South 50 90002 South 75 90003 South 60 90004 West 75 90005 East 100 Can I use the zip codes to define the Regions and then sum the counts to display on the map? Or do I need to create something similar to the coordinates in the maps.us table to define regions? Thank you in advance for any help provided.

P5C768 · ‎05-31-2012

Actually, I figured it out. In addition to merging the maps.us and maps.uscenter so that I had the center values by StateCode, I had to change the data Mods_by_State statement into two data steps, one with the annotate example you provided and one with my data set. Thanks again to both of you. Robert, one further question. i noticed on your website you have some examples where you have states that have data offset and connected by a leader line (i.e. the east coast data values are off to the right of the graph to avoid overlap). How is that done? I have been searching around for that code and have been unable to find it as of yet. Thanks.

P5C768 · ‎05-30-2012

I was not including X & Y variables at first, but even though I am now including them, I still get the same result. The code I am using is below. data counts; set hspdata.counts_2011(where=(resolvedte ge '01Oct2011'd)) hspdata.counts_2012; length StateCode $2.; StateCode = substr(SRV_REGN,1,2); run; %let Beg_MTD = '01Apr12'd; %let End_MTD = '30Apr12'd; proc summary data = WO_Counts(where=(evt_stat_cd in ("Closed") and &beg_mtd. le Resolvedte le &end_mtd.)) missing nway; class StateCode; var Change; output out = Temp_by_State(rename=(_freq_=TotCnt) drop = _type_) sum=; run; proc sql; create table tempUSmap as select t1.statecode, t2.* from maps.us as t1 left join maps.uscenter as t2 on t1.state = t2.state; quit; proc sort data= tempUSmap nodupkey; by StateCode; Run; proc sql; create table tempUSmap_withmods as select t1.*, t2.* from tempUSmap as t1 left join Temp_by_State as t2 on t1.statecode = t2.statecode; quit; data Mods_by_State; Set tempUSmap_withmods; length Group $8.; APercent=round(Change/TotWOCnt,0.0001); format APercent percent9.2; if APercent <0.4 then Group = "<40%"; if APercent >=0.4 and APercent <0.5 then Group = "40%-49%"; if APercent >=0.5 and APercent <0.6 then Group = "50%-59%"; if APercent >=0.6 and APercent <0.7 then Group = "60%-69%"; if APercent >=0.7 then Group = ">70%"; xsys='2'; ysys='2'; hsys='3'; size=3; when='a'; function='label'; length text $20; position='2'; text=put(APercent, percent9.1); output; run; goptions reset=all border; pattern1 v=ms c=cxeff3ff; pattern2 v=ms c=cxbdd7e7; pattern3 v=ms c=cx6baed6; pattern4 v=ms c=cx2171b5; legend1 origin=(75,60)pct across=1 mode=share label=(position=top j=c 'Modification Rate') shape=bar(3,4)pct cborder=blue ; title1 "Modifications by State"; footnote1 j=r &sysdate; legend1 label=("Modifiation Percent"); pattern1 v=msolid color=vligb; proc gmap map=maps.us data=Mods_by_State; id StateCode; choro Group / levels=6 annotate=anno_stuff; run; quit;

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

Set Summary Line Color by Header in Proc Report

Re: Basic Choro/Annotate Question

Re: Basic Choro/Annotate Question

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Re: Transform Data by Zip Code into US Regions

Transform Data by Zip Code into US Regions

Re: Basic Choro/Annotate Question

Re: Basic Choro/Annotate Question