cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
fastb
‎09-28-2023
  • 44 Posts
  • 1 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: Unicode character will not display in sgplot output

by Fluorite | Level 6 in SAS Programming
‎09-27-2023 10:29 PM
‎09-27-2023 10:29 PM
Hi ballardw, The characters need to appear as marker symbols in the body of the graph. Below is the code where I used symbolchar to create the each symbol with the unicode character. This works fine for the symbols with numbers 1 through 20.  However, starting with 21 it is a different charcater code set and everything 21 and above does not work.   Thanks!   PROC SGPLOT DATA = map_coordinates noborder nowall NOAUTOLEGEND NOCYCLEATTRS sganno = annoImage; TITLE; YAXIS grid gridattrs = (color = black) display = (noline nolabel noticks novalues) values=(0 to 100 by 5); XAXIS grid gridattrs = (color = black) display =(noline nolabel noticks novalues) values=(0 to 100 by 5); symbolchar name=one char='2460'x / textattrs = (weight = bold); symbolchar name=two char='2461'x / textattrs = (weight = bold); symbolchar name=three char='2462'x / textattrs = (weight = bold); symbolchar name=four char='2463'x / textattrs = (weight = bold); symbolchar name=five char='2464'x / textattrs = (weight = bold); symbolchar name=six char='2465'x / textattrs = (weight = bold); symbolchar name=seven char='2466'x / textattrs = (weight = bold); symbolchar name=eight char='2467'x / textattrs = (weight = bold); symbolchar name=nine char='2468'x / textattrs = (weight = bold); symbolchar name=ten char='2469'x / textattrs = (weight = bold); symbolchar name=eleven char='246A'x / textattrs = (weight = bold); symbolchar name=twelve char='246B'x / textattrs = (weight = bold); symbolchar name=thirteen char='246C'x / textattrs = (weight = bold); symbolchar name=fourteen char='246D'x / textattrs = (weight = bold); symbolchar name=fifteen char='246E'x / textattrs = (weight = bold); symbolchar name=sixteen char='246F'x / textattrs = (weight = bold); symbolchar name=seventeen char='2470'x / textattrs = (weight = bold); symbolchar name=eighteen char='2471'x / textattrs = (weight = bold); symbolchar name=nineteen char='2472'x / textattrs = (weight = bold); symbolchar name=twenty char='2473'x / textattrs = (weight = bold); symbolchar name=twentyone char='3251'x / textattrs = (weight = bold); symbolchar name=twentytwo char='3252'x / textattrs = (weight = bold); symbolchar name=twentytheree char='3253'x / textattrs = (weight = bold); symbolchar name=twentyfour char='3254'x / textattrs = (weight = bold); symbolchar name=twentyfive char='3255'x / textattrs = (weight = bold); symbolchar name=twentysix char='3256'x / textattrs = (weight = bold); styleattrs datasymbols = ( one two three four five six seven eight nine ten eleven twelve thirteen fourteen fifteen sixteen seventeen eighteen nineteen twenty twentyone twentytwo twentythree twentyfour twentyfive twentysix ); SCATTER x = X_Coordinate y = Y_Coordinate/ markerattrs = (size = 16) group = site_number nomissinggroup name = 'sites'; yaxis min=0 max=100 /*grid values=(0 to 100 by 5)*/ offsetmin=0 offsetmax=0 display= none; xaxis min=0 max=100 /*grid values=(0 to 100 by 5)*/ offsetmin=0 offsetmax=0 display=none; run; quit; ods listing close; ... View more

Unicode character will not display in sgplot output

by Fluorite | Level 6 in SAS Programming
‎09-27-2023 03:16 PM
‎09-27-2023 03:16 PM
Hi, I need to have unicode character 3251 (circled number 21) appear as a symbol on a graph in sgplot. However, an open square appears on the graph instead of the circled 21 when I create the graph. It appears that this is happening because the font I am using does not support that unicode character. I tried sevral different fonts and nothing worked. Is there a specific font that I need to use for this, or are ther any other solutions? Thanks! ... View more

Background Image for Plots Generated with SGPLOT Macro

