https://communities.sas.com/t5/SAS-Programming/FTP-of-pure-XLS-file-to-MAINFRAME/m-p/35969#M7102 Hi folks,<BR /> does somone know how to transfer (FTP?) a pure excel sheet to mainframe?<BR /> What is lrecl and blksize of mainframe file?<BR /> I have a proc import on PC to read the "sheets" that works fine !<BR /> I would like to do this on mainframe.<BR /> <BR /> Regards,<BR /> Herman Thu, 31 Dec 2009 09:24:09 GMT Jaheuk 2009-12-31T09:24:09Z https://communities.sas.com/t5/SAS-Programming/FTP-of-pure-XLS-file-to-MAINFRAME/m-p/35969#M7102 Hi folks,<BR /> does somone know how to transfer (FTP?) a pure excel sheet to mainframe?<BR /> What is lrecl and blksize of mainframe file?<BR /> I have a proc import on PC to read the "sheets" that works fine !<BR /> I would like to do this on mainframe.<BR /> <BR /> Regards,<BR /> Herman Thu, 31 Dec 2009 09:24:09 GMT https://communities.sas.com/t5/SAS-Programming/FTP-of-pure-XLS-file-to-MAINFRAME/m-p/35969#M7102 Jaheuk 2009-12-31T09:24:09Z https://communities.sas.com/t5/SAS-Programming/FTP-of-pure-XLS-file-to-MAINFRAME/m-p/35970#M7103 What exact process do you wish to perform on the "mainframe"? I believe that PROC IMPORT is not supported by SAS running on IBM's z/OS MVS system. <BR /> <BR /> You will want to consider converting your pure XLS file to a CSV-format file and use a DATA step to create a SAS file.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Thu, 31 Dec 2009 15:03:52 GMT https://communities.sas.com/t5/SAS-Programming/FTP-of-pure-XLS-file-to-MAINFRAME/m-p/35970#M7103 sbb 2009-12-31T15:03:52Z