From: rjf2 on
> From: Webb Sprague
> Sent: Monday, October 19, 2009 1:20 PM
> Subject: SAS recipe for end-to-end workflow?
>
> Hi all
>
> (First, I am a SAS newbie, though an experienced programmer. I have
> googled a little for this, I promise...)
>
> I would like to automate some data analysis processes in population
> estimation, which would take a bunch of csv data files

* Making Lists

http://www.sascommunity.org/wiki/Making_Lists


> and some shapefiles

http://en.wikipedia.org/wiki/Shapefile

> as the beginning, do stuff to them (including some
> geographic intersections to get appropriate FIPS codes and the like),

http://support.sas.com/documentation/cdl/en/graphref/61884/HTML/default/
a002117201.htm

http://www.geocities.com/statbookstore/sas/saslang/function.html

> make pretty postscript tables,

http://www.adobe.com/devnet/opentype/afdko/topic_tables_win.html


hmm, TPL and PROC Tabulate users, take note:

http://en.wikipedia.org/wiki/TPL_Tables

> surround the tables with text, and
> output the final InDesign / postscript file

It would have been nice if you had said
Adobe/InDesign

http://tryit.adobe.com/us/cs4/indesign/p/?sdid=ETLLA


> that is ready to ship to a
> customer after a quick QA on a windows desktop.

Choose most important: "Best two, out of three."
* fast
* accurate
* cheap

> I want all my tweaking to be done in the code, rather than by hand; so
> if a border needs to be switched from 1 point to .5 point, I want to
> write code to do this, not open the document and do it by hand.
>
> Does anyone have a skeletal recipe or a link for this? If SAS can't do
> it, I don't know what can...

I think your problem is:

Q: Which ODS destination will output a file that
Adobe/InDesign can manage?

see ODS PDF
and much to my surprise: ODS PS

http://support.sas.com/rnd/base/ods/odsprinter/


"Good luck: that amorphous combination of
* determinatin
* hard work
* persistence
that gets you recognition,
about ten years into your career."

Ron Fehd the occasionally known as 'lucky' maven CDC Atlanta GA USA
RJF2 at cdc dot gov