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
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
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
@art297 its pretty much exactly your code 😉
thank you
@Mike7 Please mark the appropriate answer as the correct answer, like Art's solution. NOT this comment please.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.