There are no options for speeding up single FTP file transfers - it will use whatever network bandwidth it is allowed. You could run two or more FTP file transfers in parallel by selecting different sets of records from the originating file then append them on the target computer. You could try parallel SQL loads as well instead of appending.
Those are two different types of operations. In the first one you are just pointing a fileref at a file that you will access with with the FTP protocol. To turn that file into data you will need to read it with a data step. No data will transfer until you try to read from that fileref.
In the second you appear to be appending data to an existing table in your remote database via the ODBC engine. To improve transfer you might need to get the SAS/Access product for your specific to your database instead of using generic ODBC engine. Look for bulk load options on those drivers.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.