Use SAS :

2. (a) Write a SAS DATA step to read a series of variables ID, SCORE1 and SCORE2 where there are several ID, SCORE1 and SCORE2 per line. Each ID, SCORE1 and SCORE2 forms one observation. ID is a character variable; SCORE1 and SCORE2 are numeric variables. For the score variables, change the value N/A to 0 and change the value 9999 to 100. The name of the data set is Q2_A. Here are the data:

001 N/A 97 003 9999 85 002 98 9999

004 9999 86 005 60 N/A 006 100 100

008 98 9999 010 N/A N/A 009 87 98

011 85 59

.