This was just a test, but changing width to 58 makes the rectangle a bit wider; the x/y origin of it still remains in the center of the layout region.  I'd like to figure out how to position it's starting point to the left side of the region shown in cyan.   Thanks!   --Ben ... View more

Hi Cynthia,   That did it!  I was even able to increase the font size a hair for readability and it still all came out.   Thank you so much!   --Ben ... View more

Hi Cynthia,   Thanks for looking at it.  Yes, I can solve the issue by making the cells higher but it is fitting into a fixed section of a report and that's all the room it has.  Making it taller will run into other stuff.   See the space at the top of each cell in gray?  How do I get rid of that?  If that were eliminated it likely would all fit.   Much appreciated...   --Ben ... View more

Hi Cynthia,   That's odd. Thought I had attached it.  Obviously not. 🙂   I hadn't asked TS yet on this one.  Was hoping it was something obvious I have missed.I seem to be having   I seem to be having problems attaching a file ending in .sas so I added it below.   --Ben   %let path=c:\temp\; %let Tan    = CXE59005; %let Tan2   = CXFAA72E; %let Tan3   = CXFCBE64; %let Tan4   = CXFCD49A; %let Tan5   = CXFDE6C3; %let Blue   = CX2B6BB0; title; * Generate fake data for testing; data pcts; input repid pct zip; topzip+1; if lag(repid)^=repid then topzip=1; cards; 1 53 43058 1 17 43220 1 12 43235 1 7  43081 1 4  43214 ;;; ods escapechar='^'; options nodate nonumber nobyline orientation=landscape topmargin=.001in bottommargin=.001in leftmargin=.001in rightmargin=.001in; ods html close ; ods pdf file="&path.ziptablerpt.pdf" notoc; ods layout absolute y=0in x=0in  width=10.98in height=8.48in;  * Define an absolute layout container with optional size parms; ods region y=5in x=.5in width=1.5in height=2.75in style={background=cyan}; proc report data=pcts style(report)={cellpadding=0pt} style(column)={height=.32in} style(report)={borderwidth=0 cellpadding=1pct};    by repid;    column topzip square pct zip boilerplate;    define topzip /display order noprint;    define pct    /display noprint;    define zip    /display noprint;    define square /display computed       "«" right                                          style(header)={font_size=16pt fontfamily='<ttf> Wingdings' vjust=m color=blue}                                          style(column)={font_size=16pt width=.3in vjust=m just=c fontfamily='<ttf> Monotype Sorts'};    define boilerplate /display computed  'You are located here' left                                          style(header)={font_size=7pt }                                          style(column)={font_size=7.5pt width=1.1in vjust=t background=grey};    compute square /character length=10;       square='n';       if topzip=1 then call define('square','style',"style={color=&red}");       if topzip=2 then call define('square','style',"style={color=&red2}");       if topzip=3 then call define('square','style',"style={color=&red3}");       if topzip=4 then call define('square','style',"style={color=&red4}");       if topzip=5 then call define('square','style',"style={color=&red5}");    endcomp;    compute boilerplate/character length=120;       boilerplate=cats(pct)||'% of your Regional^{newline 1}/Customers reside in ^S={color=blue}'||left(zip);    endcomp; run; ods layout end; ods pdf close; ... View more

Looks like the schema wasn't included in the default definition we use to access the DB; I have to include it explicitly. So the code KSharp provided told me what schema they had given to it. Thanks to all with this! --Ben ... View more

Wow.  Didn't even know what this did.  That returned a large amount of information.  Will have the DBA compare it to what we should have assigned to us for a Table schema.  Thanks!   --Ben ... View more

Thanks!  Anything I should tell them to look for?   --Ben ... View more

This is on a SAS server and the ODBC entry was pre-defined.  So I don't know what the schema was, unfortunately, much less if it was set properly.  I don't have access directly to the DB server.  So that's why I had to phrase the question as I did.   --Ben ... View more

While I wasn't able to find a solution to the original question, I found a way to get (mostly) the same thing done:   x " ""C:\Program Files\SASHome\SASFoundation\9.4\sas.exe"" -sysin ""&runpath\test1.sas"" -log ""&runpath\test1.log"" "; also works nicely for kicking off an external SAS run.  Coupling it with noxwait and noxsync then allows a controlling SAS sheduler to spawn off different SAS runs at will without getting held up waiting for each to complete.  This was the final goal.   Thanks!   --Ben   ... View more

That's certainly not a problem.  I called it runsas.bat: echo Initiating run for %3.sas echo 1=%~1 echo 2=%~2 echo 3=%~3 pause %1 cd %2 copy lock %3.lck "C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -sysin "%3.sas" -memsize max del %3.lck   The first 4 lines are for debugging and will go away.  The object was to run it from SAS with the X command.  Argument 1 is the drive letter; argument 2 is the path to the SAS program to be run; argument 3 is the name of the SAS source file w/o a suffix.   The file 'lock' is a single character file used as a blocking semaphore.  Or will be when I get this working.   Since the path can have embedded spaces in it, this has been causing me grief trying to get it right.   --Ben   ... View more