Thanks for your helps again!   ... View more

Thanks for your ODS solution.   If exporting it to Excel, i have a control to give a tab name(see below). How to give a customized tab name in ODS Excel?   PROC EXPORT DATA= tmp_view OUTFILE= "&outputname." DBMS=xlsx REPLACE; SHEET="&tabname."; ... View more

I'll definitely give a try.  Do you have any example to share?  Thanks so much for your prompt helps.   ... View more

My variable labels are sort of dictionary of variable names even filling with a underscore between the words. ... View more

Reeza, thanks very much for pointing out.  it works well after putting  "if bird_age >=4 then do i=1 to 3; " I don't know how to apply "4.33 weeks per month" into the existing code.    ... View more

Maybe Chris Hemedinger can help address the issue. ... View more

I stored the array of maps on company’s shared drive to let other people to view them. It works perfectly with drill-down feather. I tried to replicate them on our SharePoint with our IT support. It only works for me, but others can open each map individually and drill-down feature doesn't work after granting access permission to them. How to fix it? Thanks, ... View more

Thanks very much for your guidance and suggestions once again.   This has allowed me to experience the power of Proc SGMAP, particularly go through the hump to deal with the large size of geo-data. ... View more

@GraphGuy Thanks very much for your helps again! But in this case running "proc greduce" takes about 4 minutes to finish it. Other than that I'm gleeful for the results based on your suggestions. My SAS version is Base 9.4 (TS1M7), I need to replicate the process to create map for over 40 times.  is there any catch to reduce the running time for "proc greduce"?     ... View more

Thanks @ballardw.   Below is my simple version SAS code & log as well as the attached input data sets. One of input file is saved as CSV other than SAS due to the size of file exceeding the limit to attach.   The running time for Proc SGmap alone is nearly 20 second without any errors.   Could you enlighten me on why the tooltips disappear for some of IDs on the map.   Thanks so much for your help.     %let drive=c:\temp; libname temp  "&drive."; data text1;set temp.text1; run;   data reported_data1;set temp.reported_data1;   run;   proc import out=MTstate   datafile="&drive.\MTstate.csv"   dbms= dlm replace;   delimiter = ','; run;   data MTstate(rename=(IDNew=ID));set MTstate; length IDNew $4; IDNew=put(ID,z4.); drop ID; run;   %let EQ=index; %let colorlist=cx4dac26 cxb8e186 cyan  cxf1b6da cxd01c8b; %let name=MTMAP; filename odsout "&drive.";   ods path(prepend) work.templat(update); proc template;   define style mystyle;     parent=styles.htmlblue;     class GraphValueText /                                                      font = (Arial,7.5pt,Bold)                                       color = black;   end; run;   ods _all_ close; ods html5 path=odsout file="&name..html" options(bitmap_mode="inline") style=mystyle nogtitle;         ods graphics on / reset=all outputfmt=PNG imagemap tipmax=35000   ANTIALIAS=on ANTIALIASMAX=10000 SUBPIXEL=on width=900px height=700px noborder;   proc sgmap mapdata=MTstate maprespdata=reported_data1  plotdata=text1; openstreetmap; styleattrs datacolors=(&colorlist.); choromap &EQ. /   mapid=id id=id   lineattrs=(thickness=0.2 color=grayaa) transparency=.01 tip=(ID  pop pop_perc  index rank) TIPLABEL=('ID'   'Population' '% of Population'  'Index' 'Index Ranking')  colormodel=(&colorlist.) name="&name."; gradlegend "&name." / title="Index" TITLEATTRS=(Color=darkblue Family=Arial Size=9.5         Style=normal Weight=Bold) ;  series x=outlinex y=outliney / group=grp lineattrs=(color=black thickness=0.03px); run; quit; ods html5 close; ods preferences;     ... View more

Rob, My issue is resolved.  I'm very appreciative of both of your suggestion here!     ... View more