by Fluorite | Level 6 in Graphics Programming
‎05-11-2022 11:37 AM
‎05-11-2022 11:37 AM
Hi,   I am generating a series of plots using an SGPLOT macro and I have an image that I want to use for the background of all of the plots.   When I was making the plots one at a time without the macro the annotate function worked fine to add the image to the plot background. However, that does not work with the macro.  I suspect that I need to add an SG macro to the code to accomplish this. Can anyone provide me with the code that would accomplish that?   Thanks! %MACRO SGPLOT; %DO i=1 %TO &total; ods listing style = map_symbols gpath = '\\C:Macro Plots\Output Files' IMAGE_DPI=1200; ODS GRAPHICS ON / imagename = 'NA Test Map' IMAGEFMT=png IMAGEMAP=on BORDER=off; OPTIONS NOBYLINE; data annoimage; length function $10.; function = 'image'; height = 90; width = 100; drawspace = 'wallpercent'; image = '\\C:Analysis Files\Plot Background.jpg'; layer = 'back'; run; PROC SGPLOT DATA=macrovar NOAUTOLEGEND NOCYCLEATTRS sganno =annoImage; WHERE Site_Code="&&Site_Code&i"; TITLE; YAXIS grid gridattrs = (color = black) display = (noline nolabel noticks novalues) values=(0 to 100 by 5); XAXIS grid gridattrs = (color = black) display =(noline nolabel noticks novalues) values=(0 to 100 by 5); SCATTER x = US_X y = US_Y/ ODS GRAPHICS OFF; ODS _ALL_ CLOSE; ODS LISTING CLOSE; %END; %MEND SGPLOT; %SGPLOT; ... View more

Re: Projecting Map of US and Canada from GFK Map Datasets

by Fluorite | Level 6 in Graphics Programming
‎04-11-2022 02:06 PM
‎04-11-2022 02:06 PM
Thanks for your help with this GraphGuy!   Made great progress using your code suggestions.  Now I am making the two country borders thicker and darker than the state/province borders.  For some reason the US/Canada border is a double line above Montana.  Can you identify what is causing that?   Thank you! DM 'LOG;CLEAR;OUT;CLEAR;'; OPTIONS Missing = '' LS=128 PAGESIZE=36 NONUMBER; goptions reset=all border cback=white htitle=12pt htext=10pt; data map_us; set mapsgfk.us_states (where=(statecode not in ('AK' 'HI') and density<=4)); my_id=statecode; country='US'; run; data map_canada; set mapsgfk.canada (where=(id1 not in ('CA-60' 'CA-61' 'CA-62') and density<=1)); run; proc gremove data=map_canada out=map_canada; by id1; id id; run; data map_canada; set map_canada; my_id=id1; country='CA'; run; data mapall; length my_id $8; set map_us map_canada; run; proc sql noprint; create table mapall_attr as select unique country, my_id, segment, 1 as fakedata from mapall; quit; run; proc gproject data=mapall out=mapall_proj latlong eastlong degrees project=gnomon; id country my_id; run; proc gremove data=mapall_proj out=anno_outline; by country notsorted; id my_id; run; data anno_outline; set anno_outline; by country segment notsorted; length function $8 color $8; color='gray33'; style='mempty'; when='a'; xsys='2'; ysys='2'; if first.segment then function='poly'; else function='polycont'; run; FILENAME plots "C\Output Files"; goptions reset=all DEVICE=gif xpixels=1200 ypixels=1000 transparency GSFNAME=plots; ods _all_ close; ods listing; pattern1 v=solid color=white; proc gmap map=mapall_proj data=mapall_attr anno=anno_outline all; id country my_id; choro fakedata / levels=1 nolegend coutline=graydd; run; quit; ... View more

Re: Projecting Map of US and Canada from GFK Map Datasets

by Fluorite | Level 6 in Graphics Programming
‎04-01-2022 03:59 PM
‎04-01-2022 03:59 PM
I was initially using the maps.states and maps.canada4 datasets. However, I switched to mapsgfk.us and mapsgfk.canada because the mapsgfk.canada4 dataset includes the LAKE variable so I can exclude the lakes from the Canada map. Is there any way to prevent the lakes from displaying using the maps.canada4 dataset?   ... View more

Projecting Map of US and Canada from GFK Map Datasets

