substract, input, etc

[Bal23]

My code is below:

if upcase(substr (variablea,1,1)) in ('O''P') then delete;
 variableb = input(substr(variable,1,3), 8.);

Check the data it generates, i still see "O" exist and that is why for the second statement, it generates missing data.

"NOTE: Invalid argument to function INPUT at line 581 column 17"

would anybody give advice how to fix the problem? what is wrong with my code?

Thanks

[RW9]

You have a typo in your code:

if upcase(substr(variablea,1,1)) in ('O','P') then delete;
variableb=input(substr(variable,1,3), 8.);

Note the comma separating the elements in the in() list.

[PGStats]

You need a comma between the apostrophes 'O''P' -> 'O','P' . The way it reads now is upcase(substr (variablea,1,1)) should be equal to O'P

[ballardw]

IN operator requires either a comma or a blank space between elements to compare. With neither the two quotes in the middle are treated as a single quote.

Since the records with O or P values in the first column were not deleted then you have the input function trying to read something like P12 as numeric and failing.

[Bal23]

Thank you, everyone. It is solved!

[Reeza · Accepted solution]

Please mark the solution as correct on the forum.