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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.