Hi, I am running proc import with proc https to make connection to SharePoint site from sas. I am trying to import file.docs from SharePoint to SAS , I am able to import successfully docs file, but getting following ERROR: message and I think that is obvious as proc import has I guess limitation to read only xlsx/csv etc. file format. Not really .docs/.ppt etc. But since , my purpose is here to import the unsupported format like docs/ppt etc. from SharePoint to SAS, and it is happening correctly. I just need to suppress the following ERROR from the log, so that it does not create confusion to users. Could you please suggest on it, how to suppress this particular error message, not every other ERROR message. Also, I just wanted to check if there is any possibilities to import all kind of format files through proc import. filename fileout "D:Sharepoint\file.docs"; proc http url="https://graph.microsoft.com/v1.0/me/drives/&driveId./items/&fileId./content" oauth_bearer="&access_token" out = fileout; run; filename sample temp; proc import file=fileout out=sample dbms=xlsx replace; run; ERROR: Error opening XLSX file -> E:\SAS Temporary Files\_TD12345_S00ABCDF_\#LN02345. . It is either not an Excel spreadsheet or it is damaged. Error code=8014900A Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors.
... View more