censusapi package

[Jessica Choi]

Hello,

I am trying to use the censusapi codes and having issues. At the moment, I am limited to code within a server and I am unable to use the internet during my tasks. Per help censusapi page, it looks like it may be possible to call an excel spreadsheet that is physically located within the server:

Example 2: the alternative method, illustrating also the variable parsing and saving capacities
. censusapi, dataset(https://api.census.gov/data/2019/acs/acs5) variables(B17001_001E B17001_002E) predicate("for=county:*") destination("2019_acs_data.txt")

Adapting this example, I tried:
censusapi, dataset("a census data excel file name") variables(P0010003 P0010008) predicate("for=county:*")

However, this gives me an error message "varlist not allowed". How can I overcome this error?

Thank you,
J

[George Ford]

I think dataset needs to be the web address of the source data, not an excel file.

what are you looking for?

[George Ford]

I can't get censusapi to work even using the code from the help file. Something may be wrong.

[Jesse Wursten]

It is not possible to use censusapi to access a local dataset.

The examples in the help file work for me, are you potentially using an older version of censusapi?

. which censusapi
c:\ado\plus\c\censusapi.ado
*! Version 2.0.2 03jun21