I have a simple daily dashboard I distribute via PDF and I was asked to add a chart to visualize one of the tables.  The Proc SGPLOt statement below works for me by itself, but when I wrap it in the ODS PDF statement, I get a blank page in the PDF.  When I run the SGPLOT by itself in the ODS PDF statement (i.e. getting rid of the proc print statements) I get some results, albeit they do look different on the PDF compared to being run outside of a PDF statement).  Is there anyway to get this to work?  Ideally, I would like to keep the first two tables on one page and then have one table and a chart on the second page.  I thought the conflict might be page size limitations, so I moved the SGPLOT to it's own page, with the same (blank page) results.  Any assistance is greatly appreciated.  Thanks! ods listing; goptions reset=all; options date nobyline nonumber orientation=landscape; ods pdf file='/filelocation/Dashboard.pdf' startpage = never style= BarrettsBlue; proc print data=mydata1 noobs contents=""; run; ods proclabel ' '; ods escapechar='^'; proc print data=mydata2 noobs contents=""; run; ods pdf startpage=now; proc print data=mydata3 noobs contents=""; run; ods pdf startpage=now; PROC SGPLOT DATA = MyData3 description="";   SERIES X = Week Y = Group1 / lineattrs=(color=VIGB thickness=2) markers markerattrs=(symbol=asterisk color=VIGB);   SERIES X = Week Y = Group2 / lineattrs=(color=MAROON thickness=2) markers markerattrs=(symbol=circle color=MAROON);   SERIES X = Week Y = Group3 / lineattrs=(color=DELG thickness=2) markers markerattrs=(symbol=triangle color=DELG);   XAXIS TYPE = DISCRETE; RUN; ods pdf close; ... View more

I'm trying to write a simple proc print to PDF and use proc document to rename the PDF bookmarks (this part works) but I noticed it removes my BY groupings in the PDF (only after running the PROC DOCUMENT step).  The code below prints 9 pages of the same output with no page breaks by the BY variable.  Is there any way to rename the PDF bookmarks but keep the BY variable grouping to be on individual pages? Thanks! ods listing; options nobyline nonumber nodate orientation=landscape; ods document name=myreport(write); ods pdf file='test.pdf' style= BarrettsBlue; proc print data=setOrder noobs; by Region; run; ods pdf close; ods document close; proc document name=myreport(update);   ods listing;   list / levels=all; run;   ods listing close;     setlabel Print#1\ByGroup1#1\Print#1 "";   setlabel Print#1\ByGroup2#1\Print#1 "";   setlabel Print#1\ByGroup3#1\Print#1 "";   setlabel Print#1\ByGroup4#1\Print#1 "";   setlabel Print#1\ByGroup5#1\Print#1 "";   setlabel Print#1\ByGroup6#1\Print#1 "";   setlabel Print#1\ByGroup7#1\Print#1 "";   setlabel Print#1\ByGroup8#1\Print#1 "";   setlabel Print#1\ByGroup9#1\Print#1 "";   run; ods pdf file='test.pdf'  style=BarrettsBlue pdftoc=1;   replay l; run; ods pdf close; ods listing close; quit; ... View more

I am trying to create a prompt that will allow users to pick a variable to summarize on a map.  Since the variables will all have different ranges of values, I created a univariate that will group values to summarize by when the project is run.  The problem I am having is converting the macro variables I create from the univariate into strings for a proc format statement (the proc format will be used to set the legend values of the map).  For example, if &Quant_20 resolves to say 5%, I would like to format the first value of the proc format to read "< 5%" and the next string will be the value between &Quant_20 and &Quant_40.  I think the solution is some kind of %symfunc statement using cats() to join the strings, but either I can't get the double quotes correct or I am going down the wrong path.  Below is some sample code. Any help is greatly appreciated! proc univariate data=calcVar noprint;   var Per_Metric;   output out=Quantile   n=ny mean=meany   pctlpts=0 to 100 by 20   pctlpre=py_; run; data _null_;   set Quantile;   call symput ('Quant_20',PY_20);   call symput ('Quant_40',PY_40);   call symput ('Quant_60',PY_60);   call symput ('Quant_80',PY_80); run; %put &Quant_20 &Quant_40 &Quant_60 &Quant_80; proc format;   value Groups   1=&Quant_20.   2=&Quant_40.   3=&Quant_60.   4=&Quant_80.   5=&Quant_20.; run; ... View more

I am trying to parse a string and look up the alpha part in a look up table.  My string follows the format A0B0C0D0...X0, where the letters represent a product and the numbers represent a frequency of that product, so for example a string starting A0B2 could represent a mix of 0 apples and 2 loaves of bread.  I would like to parse this string out and hit it against the look up table basically to translate the results back to English.  My first problem is how to loop through the strings (I have about 300k records) and then also how to eliminate results with 0 frequencies and pull the product names from the look up table (for the products with frequency >0) and output the product names and counts, i.e the end result would say "this customer bought 5 loaves of bread and 2 chocolate bars).  Any help is appreciated. ... View more

Are there any output options for PROC GMAP that don't produce two separate files in the output destination?  I have tried using goptions=png and goptions=gif, but both of them produce two files for each map, a .htm file and a .png file.  I am running a loop that creates hundred of maps using gmaps, which I want to output and then use the image files to create a animated GIF, so I would like to avoid duplication of the files if possible. Also, is there a way to control the names of the output?  I.e. changing them from gmap1, gmap2 etc. to something more descriptive? Thanks! ... View more

I have encountered a problem when trying to add a title to an html map.  I imported a shape file from ESRI (which had about 9 million data points), ran a GREDUCE, limited to density <=1 and then a GPROJECT and used the code below to map. proc gmap data=SR_Proj map=SR_Proj; id SRV_REGN; choro SRV_REGN / nolegend html=SR_HTML; run; quit; Note: I am only using a data file equal to the map file to test the data boundaries.  The code above works when I exclude the HTML statement, but when I include it, I get the follwing error message and no map results: ERROR: Integer divide by zero. ERROR: Termination due to Floating Point Exception I've been researching that error message and most of the results seem to do with divide by 0 errors, missing data errors and such (I have confirmed there is no missing data in my HTML field), not related to GMAP.  Any help is appreciated.  Thanks! ... View more