Hary—

See attached.

This will be useful to SAS users.  (Others can delete this -- sorry.)

You’ll want to check and edit all the physical file locations in the code.

And search the text for instances of ‘MN’ and replace with your own state postal code.

Finally, if there are pieces of this you don’t need… just cut them out /* or comment out*/

________________________

Todd Graham

Principal Forecaster and Project Manager

Metropolitan Council

390 Robert Street North

Saint Paul, MN 55101

ph:  651/602-1322

email:  todd.graham@metc.state.mn.us

in:  www.linkedin.com/in/toddgraham

web:  http://www.metrocouncil.org/data/

________________________

-----Original Message-----
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Hary Prawiranata
Sent: Thursday, May 12, 2011 1:29 PM
To: ctpp-news@chrispy.net
Subject: RE: [CTPP] RE: Question on 2010 Census data and linking to the Accessfile

Please post your SAS code here for everyone, we can learn the logic and

rewrite it for other db.

Thanks,

Hary