Hi,   Did you try to use the LS option coming with the SFTP method of FILENAME? From the SAS® 9.4 Statements: Reference, Fifth Edition and its FILENAME Statement, SFTP Access Method chapter, we have:   Other options such as LSFILE, etc. might help you too.     From that same page, you'll also have access to Exemple 4: Reading Files from a Directory on the Remote Host. This can be done after you retrieved the file name: This example reads the files test.dat and test2.dat from a directory on the remote host. filename infile sftp '/users/xxxx/' host="unixhost1" dir; data _null_; infile infile(test.dat) truncover; input a $25.; infile infile(test2.dat) truncover; input b $25.; run;   Hope that helps. (Sorry I can't test, i don't have a SFTP available).   Cheers, Damo ... View more

All output from SAS is output from ODS. There is the default ODS HTML output that you get from most editors; the default SASReport output that you get from EG and then there are other outputs that can be created, such as RTF and PDF. Generally, HTML-based destinations do not have column headings wrap as much as RTF or PDF because the HTML browser screen is not "bound" to a physical page size. As Reeza suggests, more of your code is required. What are the names of the 2 files created? Is one of them a default file? What is the result format for the other file? What version of SAS are you using? How are you using SAS -- are you using University Edition, or SAS Enterprise Guide? Did you turn any result options on or off? Does your code have any explicit width controls? It is impossible to do more than guess without more informaiton from you. cynthia ... View more

Hi,   You will want to look at preimage.  Cynthia provides a very nicely explained post on the subject here: https://communities.sas.com/t5/ODS-and-Base-Reporting/TEMPLATE-and-PREIMAGE/td-p/93316   ... View more