by Fluorite | Level 6 in Graphics Programming
‎04-01-2022 02:07 PM
‎04-01-2022 02:07 PM
I am creating a map of the US and Canada (excluding lakes and some states and provinces). I have successfully created the maps of each country, but they are not projected to the right position (see example).   Can someone help me with the PROC GPROJECT statement that I need to use to get these in the right position?   I'm not very familiar with that PROC so I tried several options and they made it worse instead of better.   Thanks! DM 'LOG;CLEAR;OUT;CLEAR;'; OPTIONS Missing = '' LS=128 PAGESIZE=36 NONUMBER; goptions reset=all border cback=white htitle=12pt htext=10pt; proc gremove data=mapsgfk.canada out=canada_cleaned; by id1; id id; run; proc contents data=canada_cleaned; quit; data map_us; length country $8.;set mapsgfk.us/*states*/; if statecode = 'AK' or statecode = 'PR' or statecode = 'HI' then delete; country = 'US'; run; data map_can; length country $8.; set canada_cleaned; if ID1 = 'CA-60' or ID1 = 'CA-61' or ID1 = 'CA-62' then delete; if lake ne 0 then delete; country = 'CAN'; run; data map2(drop=statecode ID1); set map_can map_us; if country = 'CAN' then state_province_code = ID1; if country ne 'CAN' then state_province_code=statecode; run; FILENAME plots "C:\Map Files"; goptions reset=all DEVICE=gif xpixels=1200 ypixels=1000 transparency GSFNAME=plots; ods _all_ close; ods listing; pattern1 v=s color=white; proc format; value $state_province_code other = ' '; run; proc gmap data=map2 map=map2 all; id state_province_code; choro state_province_code / cdefault = white nolegend uniform; format state_province_code $state_province_code. ; run; quit; quit;   ... View more

Random Lines Across Map from PROC GMAP

by Fluorite | Level 6 in Graphics Programming
‎03-31-2022 01:17 PM
‎03-31-2022 01:17 PM
  Hi,   I am trying to make a map of Canada (excluding some provinces) and the US using proc gmap.   I can create the map and it looks good, but there are random lines running across the map.   What am I doing wrong that is causing this?   Thank you for your help!   DM 'LOG;CLEAR;OUT;CLEAR;'; OPTIONS Missing = '' LS=128 PAGESIZE=36 NONUMBER; goptions reset=all border cback=white htitle=12pt htext=10pt; data map_us; length country $8.;set maps.states; if state = 02 then delete; if state = 15 then delete; if state = 72 then delete; country = 'US'; data map_can; length country $8.; set maps.canada4; if province = '60' then delete; if province = '61' then delete; if province = '62' then delete; country = 'CAN'; data mapall(drop=state province); set map_can map_us; if country = 'CAN' then staten = province; if country ne 'CAN' then staten=fipstate(state); run; proc gproject data=mapall out=projmap project=gnomon polelong=100; id staten; run; quit; data projmap1; length fill 8.; set projmap; staten = 1; run; FILENAME plots "C:\Map Files"; goptions reset=all DEVICE=gif xpixels=1200 ypixels=1000 transparency GSFNAME=plots; ods _all_ close; ods listing; proc gmap data=mapall map=projmap1 all; id staten; choro staten / cdefault = white nolegend uniform; run; quit; map with random lines ... View more

SAS Enterprise 7.1 Creates new program file every time the code is run

by Fluorite | Level 6 in SAS Programming
‎03-30-2022 03:53 PM
‎03-30-2022 03:53 PM
I recently started using SAS Enterprise 7.1 (used to be using PC version). After I create a program file, every time I make a change to the file and run the code it generates a new version of the file.  For example, if my original file is named Graph Code, when I make a change to the file and run it again it creates a new file named Graph Code (2). How do I stop it from doing this?  I only want to have the original file and when I am finished making changes to that file I will save it.   Thanks ... View more

Size of Plots in ODS Gridded Layout

