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 -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Graham, Todd Sent: Thursday, May 12, 2011 1:52 PM To: &#39;ctpp-news(a)chrispy.net&#39; Subject: [CTPP] RE: Question on 2010 Census data and linking to the Accessfile Do you have SAS in your shop? I can provide you my SAS code for loading, compiling and merging the Redistricting, the AGQ, and the DPSF. Can't offer any help on the Access. Good luck. ________________________ Todd Graham Principal Forecaster and Project Manager Metropolitan Council 390 Robert Street North Saint Paul, MN 55101 ph: 651/602-1322 email: todd.graham(a)metc.state.mn.us <mailto:todd.graham@metc.state.mn.us> web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jason Gillow Sent: Thursday, May 12, 2011 12:07 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Question on 2010 Census data and linking to the Access file Hello all I was wondering if anyone had a chance to figure out how to import the 2010 Redistricting data or the new 2010 demographic profile information into the Access files on the http://www2.census.gov/census_2010/ <http://www2.census.gov/census_2010/> , under http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ <http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/> and http://www2.census.gov/census_2010/03-Demographic_Profile/ <http://www2.census.gov/census_2010/03-Demographic_Profile/> . I have been confused about this process myself. Does anyone know of any good guides to help? Any ideas or suggestions? I have been using the new American FactFinder 2 too, but that has been a slow and confusing process too. Thank you Jason Jason Gillow Research/Planning Specialist II Ohio Valley Regional Development Commission 9329 St Rt 220 E, Suite A Waverly, OH 45690 Phone 740-947-2853 or 800-223-7491 (In Ohio) and Fax 740-947-3468 Website: www.ovrdc.org E-mail- jgillow(a)ovrdc.org