Please see the code /* ------------------------------------------------------------------- Code generated by SAS Task Generated on: Thursday, May 4, 2017 at 1:08:28 PM By task: Map Chart Map Data: SASApp:MAPSGFK.US_COUNTIES Response Data: SASApp:WORK.ADDCOUNTYID Server: SASApp ------------------------------------------------------------------- */ %_eg_conditional_dropds(WORK.MAPCHARTMAPPREP); PROC SQL; CREATE VIEW WORK.MAPCHARTMAPPREP AS SELECT * FROM MAPSGFK.US_COUNTIES WHERE STATECODE = 'NC' ; QUIT; %_eg_conditional_dropds(WORK.MAPCHARTRESPONSEPREP); PROC SQL; CREATE VIEW WORK.MAPCHARTRESPONSEPREP AS SELECT * FROM WORK.deviations_by_county ; QUIT; GOPTIONS CBACK= ; PATTERN1 VALUE=SOLID COLOR=CX99CC00; PATTERN2 VALUE=SOLID COLOR=WHITE; PATTERN3 VALUE=SOLID COLOR=YELLOW; PATTERN4 VALUE=SOLID COLOR=CXFF6600; PATTERN5 VALUE=SOLID COLOR=RED; LEGEND1 DOWN=5 FRAME LABEL=( FONT='Times New Roman' HEIGHT=14pt JUSTIFY=LEFT "Light green counties have unusually LOW per enrollee spending. " FONT='Times New Roman' HEIGHT=14pt JUSTIFY=LEFT "White counties have spending per enrollee that is within plus or minus one standard deviation from the mean. " FONT='Times New Roman' HEIGHT=14pt JUSTIFY=LEFT "Yellow, orange, and red counties have unusually HIGH per enrollee spending.") ; TITLE;FOOTNOTE; TITLE1 "NEMT Per Medicaid Enrollee Spend by County"; TITLE2 "Standard Deviations Above or Below Average"; FOOTNOTE1 ""; ods html5 body="test.htm" (title="NEMT spending by county") style=htmlblue /* this successfully creates a test.htm file in the EXMAP library, but the file is blank, and this isn't the destination I actually want anyway*/ path="/sas/RA/nc_dhhs/OIA/ContinuousAudit/ContinuousAuditShared/CommonResources/ExampleMapProject" /*I'm trying to export to desktop using either of the paths below but it's not working yet. */ /*path="/sas/sas94/sas94config/Lev5/SASApp"*/ /*path="//trvwcfs02/NC_SAS_PROD/bwhite6/Desktop/_sas_sas94_sas94config_Lev5_SASApp_test_htm.html"*/ (url=none); ods html5 close; /* while the HTML files don't work, this code does successfully generate a map in a SAS Report format. I then tried opening the SAS report and using SAS EG "Export" or "Send To" to generate an HTML file I can share with others. I'm able to create an HTML file but it doesn't display the map. */ PROC GMAP GOUT=MAPCHART DATA=WORK.MAPCHARTRESPONSEPREP MAP=WORK.MAPCHARTMAPPREP ALL; ID STATE COUNTY; choro Deviations / WOUTLINE=1 CDEFAULT=BLACK DISCRETE LEGEND=LEGEND1 html=tooltip ; RUN; QUIT; TITLE;FOOTNOTE; GOPTIONS RESET=LEGEND; GOPTIONS RESET=PATTERN; GOPTIONS CBACK=; %_eg_conditional_dropds(WORK.MAPCHARTRESPONSEPREP); %_eg_conditional_dropds(WORK.MAPCHARTMAPPREP); /* ------------------------------------------------------------------- End of task code where do you think i should change the code.
... View more