by Fluorite | Level 6 in Graphics Programming
‎09-23-2020 03:41 PM
‎09-23-2020 03:41 PM
Hi, I have written a macro to make a pdf with results for analytes tested in crops.  There is a one page summary for each analyte with a box and whisker plot, histogram, scatter plot, and summary statistics table. I have the columns set to 4 inches wide, but I cannot get the graphs to utilize all available width in the columns. How can I make the plots wider? Code and example output attached. Thanks! ods _all_ close; %MACRO SGPLOT; %DO i=1 %TO &total; ODS NORESULTS; ODS PDF STARTPAGE=NOW NOTOC /*STYLE=ceafigstyle*/; ODS GRAPHICS ON / ANTIALIASMAX=1400; ODS LISTING /*STYLE=ceafigstyle*/ GPATH = '<path inserted here>' IMAGE_DPI=600; OPTIONS topmargin=0.1in bottommargin=0.1in leftmargin=0.1in rightmargin=0.1in NODATE NONUMBER ORIENTATION=Portrait; ODS PDF FILE="<file inserted here>"; TITLE "&&CROP_TYPE&i& &&TISSUE_TYPE&i &&ANALYTE&i"; ods layout gridded columns = 2 rows = 1 row_heights = (3in) column_widths = (4.00in 4.00in); ODS REGION; PROC SGPLOT DATA=summary_pages_box NOAUTOLEGEND NOCYCLEATTRS; WHERE CROP_TYPE="&&CROP_TYPE&i" AND TISSUE_TYPE="&&TISSUE_TYPE&i" AND ANALYTE="&&ANALYTE&i"; TITLE "&&CROP_TYPE&i& &&TISSUE_TYPE&i &&ANALYTE&i"; HBOX VALUE; RUN; ODS REGION; PROC SGPLOT DATA=summary_pages_all NOAUTOLEGEND NOCYCLEATTRS; WHERE CROP_TYPE="&&CROP_TYPE&i" AND TISSUE_TYPE="&&TISSUE_TYPE&i" AND ANALYTE="&&ANALYTE&i"; TITLE "&&CROP_TYPE&i& &&TISSUE_TYPE&i &&ANALYTE&i"; HISTOGRAM VALUE/boundary=lower; DENSITY VALUE; RUN; ods layout end; ods layout gridded columns = 1 rows = 2 row_heights = (3in 3in); ODS REGION; PROC SGPLOT DATA=summary_scatter NOAUTOLEGEND NOCYCLEATTRS; WHERE CROP_TYPE="&&CROP_TYPE&i" AND TISSUE_TYPE="&&TISSUE_TYPE&i" AND ANALYTE="&&ANALYTE&i"; YAXIS label="&&UNIT_OF_MEASURE&i&" min =0 OFFSETMIN = 0.08 OFFSETMAX = 0.08; XAXIS DISPLAY=(nolabel) OFFSETMIN=0.05 OFFSETMAX=0.05; X2AXIS display = (nolabel noticks novalues) values=(0 to 100 by 100) OFFSETMIN=0 OFFSETMAX=0; TITLE "&&CROP_TYPE&i& &&TISSUE_TYPE&i &&ANALYTE&i"; SCATTER x=Pass_Fail y=VALUE / NOMISSINGGROUP MARKERATTRS=(SIZE=10px); RUN; ODS REGION; PROC REPORT NOWINDOWS LIST DATA=summary_stats_tables; WHERE CROP_TYPE="&&CROP_TYPE&i" AND TISSUE_TYPE="&&TISSUE_TYPE&i" AND ANALYTE="&&ANALYTE&i"; COLUMNS Statistic Value; DEFINE Statistic / display format = $20. width=20 center "Statistic"; define Value / display format = best8. width = 8 center "Value"; RUN; ods layout end; %END; %MEND SGPLOT; %SGPLOT; ODS PDF CLOSE;   ... View more

Re: Java Out of Memory Error

by Fluorite | Level 6 in Graphics Programming
‎05-14-2019 08:35 AM
‎05-14-2019 08:35 AM
Thank you Dan and Kurt; I will speak with my SAS admin and have them make the needed changes. ... View more

Re: Java Out of Memory Error

by Fluorite | Level 6 in Graphics Programming
‎05-13-2019 01:22 PM
‎05-13-2019 01:22 PM
Thanks Dan. You are correct; I cannot access the config file. I start SAS using Enterprise Guide v 7.1.  ... View more

Java Out of Memory Error

by Fluorite | Level 6 in Graphics Programming
‎05-13-2019 12:17 PM
‎05-13-2019 12:17 PM
Hi,   I am using SAS server version 9.4 to make some large graphs and I get the following error message:   ERROR: Java virtual machine exception. java.lang.OutOfMemoryError: Java heap space.   I previously used SAS PC version 9.3, and to get around this problem I edited the JREOPTONS line in the configuration file.   How do I fix this with my current version?   Thanks in advance! ... View more

Place Inset Plot Next to Main Plot Wall In GTL

