When using Base SAS, PROC EXPORT does not recognize case sensitive tablenames and might return an error.

If you use PROC EXPORT to write a case-sensitive database tablename to a delimited text file, use the name literal (n-literal) to specify that dbms tablename. For example, assign a library to a database (such as Sybase) that maintains case sensitivity of tablenames. Then use PROC EXPORT to write a Sybase table to a csv file.

If the Sybase tablename is not specified using the n-literal, the following error will be returned:

libname mylib odbc dsn=Sybasedsn user=syb_user password=syb_pwd;

proc export data=mylib.table_name
OUTFILE="C:\My Documents\table_name.csv"
dbms=csv replace;
run;

"ERROR: File MYLIB.TABLE_NAME.DATA does not exist."

To avoid this error you should use the following syntax:

proc export data=mylib.'table_name'n
OUTFILE="C:\My Documents\My SAS Files\9.1\flatfiles\table_name.csv"
dbms=csv replace;
run;

Operating System and Release Information