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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.