ERROR: The value 'LÅN_GARANTI'n is not a valid SAS name.
I am running 9.1.3. I assume that it is because of the special character in the original dataset name. Is there a way to circumvent this or is it not possible to use PROC COPY with special characters? I googled the web for explanations but didn't come across any.
It is hard to tell, but it looks like the A in LAN is not the standard English A. This would require VALIDVARNAME to be set to ANY. You may also need to write the SELECT statement as:
where you use the A that is not on my keyboard.
you need to change the name of the table if you want to copy it into the WORK library. Although SAS/Access to a dbms supports complex names like your table, that flexibility is not present in the support of table names in the (base SAS) WORK library.
You might have more success with a simple data step, like[pre]DATA work.loan_garanti ;
set ntsqlpro."LÅN_GARANTI"n ;