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.