by Fluorite | Level 6 in Graphics Programming
‎11-07-2018 03:33 PM
‎11-07-2018 03:33 PM
Hi,   I am making a small plot that is inset in the upper left corner of a larger main plot (using GTL in v9.3). I want the inset plot to be immediately next to the wall of the main plot and I have specified haling = top and valign = left and pad  = 0px.  The left side of the inset plot is right against the left wall of the main plot, but there is still a space between the top of the inset plot and the top of the main plot wall (result attached).  How can I make this space go away?   Here is an excerpt of the code: PROC TEMPLATE; DEFINE STATGRAPH equated; BEGINGRAPH / designheight = 10.5in DESIGNWIDTH = 7.5in; layout lattice / rowgutter = 8 columngutter = 8 columns = 2 rows = 3; layout gridded / border = false; endlayout; column2headers; entry 'Plot 1' / textattrs = (family= "Times New Roman" size = 12pt); endcolumn2headers;   *Plot1; LAYOUT overlayequated / commonaxisopts = (viewmin = 0 viewmax = 88 tickvaluelist = (0 22 44 66 88)) equatetype = square YAXISOPTS = (display = (ticks tickvalues) tickvalueattrs = (family= "Times New Roman" size = 10pt)) XAXISOPTS = (DISPLAY = (ticks tickvalues) tickvalueattrs = (family = "Times New Roman" size = 10pt)); SCATTERPLOT X = isoline_mean_1 Y= Y_mean1 / markerattrs = (size = 0.8pt) GROUP = entry includemissinggroup = false; LINEPARM X=0 Y=0 SLOPE=1 / LINEATTRS = (COLOR = gray);   *Plot1 Inset; LAYOUT overlayequated / commonaxisopts = (viewmin = -0.1 viewmax = 1.4 tickvaluelist = (-0.1 0.4 0.9 1.4)) equatetype = square WIDTH = 18pct HEIGHT = 18pct PAD = (LEFT = 0px top = 0px RIGHT = 0px) halign = left valign = top YAXISOPTS = (DISPLAY = (ticks tickvalues) tickvalueattrs = (family = "Times New Roman" size = 8pt)) XAXISOPTS = (DISPLAY =(ticks tickvalues) tickvalueattrs = (family = "Times New Roman" size = 8pt)); SCATTERPLOT X = isoline_mean_log10_1 Y = Y_mean_log10_1 / markerattrs = (size = 0.6pt color = black) GROUP = entry includemissinggroup = false; entry 'Plot 1 Inset'/ autoalign = (topleft) pad = (top = 0px left = 0px) textattrs = (size = 8pt weight = normal family = "Times New Roman"); LINEPARM X = 0 Y = 0 SLOPE = 1 / LINEATTRS = (COLOR = gray); endlayout; endlayout;       ... View more

GTL Pie Charts with Legend

by Fluorite | Level 6 in New SAS User
‎10-19-2018 04:27 PM
‎10-19-2018 04:27 PM
Hi,   I am making a lattice of pie charts with responses from four surveys.  The legend for each of the four surveys is the same, so I have added a legend to the bottom chart in the lattice.   Because the bottom chart in the lattice contains the legend, the chart area is smaller in that chart than the other three.   How can I make the chart that contains the legend be the same size as the charts that do not contain a legend?   Thanks!   proc template; define statgraph piechart; dynamic _skin; begingraph; entrytitle ''; layout lattice / columns=1 rows = 4 rowweights = (.8 .8 .8 1); layout region; piechart category=ec response = percent_of_total_study1 / dataskin=_skin datalabelcontent= none otherslice = false; endlayout; layout region; piechart category=ec response = percent_of_total_study2 / dataskin=_skin datalabelcontent= none otherslice = false; endlayout; layout region; piechart category=ec response = percent_of_total_study3 / dataskin=_skin datalabelcontent=none otherslice = false; endlayout; layout region; piechart category=ec response = percent_of_total_study4 / name = "ec" dataskin=_skin datalabelcontent= none otherslice = false; discretelegend "ec" / location = outside /*Title = "Category"*/ valueattrs = (size = 12pt); endlayout; endlayout; endgraph; end; run; ... View more

Re: Wrap SGPANEL Column Headers (9.3)

by Fluorite | Level 6 in Graphics Programming
‎11-27-2017 11:20 AM
‎11-27-2017 11:20 AM
Thank you so much shahparth260 and Dan for your replies to my question; I can now create the plot that I need with this information! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-28-2023 02:00 AM
Likes given to
View All
Likes from
View All
Quick links