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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1150 views
  • 0 likes
  • 4 in conversation