importing data from a website

[Mike7]

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

[Reeza]

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

---

[art297]

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

[Reeza]

@art297 its pretty much exactly your code 😉

[Mike7]

thank you

[Reeza]

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