I've been regularly able to export a SAS dataset into an Access database located on our local network from SAS Viya using PC file server. However, now I'm getting the following error messages when I export the usual SAS dataset (MYDATA):
"ERROR: CLI disconnect failed: Server communication failure."
"ERROR: Error in the LIBNAME statement."
The strange thing is I can successfully export sashelp.class into the same Access database without error. Originally I thought the issue was that I converted string into numeric and it wasn't able to overwrite the Access table with different data types for the same column names but I compared the proc contents from the exported dataset to the imported dataset and variable types aligned. Also, I'm not able to export MYDATA into a new table (i.e., no overwrite) in the Access database like I was able to do with sashelp.class. Meaning the issue appears to have something to do with MYDATA. The only change to MYDATA from working to not working was new records and some new values in existing records, but I'm not sure how to investigate the problem here. Any ideas?
... View more