The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
Details
  • Views 12372 views
  • Replies 5 replies
  • Subscribers 542 subscribers
  • Users 0 members are here
Labels
Related Census Bureau Resources
Related Forum Threads

Stata error with ACS API

Vincent Palacios
over 6 years ago

Hi all,

I'm having intermittent trouble using the Census ACS API in Stata 15.0. For a brief period, the API calls were working fine in my office. Now they've stopped working, and when I make the following API call I get the following error message:

gen str60 B01001_001E = ""

gen str60 geoname = ""

gen str60 state = ""

insheetjson B01001_001E geoname state using "api.census.gov/.../acs1, aoa(1) columns( "1" "2" "3" "4")

Received fatal alert: handshake_failure
Error -603, Unable to open URL: file could not be opened
Warning: No response from source?!?

* Notes: I've left the API key empty above but am using my personal key in practice. This requires insheetjson.ado and libjson.mlib to be installed. 

I can't tell if it's a Stata issue, firewall issue, or Census server issue. When I past the API directly into a Chrome browser window it works fine, so I suspect it's one of the first two or a combination of the first two.

I've had trouble just copying files from the Census FTP server within Stata as well. For example, this simple command fails in similar fashion.

copy "" "mar98supp.zip"

Received fatal alert: handshake_failure
r(5100)

 

Has anyone else experienced this issue with Stata 15.0, or any recent version for that matter? Or has anyone noticed a change in behavior recently?

Many thanks,

Vincent

  • over 6 years ago
    Hi Vincent,
    I too am having this problem. I receive the same error using Stata 15 on a Windows 10 machine and on a Stata 13 MacOS 10 machine using two different networks.

    Did you or anyone else find a solution?

    -Andrew
  • over 6 years ago in reply to andrewbreck
    Hi ,

    Unfortunately, I did not. My experience has been that I've had issues from both Stata's end and from the Census, and things work one day and break the next.

    One of my colleagues has adapted a work around to use Stata and Python together, where Python makes the connection and retrieves the data, and then Stata reads in the data from a temporary csv stored locally. It's not the best approach, but solves our immediate needs.

    I also use R, which has some pretty robust support for the ACS API, but since I often work with Stata and PUMS I have to reteach myself the packages each time I dip my toes in that world. If you work with ACS summary data a lot, it might be worth looking into those packages ("acs" or "censusapi" come to mind).

    Hope this is helpful,
    Vincent
  • over 3 years ago in reply to andrewbreck

    FWIW Stata 17 has the semblance of native support for Python, and I've been using Python to pick up the JSON files from the Census API and pass them as Stata data frames. I can share some code if needed.

  • over 3 years ago

    Works fine on my system.
    That's on Stata 15.1 on Win10
    I used the key from your second code block, btw, so that's not causing the trouble.

    Edit: also works if I include a line 'version 14.2' prior to this code, although I'm not 100% sure that would always recreate the issue.

    Code:

    . cap prog drop apicheck

    . program apicheck
      1.     tempfile webfile
      2.     copy "">api.census.gov/.../sf1 "webfile.txt"
      3.     import delimited "webfile.txt", clear
      4. end

    . apicheck
    (5 vars, 238 obs)

    .
    end of do-file

    . edit

    .

For more information about the American Community Survey Census Bureau Website