Help using Base SAS procedures

if var1 in (....)

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 440
Accepted Solution

if var1 in (....)


if i am  to check whether var1 has any of the values '010','011','012',....'019' besides listing  all thes values inside the brackets is there another more efficient  way(shorter way)?

I know if var1  was numeric then i could simply  have  "if var1 in (10:19)"  but would the be  the shortcut for char variables.

Anyone please?


Accepted Solutions
Solution
‎03-31-2015 04:02 PM
Respected Advisor
Posts: 3,777

Re: if var1 in (....)

Use a data step to create a proc format control data set to define an INFORMAT that returns 1 for the values in the IN list (can be anything not just 010 to 019) and 0 otherwise.

View solution in original post


All Replies
Solution
‎03-31-2015 04:02 PM
Respected Advisor
Posts: 3,777

Re: if var1 in (....)

Use a data step to create a proc format control data set to define an INFORMAT that returns 1 for the values in the IN list (can be anything not just 010 to 019) and 0 otherwise.

Super Contributor
Super Contributor
Posts: 440

Re: if var1 in (....)

thanks

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 179 views
  • 1 like
  • 2 in conversation