Because of memory issues, I'm trying to split up a table and export positions in batches.
I'm trying to use 'libname xls excel file.xlsx', but all I get is:
ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement.
What am I doing wrong?
Thanks
Check the link below. It explains about the error and how to resolve it.
/ http://blogs.sas.com/content/sasdummy/2012/05/01/64-bit-gotchas/
Changed it to
libname xlsx excel "&out_dir\test.xlsx"
which still gives the same error.
Making it
libname xlsx excel test.xlsx
Gives me
ERROR: You need to specify a data source or prompt for it.
ERROR: Error in the LIBNAME statement.
I want to use the first one, because it needs to be written to that folder.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.