Prev: SAS-L Digest - 5 Jan 2010 - Special issue (#2010-9)
Next: How to schedule SAS job on mainframe
From: Jack Hamilton on 5 Jan 2010 10:54
I don't think there is a mainframe program that knows how to read Excel
files - there's not from SAS Institute, and I haven't heard of one from
another supplier (not that someone couldn't port OpenOffice.org, but as
far as I know it hasn't happened).

When I have to do something with a PC binary file on the mainframe, I
use LRECL=80 RECFM=FB BLKSIZE=0 (that is, the blocksize doesn't matter,
so I let the computer decide what it wants to use). RECFM=FBS would
probably work also, but I haven't tried it.



On Thu, 31 Dec 2009 01:25 -0800, "jaheuk" <hejacobs(a)GMAIL.COM> wrote:
> Hi folks,
> does somone know how to transfer (FTP?) a pure excel sheet to
> mainframe?
> What is lrecl and blksize of mainframe file?
> I have a proc import on PC to read the "sheets" that works fine !
> I would like to do this on mainframe.
>
> Regards,
> Herman


--
Brevis esse laboro, obscurus fio.

Jack Hamilton
Sacramento, California
jfh(a)alumni.stanford.org
 | 
Pages: 1
Prev: SAS-L Digest - 5 Jan 2010 - Special issue (#2010-9)
Next: How to schedule SAS job on mainframe