import excel file from the web

[vxhong17]

I want to import an excel file from http://www2.census.gov/acs2005/Tables_Profiles_Subject_Tables/010Nation/United States.xls into SAS. I used the following code. However, It did not work. Could anyone help me out? Thank you so much!!!

FILENAME website url "http://www2.census.gov/acs2005/Tables_Profiles_Subject_Tables/010Nation/United States.xls" debug;

data file;

   n=-1;

   infile website recfm=s nbyte=n length=len;

   input;

   file  "United States.xls" recfm=n;

   put _infile_ $varying32767. len;

run;

PROC IMPORT OUT= input DATAFILE= "United States.xls"

      DBMS=xls REPLACE;

     SHEET="Base Tables";

     GETNAMES=YES;

RUN;

[Amir · Accepted solution]

Hi,

Try using a slightly changed URL in your filename statement as follows:

FILENAME website url "http://www2.census.gov/acs2005/Tables_Profiles_Subject_Tables/010Nation/United%20States.xls" debug;

If that does not work then please explain what you meant by "did not work" and share your log with any error messages.

Regards,

Amir.

[vxhong17]

Hi Amir,

It works now. Thank you so much.

Best Regards,

Hong,