Hello Finally I ran code of poor/rich. Here is what I did. reference macro was used from http://www.sascommunity.org/mwiki/images/f/f4/1793-2014.sas 1) I ran program from EG I got "undermined I/O faliure. 2) I tried from Base SAS and got no error. searched log there is no "error" word in whole log. But I can not see my file in the my computer. I have SAS on my PC not on server. Below is the code and log I submitted. Clearly it says whole program is fine but I can not see the output file My code best on poor/rich macro: %exportxl( data=sashelp.cars , outfile=C:\Users\myname\Desktop\test.xlsx, type=N, usenames=Y, sheet = test); My log: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 1 observations read from the data set SASHELP.CARS. NOTE: The data set WORK.T_E_M_P has 1 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 1 observations read from the data set WORK.T_E_M_P. NOTE: The data set WORK.T_E_M_P has 1 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The file CODE2INC is: Filename=C:\Users\myname\AppData\Local\Temp\SAS Temporary Files\_TD5640_ISC83676_\#LN00032, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=26Jun2015:14:37:39, Create Time=26Jun2015:14:37:39 NOTE: 30 records were written to the file CODE2INC. The minimum record length was 15. The maximum record length was 55. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 428 observations read from the data set SASHELP.CARS. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: The file DUMMY1 is: Filename=C:\Users\myname\AppData\Local\Temp\SAS Temporary Files\_TD5640_ISC83676_\PasteIt.vbs, RECFM=V,LRECL=512,File Size (bytes)=0, Last Modified=26Jun2015:14:37:39, Create Time=26Jun2015:14:37:39 NOTE: 23 records were written to the file DUMMY1. The minimum record length was 5. The maximum record length was 70. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: DATA statement used (Total process time): real time 0.28 seconds cpu time 0.04 seconds Everything looks right still I am not able to see my written file. Am I missing anything? Thank you for your time.
... View more
