topic Re: import excel file from the web in SAS Programming

import excel file from the web

vxhong17 — Tue, 14 May 2013 22:54:26 GMT

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!!!

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 — Wed, 15 May 2013 12:54:50 GMT

Hi,

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

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 — Wed, 15 May 2013 22:01:27 GMT

Hi Amir,

It works now. Thank you so much.

Best Regards,

Hong,