What do you mean smaller? The fact that the map has Puerto Rico on it will make the 48 US states slightly smaller. And then the picture is small.  Make it bigger with GOPTIONS XPIXELS=800 YPIXELS=800;  Or whatever size you want. ... View more

You might try reducing (GREDUCE)  the map.  It has too many lines when the Prism is solid black.  It is likely confusing it. ... View more

If you have acceptable levels from you current GIS I would try creating a map dataset with the polygons for  each zip code to import into SAS. One recurring issue, especially with western states is that many existing Zip code map sets have large gaps of geography not associated with any zip. Or at least that was my experience starting with available Census boundary sets. ... View more

In the filename odsout '.' piece, you would change the '.' to whatever output file location you want to use, say C/my documents or something like that.  It somewhat depends on your environment, I use EG on a grid environment, so the only option I have is to use a SAS Server file location, I can't reference a local or network drive directly. ... View more

Hi: ODS MSOFFICE2K is an HTML based destination. This means that internally to the HTML, any image -- any logo, picture, graph is referenced with an <IMG> tag in the HTML. So when SAS creates output, in the absence of any instructions from you, the PNG image is created in the working directory of your SAS session. When ever you create an HTML file, whether with ODS HTML or ODS MSOFFICE2K, you need to send the HTML file itself and then any external files, like CSS or PNG files that the HTML files is referencing. This is an argument AGAINST using ODS HTML or ODS MSOFFICE2K for email. In fact, many email administrators do not want you to send HTML files in the body of the mail or even as attachments. Or, sometimes they block mail that contains HTML tags.   It might be better for you to make an RTF or PDF file with ODS (in which the image will be embedded INSIDE the document and will not be a separate image), and then send the RTF or PDF file as an attachment. cynthia ... View more

Hopefully getting upgraded to 9.4 by August, so I will try that as soon as we upgrade.  Thanks! ... View more

Note: Goptions doesn't have a lot of affect on SG procedures. ODS Graphics options would be what may need resetting. Are you getting any warning or messages in the log? Try setting the height and width using ODS Graphics /height=5in width=5in; or similar size in case the default is trying to use more space than the PDF display area allows. ... View more

I don't understand your term "by groupings"  You have the option NOBYLINE which removes the by line is that what you're talking about.   You didn't supply data for your program. options byline=1 number=0 date=0;* orientation=landscape; ods document name=myreport(write); ods pdf file='~/test.pdf' style= BarrettsBlue; proc sort data=sashelp.class out=class; by age; run; proc print data=class noobs; by age; pageby age; 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 ""; run; ods pdf file='~/test2.pdf'  style=BarrettsBlue pdftoc=1;   replay; run; ods pdf close; quit; options byline=1 number=1 date=1;* orientation=landscape; ... View more

Proc format can take a dataset as inputs, rather than mucking around with macro variables. Look up cntlin= datasets and how to format your dataset. http://www2.sas.com/proceedings/forum2007/068-2007.pdf ... View more

Hi, I'm sorry I guess I pasted the wrong version. "desc" only contains the name of the last product but your desired output is supposed to be in "result". The reason why it is empty/buggy is because there is no handling of blank padding thus at every loop iteration, the concatenation was trying to concatenate 500 blanks with whatever additionnal info and truncating to the 500 blanks. Here's the fixed version without removal of the ending comma atm although that isn't overly complicated to add. data want;      length id $1. count $1. desc $20. result $500.;      if _N_=1 then do;      declare hash myhash(dataset: 'lookuptable');      myhash.defineKey('id');      myhash.defineData('desc');      myhash.defineDone();      end;       set have;       do i=1 to 4; /* taking advantage of fixed length and 24 different codes - here only 4 for the example data */           id = substr(string, i*2-1, 1);           count = substr(string, i*2, 1);           if count NE "0" then do;                myhash.find();                result=cat(trim(result), trim(desc), " ", trim(count), ",");           end;      end;      drop desc count i id; run; Sorry about that. Vincent ... View more