Hi I need to export a dataset to create a new excel spreadsheet (not a csv and not DDE into an existing excel spreadsheet). · When trying to do so I get the following error “ERROR: DBMS type EXCELCS not valid for export.” (DBMS = EXCELCS is for connecting remotely), so it looks like I don’t hold the correct SAS/access interfacing licence? · Am I missing something here or is it just not possible to do with our current packages, which are SAS® Analytics Pro (which includes Base SAS, SAS/STAT and SAS/GRAPH) SAS® Access Interface to ODBC – which allow you to access any ODBC compliant Data Source provided that you have the right drivers installed My code is: proc export data = dat_expo outfile="dat_out.xls" dbms=EXCEL /* I've also tried EXCELCS */ replace; run; Thanks, Jude
... View more