BookmarkSubscribeRSS Feed
olabuh
Calcite | Level 5
I got this error code when I tried merging data in sas
window error code :23 in hc_disc_normal. Any solution ?
4 REPLIES 4
olabuh
Calcite | Level 5
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.
Shmuel
Garnet | Level 18

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.

SASKiwi
PROC Star

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1226 views
  • 0 likes
  • 4 in conversation