Yes, I used c:\temp\class.xlsx, I had no results, no file created, so I tried to write my outfile in « \\laxxxx.com... », I have the same: no results, no file created. Thank you for your help
... View more
Thank you Art, I run: %exportxl(data=sashelp.class, outfile=c:\temp\class.xlsx,usenames=N, sheet=Students, usenotepad=Y) Unfortunately I have no results (no file), but I don't have the errors in the log.
... View more
Hello Experts, Do you know please some method to export the data to the particular range of Excel file? The proc export doesn’t work with range statement. 😞 I would like to export the data and then to recalculate it with the Excel formulas. Thank you very much!
... View more
Hello Experts, Do you know please if there is the opposite of LAG function? I need to create a new column with the next value in my column. Thank you very much!
... View more
Hello Kurt, This code is working: options validvarname=any; libname xl XLSX "\\XXX\TousIsin.xlsm"; data isin; set xl.'VALEURS$B2:50'n; run; BUT when I replace B2:50 by range NAME: data isin; set xl.'VALEURS$test'n; run; My code doesn'y work. 😞
... View more
Thank you, It doesn't work: ERROR: Connect: Classe non enregistrée ERROR: Error in the LIBNAME statement. I would like to import the range from xlsm file.
... View more
