Sorry, I don't have a clue when it comes to arrays - your response doesn't make any sense to me, I need to see the whole code to understand ... View more

Can I use an array to format numeric values already created?   For example, if I wanted an array to format 3 columns, StartDT1 - StartDT3 to be DATE9.   Cheers ... View more

@Patrick   Thank you for all your help.   I'm now trying this route but I'm still getting messages saying the file is corrupt in my email attachment but I'm sure I will figure it out.   data class; set sashelp.class; run; data cars; set sashelp.cars; run; PROC EXPORT DATA= class outfile= "/user/&user/test.xlsx" dbms=xlsx replace; sheet="Class"; PROC EXPORT DATA= cars outfile="/user/&user/test.xls" dbms=xls; sheet="Car"; run; FILENAME SEND EMAIL TO = 'cameron@gmail.com' SUBJECT = 'MULTI-SHEET' attach=("test.xls"); ; DATA _NULL_; FILE SEND ; PUT 'PLEASE RECEIVE THE ATTACHED. -- REGARDS,'; RUN ;   Cheers   ... View more

Can I not do something like this...   PROC EXPORT DATA= Sashelp.Class outfile= "c:\temp\want.xlsx " dbms=xlsx replace; sheet="Class"; PROC EXPORT DATA=sashelp.cars outfile="c:\temp\want.xlsx" dbms=xlsx; sheet="Car"; run; ... View more

@Patrick   Nice one thanks!   Although when I run your code below...   I get the following error when trying to download the file = 'Unable to open the external viewer. There is no application associated with the '.sge' file type.     ... View more

version=9,4 ... View more

@Patrick   Thanks.   I don't understand how I can run the below code and then able to download the excel file and view perctly fine but then when sending the email it doesn't like the file I have and tells me it's corrupt in all different file extensions.   DATA PRDSALE; SET SASHELP.PRDSALE; DIFFERENCE = ACTUAL-PREDICT; RUN; PROC SORT DATA=PRDSALE; BY COUNTRY REGION DIVISION YEAR; RUN; QUIT; ods tagsets.excelxp file='test.xml' options(sheet_interval="bygroup"); proc report data=PRDSALE; by country; where year=1993; run; ods tagsets.excelxp close; FILENAME SEND EMAIL TO = 'cameron.rutherford@rci.com' SUBJECT = 'MULTI-SHEET' attach=("test.xml"); ; DATA _NULL_; FILE SEND ; PUT 'PLEASE RECEIVE THE ATTACHED. -- REGARDS,'; RUN ;   I've just ran ... <span class="token procnames">proc</span> setinit<span class="token punctuation">;</span><span class="token procnames">run</span><span class="token punctuation">;</span>  and I get this... proc setinit;run; NOTE: PROCEDURE SETINIT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 339.65k OS Memory 35992.00k Timestamp 05/31/2017 07:00:05 AM Step Count 83 Switch Count 18 Page Faults 0 Page Reclaims 62 Page Swaps 0 Voluntary Context Switches 35 Involuntary Context Switches 9 Block Input Operations 544 Block Output Operations 0 Original site validation data Site name: 'SITE XXXXX'. Site number: XXXXX. Expiration: 29JUN2017. Grace Period: 45 days (ending 13AUG2017). Warning Period: 45 days (ending 27SEP2017). System birthday: 26JUL2016. Operating System: LIN X64 .   ... View more

@Patrick   Yes its Enterprise Guide.   I don't have anything that says 'current version' ... View more

SAS Version 6.1 M1HF7 (6.100.0.4234) (64-bit) ... View more

Can you show me the equivalent of what I have as ODS excel please? ... View more

@Patrick @RW9   How can I amend to use ODS Excel? ... View more

Hi,    I tried xlsx and it says its corrupted still.   Cheers ... View more

When I open the file it says: 'The file you are trying to open, 'tmpE3AF.tmp.xls', is in a different format than specified by the file extension. Verify thatthe file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?'   I open it and it's fine, but when I send by an email it doesn't like it.     ... View more