Thanks Patrick. What SAS version are you on? - SAS 9.3 (32) Note: OS - 64-bit proc import/export using path .xlxs works for me, but the codes above got an error: class not registered. I've run SASKiwi codes: proc setinit noalias; run; Log shows the expiration date of the SAS Sytems (that maybe installed in my computer). Is the PC File Server running? - I don't know if this is running.
... View more
@SASKiwi wrote: Try EXCEL as the engine name rather than XLSX. I'm pretty sure XLSX is only possible with SAS 9.4 M2 or later. There are a few other things that may cause this error, but let's just try one thing at a time. Still, got the same error.
... View more
@Patrick wrote: You need to get your libname statement correct by adding the XLSX engine (SAS/Access to PC files needs to be licensed for this to work). Also: The macro parameter in your code is YEAR not YR. You should use this one within the macro. %let year=2015; %let month=10; libname s xlsx "E:\data\datamonthly_&year._&month..xls"; SAS/Access to PC files has licensed but I got the same error.
... View more
Please help me with this error. %include "E:\program\monthly.sas"; %let sum=E:\data\datamonthly_&yr._&month..xls; %data(&yr,&month,&sum); where monthly.sas: %macro data(year,month,lib); libname s "&lib"; %mend data;
... View more