Search results for query: *

I fixed it - needed the code to be on a single line. Yeah, I had a \ missing. It's back in and working fine now. Thanks for all your help.

Thanks JJ72uk for this info. I've managed to get the Excel passwording to work, but, not the zipping :-( I've tried the below code, but, it doesn't work. %let report1 = c:\sas outputs\Data &prev_yrmth.; %let filename = %sysfunc(compress(&report1)); data _null_; put '"c:program...

Hi, I'm currently trying to zip and password protect an excel file I output on a monthly basis so I can then auto email it to the relevant recipients. I've tried playing around with DDE and a few other bits I've found on the internet, but, to no avail :-( Does anyone have any idea how to do...

Thanks all for your help. I managed to get it to work with the following code: LIBNAME wrkbk EXCEL 'c:\update.xls'; /*deletes existing named range in Excel to allow overwriting in the next step*/ proc datasets lib = wrkbk; delete data; quit; /*Exports data to excel and creates data named...

Hi Klaz2002 I need to output 2 different datasets to the same excel sheet on different tabs. Is this possible in a proc export?

Hi, I'm currently trying to get SAS 9 to export to Excel 2003 on a specific tab without using DDE. I've scoured the net and got as far as the below: libname myxls "c:\update.xls"; data myxls.data; set work.update2; run; libname myxls clear; This will add all the headers in the update2...

Thank you loads, I'll give it a go. Think we have some code for sending an email done by a previous coder so I'll use that. Thanks again Lyndsey :-)

Hi, I've been asked if I can auto email data from a SAS data set. If it is possible, I'd need to send the data as text in the email rather than an attachment so it can be read on a Blackberry. Does anyone know how to do this? (or if it's even possible?) - I could really do with some help...