topic SAS Mainframes SMTP email csv file in SAS Programming

SAS Mainframes SMTP email csv file

makata — Thu, 27 Apr 2017 12:55:53 GMT

Hi,

I am emailiing mainframe PS file as attachment in excel file format.

the excel file name is more than 31 chars for ex ."Test format pro marketing - All - time test data for verification".

when i opened the file using excel the work book name is proper,however sheet is truncated at 31 char for ex "Test format pro marketing - All - t"

How to set the excel sheet name different from theexcel work book while sending email attachemnt from mainframes.

Please suggest.

Re: SAS Mainframes SMTP email csv file

Kurt_Bremser — Thu, 27 Apr 2017 13:03:47 GMT

The maximum length of a worksheet name in Excel is 31 characters, period. No way around that.

Re: SAS Mainframes SMTP email csv file

makata — Thu, 27 Apr 2017 16:04:13 GMT

Hi,

Thanks for quick response..

is it possible to set workbook name and sheet name different..

for a given Mainframe file name - test.sample

for ex. work book name as sample.xlsx

worksheet name as sheettest

Thanks

Mallik

Re: SAS Mainframes SMTP email csv file

Kurt_Bremser — Fri, 28 Apr 2017 06:07:27 GMT

I have no idea if libname xlsx works on a mainframe; if it does (SAS/ACCESS to PC Files must be installed and licensed), you can treat the workbook like a SAS library, and each "dataset" written to it will be a sheet.

How you address a Excel file on the mainframe is a different beast, though. See "z/OS file catalog".

FWIW, I never ever export to Excel directly, I always use csv as transfer format. Textuality rules. Let the recipients cobble the data together in Excel, if they want.