BookmarkSubscribeRSS Feed
Mark_C
Calcite | Level 5
I am receiving an error "An error ocurred saving the file. Unknown" when I try to export a dataset to either MS Access or MS Excel. Any ideas?
4 REPLIES 4
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Share your SAS log information (post a reply and paste) at the point of error (and the expanded SAS code prior to the error), otherwise it will be somewhat difficult to debug with some info about your SAS program processing.

Scott Barry
SBBWorks, Inc.
Mark_C
Calcite | Level 5
Thanks. Here is the log.

File To Export:
Table04_JoinAtrbHigh

Output File Type:
Microsoft Access File (*.mdb)

Options:
Use labels for column names : True

Output File:
C:\Documents and Settings\nbkpxp4\My Documents\Table04_JoinAtrbHigh.mdb

Total Processing Time:
5.53125 seconds

Error:
Attempt 3 : Unknown
at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)
at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)
Attempt 2 : Unknown
at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)
at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)
Attempt 1 : Unknown
at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)
at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
As Doc@Duke indicated, this is a SAS tech support issue - suggest opening a SAS support track and provide them with detailed diagnostics information.

Scott Barry
SBBWorks, Inc.
Doc_Duke
Rhodochrosite | Level 12
Seems like a question for tech support.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 709 views
  • 0 likes
  • 3 in conversation