topic Re: Error code when trying to merge years in SAS Programming

Error code when trying to merge years

olabuh — Sun, 02 Jun 2019 16:05:58 GMT

I got this error code when I tried merging data in sas
window error code :23 in hc_disc_normal. Any solution ?

Re: Error code when trying to merge years

Kurt_Bremser — Sun, 02 Jun 2019 16:17:44 GMT

Please post the whole log of the data step. Use the {i} button for posting logs, please.

Re: Error code when trying to merge years

olabuh — Sun, 02 Jun 2019 17:45:16 GMT

data combined;
1844 set new10 new11 new12 new13 new14;
1845 run;

WARNING: Multiple lengths were specified for the variable NIS_STRATUM by input data
set(s). This can cause truncation of data.
ERROR: Windows error code: 23 in hc_disk_normal_read for
C:\Users\Olajide\AppData\Local\Temp\SAS Temporary
Files\_TD65924_WINDOWS-329L0KE_\new11.sas7bdat, Data error (cyclic redundancy
check).
ERROR: File WORK.NEW11.DATA is damaged. I/O processing did not complete.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 7800441 observations read from the data set WORK.NEW10.
NOTE: There were 1959251 observations read from the data set WORK.NEW11.
WARNING: The data set WORK.COMBINED may be incomplete. When this step was stopped
there were 9759692 observations and 233 variables.
WARNING: Data set WORK.COMBINED was not replaced because this step was stopped.

Re: Error code when trying to merge years

Shmuel — Sun, 02 Jun 2019 18:39:41 GMT

Pay attention to the two marked RED lines in log:

====================================

data combined;
1844 set new10 new11 new12 new13 new14;
1845 run;

WARNING: Multiple lengths were specified for the variable NIS_STRATUM by input data
set(s). This can cause truncation of data.
ERROR: Windows error code: 23 in hc_disk_normal_read for
C:\Users\Olajide\AppData\Local\Temp\SAS Temporary
Files\_TD65924_WINDOWS-329L0KE_\new11.sas7bdat, Data error (cyclic redundancy
check).
ERROR: File WORK.NEW11.DATA is damaged. I/O processing did not complete.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 7800441 observations read from the data set WORK.NEW10.
NOTE: There were 1959251 observations read from the data set WORK.NEW11.
WARNING: The data set WORK.COMBINED may be incomplete. When this step was stopped
there were 9759692 observations and 233 variables.
WARNING: Data set WORK.COMBINED was not replaced because this step was stopped.

====================================

Check why is variable NIS_STRATUM defined in part of inputs as numeric while in the other is character type ?

It may be caused because of the 2nd red line: check why is WORK.NEW11 damaged ? as it is a temporary data

maybe you run your code twice or override it ?

If you fix those two issues, your code may work without syntax errors.

Finally check the output does it fit your expectations.

Re: Error code when trying to merge years

SASKiwi — Sun, 02 Jun 2019 19:29:55 GMT

Sounds like you have a problem with Windows on your PC: http://www.wiki-errors.com/err.php?wiki=23