Why would you want to go from one hard to use format to another?
That file is a ZIP file that contains a SAS version 5 transport file that contain a single SAS dataset.
So to use it in SAS all you need to do is first download the ZIP and then unzip it and point a libref at it.
libname xx xport 'c:\downloads\LLCP2018.XPT';
proc contents data=xx._all_; run;
The output of PROC CONTENTS shows that there is just one member in the xport file and it is named LLCP2028.
So to use the file directly just use code like:
proc means data=xx.LLCP2018;
run;
If you really want to copy the datasets in the xport file into an Excel spreadsheet then make a second libref and use proc copy.
libname out xlsx 'c:\downloads\LLCP2018.xlsx';
proc copy inlib=xx outlib=out;
run;
... View more
