topic substract, input, etc in SAS Programming

substract, input, etc

Bal23 — Wed, 13 Jan 2016 17:49:05 GMT

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

Re: substract, input, etc

RW9 — Wed, 13 Jan 2016 17:57:53 GMT

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.

Re: substract, input, etc

PGStats — Wed, 13 Jan 2016 18:02:10 GMT

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

Re: substract, input, etc

ballardw — Wed, 13 Jan 2016 18:10:02 GMT

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.

Re: substract, input, etc

Bal23 — Wed, 13 Jan 2016 18:16:31 GMT

Thank you, everyone. It is solved!

Re: substract, input, etc

Reeza — Wed, 13 Jan 2016 18:45:31 GMT

Please mark the solution as correct on the forum.