update sepcific observation in a dataset

[BrahmanandaRao]

data march;
input id name$ score;
datalines;
1 aaa 55
2 bbb 77
3 ccc 22
4 ddd  p
5 eee  4
6 ff   k
;
run;

/* update values above datasets */

data march;
modify march;
if score=p then score=98;
run;

hi i want to update value of score where score= p then i want change 98  but above update where character value i want only required value to change

[Kurt_Bremser]

Your first DATA step needs fixing. Do that first.

[Kurt_Bremser]

And your second data step will only work if there is a variable named p in your dataset.

[Astounding]

To get your first DATA step to work, add a MISSING statement:

data march;
missing p k;
input id name$ score;
datalines;
use the same data you are using now
;

This lets you store p and k as numeric values without needing to change anything to 98. In fact, changing them to 98 would cause problems later. For example, when you calculate the average score, values of 98 would affect the average.

[PaigeMiller]

This is obviously a made up problem, but changing an invalid value, like the letter P, to a valid value, is a very poor practice. Better you should leave the P as missing, SAS does the correct things when it encounters a missing value. SAS will probably not do the correct things when it finds a 98.