Thanks Reeza and Peter for your valuable suggestions here. I am currently trying to generate this .xlsx using SAS Stored Process on Unix Machine. The DDS and VBS options are really good options for batch jobs and also with programs that stores the output in some permanent locations. But since the file that needs to be converted to ".xlsx", has to be stored in some permanent location. In SAS Stored Process, we can run the report online (and get the output on the fly). Could you please guide me, if the above options can be applied to SAS Stored Process. Thanks again for your help so far.
... View more