Lesson 2, Part 2B: Reading Data from the Web Using PROC HTTP

filename tsa "C:\Explore\SAS\Lesson2\Lesson2Data\claims-2014.xls";
 proc print data=work.claims2014(obs=5); 
 run;
proc http
    url="https://www.dhs.gov/sites/default/files/publications/claims-2014.xls"
    method="GET"
    out=tsa;
run;

PROC IMPORT DATAFILE= "C:\Explore\SAS\Lesson2\Lesson2Data\claims-2014.xls"
     dbms=xlsx REPLACE OUT= work.claims2014;
     SHEET="interactive_report";
     GETNAMES=YES;
 RUN;
Title;