Hi Cynthia,   Thank you for taking out the time and answering my queries 🙂   I do have SAS addin capability but for this particlualr task I need to update raw data into a excel sheet with pivot already existing and then somehow mail that to end-user.   I will look into VBA if that can help me.   Appreciate your help o t he same.     Best, Vikas       ... View more

Thanks Kurt, so there is no way to do the same in SAS 9.3? ... View more

Hi Kurt,   Thank you for taking out the time to address my SAS problem.   Basically what I am trying is   1) copy the one excel with pivot to SAS temp using below,   data _null_; length filein 8 fileid 8; filein = fopen('in','I',1,'B'); fileid = fopen('out','O',1,'B'); rec = '20'x; do while(fread(filein)=0); rc = fget(filein,rec,1); rc = fput(fileid, rec); rc =fwrite(fileid); end; rc = fclose(filein); rc = fclose(fileid); run;   2) Now I want to updated another raw data sheet in the above excel with pivot so that when user opens the excel pivot gets auto refreshed with new raw data   For this I was wondering if I can export sas dataset to this excel.     Best, Vikas ... View more

Hi Kurt, Thanks for the revert but I already tried this. This creates a save as button but I need to save the pivot in excel automatically. Also I am using pc sas 9.3 ... View more