BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Bal23
Lapis Lazuli | Level 10

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Please mark the solution as correct on the forum.

View solution in original post

5 REPLIES 5
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Opal | Level 21

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

PG
ballardw
Super User

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
Lapis Lazuli | Level 10

Thank you, everyone. It is solved!

Reeza
Super User

Please mark the solution as correct on the forum.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2854 views
  • 0 likes
  • 5 in conversation