Can you please let me know how to extract/place the excel reports in SFTP? I have below the mentioned details available.
File protocol: SFTP
Host name:
Port num:
User name:
Password:
Where does SAS come into this? Will SAS be using the Excel reports? SFTP is a common file transfer protocol for moving files between computers. There are any number of PC tools that make it easy to do this including FileZilla and CuteFTP - google FTP tools these and you will find a whole lot more.
In the common workplace jargon your statement implies saving the file to a folder from where files are transferred by SFTP. With the information you have posted additionally you may be looking to send files by sftp. In that case have a look at the following post which has a solution Solved: Move files between server using SFTP - SAS Support Communities.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.