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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

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