You can try to use a LIBNAME for XLSX files if you have SAS 9.4M2 and larger maintenance(M).  You can use the LIBNAME to directly import from spread sheet or export to spread sheets. LIBNAMES are great. See some of the SAS LIBNAME XLSX You Tube Videos to get a new look at the feature. These YouTube videos were created 3 years ago by Kathy Kiraly https://www.bing.com/videos/search?&q=sas+libname+xlsx&view=detail&mid=C4F78C565029C018D133C4F78C565029C018D133&FORM=VDRVRV&ru=%2Fvideos%2Fsearch%3Fq%3Dsas%2520libname%2520xlsx%26qs%3DMT%26form%3DQBVR%26%3D%2525eManage%2520Your%2520Search%2520History%2525E%26sp%3D3%26ghc%3D2%26pq%3Dsas%2520libn%26sk%3DMT2%26sc%3D10-8%26cvid%3D72ABD27D0584421C9CE9D034184A9006&ajaxhist=0   ... View more