topic Re: Error exporting to SAS using task scheduler? in SAS Programming

Error exporting to SAS using task scheduler?

SAS93 — Tue, 20 Apr 2021 14:25:38 GMT

I'm trying to export a SAS dataset as an Excel file; this process is scheduled using Task Scheduler.

Occasionally, I'll get the following error, and the file will either not export or not finish exporting--ending up in a corrupt file. Running the code manually doesn't appear to have this issue.

WARNING: During insert: : Data value was not sent for column. Coll_Dt
WARNING: During insert: : Data value was not sent for column. Coll_Dt
WARNING: The data set _IMEX_.Collected_DATE may be incomplete. When this step was
stopped there were 788585 observations and 16 variables.
ERROR: ROLLBACK issued due to errors for data set _IMEX_.Collected_DATE.
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 15:35.08
cpu time 14:05.43

Someone I work with suggested it's because a data variable in the original dataset might contain a date before 01/01/1900, but when I went through the dataset, I didn't find anything earlier than January 2021.

Any ideas or guidance to solve this would be helpful.

Re: Error exporting to SAS using task scheduler?

ChrisNZ — Tue, 20 Apr 2021 22:50:17 GMT

This definitely looks like a data issue.

The odd part is that the issue does not arise when running the program manually.

Can it be reliably be repeated if the batch program is run several time?

Does all the data look OK when the import is manual?

If I were you, I'd try to find which data causes that issue.

Several ways to do this: by growing the number of lines read until the suspicious data triggers the error, or by running a thorough cell validation in Excel.

Re: Error exporting to SAS using task scheduler?

ChrisNZ — Tue, 20 Apr 2021 22:51:45 GMT

> When this step was stopped there were 788585 observations and 16 variables.

That's a starting point. Focus your investigation there. What's different?