The SAS Output Delivery System and reporting techniques

Append to Excel sheet

Reply
Contributor
Posts: 28

Append to Excel sheet

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

 

 

 

New Contributor
Posts: 2

Re: Append to Excel sheet

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/ 

 

Contributor
Posts: 28

Re: Append to Excel sheet

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.

Ask a Question
Discussion stats
  • 2 replies
  • 323 views
  • 0 likes
  • 2 in conversation