When concatenating multiple files in a FILENAME FTP access method statement, SAS might fail with the following error:

ERROR: Invalid physical name

This issue occurs when the individual file names are long, such as the following:

filename ftpin  ftp (
    "'sas.test123.abc.data.m201201'"
    "'sas.test123.abc.data.m201202'"
    "'sas.test123.abc.data.m201203'"
    "'sas.test123.abc.data.m201204'"
    "'sas.test123.abc.data.m201205'"
    "'sas.test123.abc.data.m201206'"
    "'sas.test123.abc.data.m201207'"
    "'sas.test123.abc.data.m201208'"
    "'sas.test123.abc.data.m201209'"
);

Workaround

To circumvent this issue, use shorter data set names to avoid exceeding FTP physical name limits. 

Shortening the file name or member names prevents the FTP file name parser from failing and allows the concatenation to work correctly.