This works for any dataset of your choosing, not just those in the SASHELP library. You can specify sending your data to a new sheet and provide the name:   ... View more

This first note is a BUG in the IMPORT procedure (or something that it calls under the hood).  It does not impact how the proc runs so it shouldn't issue that note.   The second is also probably due to limitations of how PROC IMPORT works.  Try first copying the text from the URL to a physical file and pass that file to PROC IMPORT.   filename _fixed url "https://s3.amazonaws.com/cfpb-hmda-public/prod/apor/YieldTableAdjustable.txt"; filename copy temp; data _null_; infile _fixed; file copy; input; put _infile_; run; PROC IMPORT OUT= work.adjustable REPLACE DATAFILE= copy DBMS=dlm ; DELIMITER='|'; GETNAMES=YES; RUN; Or since it is just a text file skip the PROC IMPORT step altogether and just write your own data step to read from the fileref.  This also has the advantage that you can control how all of the variables are defined. data work.adjustable ; infile _fixed dsd dlm='|' truncover firstobs=2; input .... ; run;   ... View more