File Import Error - SAS Enterprise Miner 14.1

[Sheron]

Hi,

Our IT department recently upgraded us to Office 365 and I am now trying to import a csv file on to SAS Enterprise Miner using 'FILE IMPORT' NODE.

I can preview the file there but when I press ok, it  just gives mea Error msg box saying

"An error occurred during the execution of this code"

I get no other clue as to why this is happening.

Can someone please help.

MAny thanks

SHeron

[ballardw]

Can you open the file in some other application like Notepad? Does it look like CSV with that application?

[Sheron]

Hi,

Thanks yes it does. I have opened it in notepad++ and excel. The thing is that on SAS file import, I can preview it perfectly fine. It just that when I press okay to proceed this errors comes.

Thanks 

Sheron

[WendyCzika]

There might be more information in the node log.  Right-click on the File Import node, select Results.  From the Results window, select View > SAS Results > Log, then search for "ERROR:".  If that doesn't offer any additional information about why it's failing, you might need to contact SAS Technical Support: https://support.sas.com/techsup/contact/.

[Sheron · Accepted solution]

Thanks Wendy.

I just checked and this only happens to the files that are saved on "Microsoft One Drive for Business". Where my source file and my SAS library both stored in the One drive for business.

Has SAS known any issues working on 'Microsoft One Drive for Business" using SAS Enterprise Miner Desktop version.

Many thanks

Sheron