Thanks Todd! I was in the midst of hunting for a SAS script when your email came through. With Missouri coming out next week, I will be testing it out on another state this weekend.
Frank
Frank Lenk
Director of Research Services
Mid-America Regional Council
600 Broadway, Suite 200
Kansas City, MO 64105
816.474.4240
816.701.8237
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Graham, Todd
Sent: Thursday, February 17, 2011 5:28 PM
To: ctpp-news@chrispy.net; sdc_mlist@lists.berkeley.edu
Subject: [CTPP] Census 2010 release: assembling the data
The attached will be useful to SAS users. Other readers can ignore…
( Apologies… )
I have a SAS program that loads the three text files into SAS, and then merges them into one.
98% of this code was written by Census Bureau staff… but I did make small adjustments. Fields that should be numeric format will load
as numbers (rather than as text strings !?!).
To use this code in SAS, you’ll need to (1) plug in your own file location path. And (2) search and replace string “TX” with your own state’s postal code.
Good luck.
________________________
Todd Graham
Principal Forecaster
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/
________________________
From: ctpp-news-bounces@chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Robert Wood
Sent: Thursday, February 17, 2011 3:57 PM
To: ctpp-news@chrispy.net
Subject: Re: [CTPP] Census 2010 release
OK - so TX data is out via FTP (not of AFF yet)
I tried to follow the conversion instructions, but i still can not get the data in a readable
Excel format.
If someone has been able to convert the files could you send them to me?
or give me a hint on how to get the headers right?
Thanks
bob
Robert Wood
Director
Sherman - Denison MPO
1117 Gallagher Dr., Suite 300
Sherman, Texas 75090
Tel: (903) 813-3534
Fax: (903) 813-3539
rwood@sdmpo.org
www.sdmpo.org
On 2/11/2011 11:47 AM, Jonathan Lupton wrote:
Post PL94-171 reflections:
I thought I’d share a few observations now that PL 94-171 data for my state (Arkansas) has been released.
Don’t count on the Census Bureau to keep you up to date. I got on their e-mail list to receive notification the minute the new census figures were released for my state. No luck.
We were all stranded at home (snow day – 8 inches of pretty powder, daytime high 25, a major event in Arkansas) when my boss called me from his home to say the press was calling asking for feedback about the census figures. Moral of the story: check FactFinder2
for your state on an hourly basis the week your state is due. Our figures have been out for 24 hours now and they still haven’t let me know, although I did get a pointless e-mail yesterday afternoon about the 2009 ACS.
FactFinder2 is shaky, but not entirely useless. I managed to get all the really vital stuff down – population by race for cities (including CDPs) and counties in our region. Using
FF2, however, was a bit like playing “Space Invaders.” (I’m showing my age here) There were times when I zapped the aliens and got my data, and other times when the data search blew up in my face, with a curious “dead end” situation where it was entirely locked
up and the only way to continue my search was to quit my session and start over from scratch (and I mean all the way – getting out of FF2 and back in wasn’t enough; I had to end my Firefox session and start over). The moral of the story: just keep trying,
FF2 can’t stop you if you’re determined enough.
The Map Widget from the Census 2010 web site. In case you didn’t know, you can download a cute little census 2010 widget, customized to your state, from the Census 2010 web site.
But it won’t give you notification either. The map widget didn’t show Arkansas population by county yesterday afternoon, although it’s finally showing it this morning. If you haven’t already done so, you can get the map widget here:
http://2010.census.gov/2010census/data/
I recommend playing with FactFinder2 as much as you can in advance, but it’s a strange product, with all kinds of redundancies that are probably designed to make it user-friendly, but in reality add to a new user’s
confusion. I found trial-and-error more useful for my emergency than trying to learn it methodically – there just wasn’t time, plus it’s pretty counter-intuitive. If you can get training from your SDC or regional census office, that sounds like a great idea.
I could say more about FF2, but such honesty wouldn’t be appropriate here.
Jonathan Lupton AICP
Research Planner
Metroplan
Little Rock AR 72201
501-372-3300