topic Re: importing data from a website in SAS Programming

importing data from a website

Mike7 — Tue, 25 Apr 2017 02:46:47 GMT

Whats the best way to import the data on this website https://download.bls.gov/pub/time.series/la/la.data.3.AllStatesS

to SAS

Re: importing data from a website

Reeza — Tue, 25 Apr 2017 03:40:23 GMT

http://www.sascommunity.org/wiki/Tips:Read_Files_From_Web_Sites_Into_Your_SAS_Program

@Mike7 wrote:

Whats the best way to import the data on this website https://download.bls.gov/pub/time.series/la/la.data.3.AllStatesS

to SAS

Re: importing data from a website

art297 — Tue, 25 Apr 2017 03:24:45 GMT

The paper that @Reeza suggested is definitely a good start, but you can read that file directly. I'd try the following:

filename theurl URL "https://download.bls.gov/pub/time.series/la/la.data.3.AllStatesS";

data want;
    infile theurl truncover firstobs=2 dlm='09'x;
    informat series_id $20.;
    input series_id year period	$ value footnote_codes $;
run;

Art, CEO, AnalystFinder.com

Re: importing data from a website

Reeza — Tue, 25 Apr 2017 03:40:05 GMT

@art297 its pretty much exactly your code 😉

Re: importing data from a website

Mike7 — Wed, 26 Apr 2017 21:46:34 GMT

thank you

Re: importing data from a website

Reeza — Wed, 26 Apr 2017 22:48:57 GMT

@Mike7 Please mark the appropriate answer as the correct answer, like Art's solution. NOT this comment please.