Hello guys, Does anyone know how to put SAS data (like two numbers) into specific cells (for example, Q5:Q6) in Excel sheet without using dde command because it does not work in Enterprise Guide. This is for reporting purpose and I want to automate the report generating process. I know cope and paste would work, but I just want to see if I can fully utilize the functions in SAS. I know you can create a excell libname reference, like: libname something EXCEL "location/filename.xlsx"; And it can create a new Excel sheet or create a name-range for the data, but I haven't found ways to put data into specific cells using this method. Thank you, Mandy
... View more