topic Re: Defining a range w/ the IN statement in SAS Programming

Defining a range w/ the IN statement

_maldini_ — Wed, 29 Jun 2022 23:04:46 GMT

Can you define a range using the IN statement? Documentation says "yes", but my syntax says "no".

  where RXDDCI1A in (40,358);
  where same and RXDDCI1B in (41-56,303,340,342,430,433,482,483,19);

The above syntax selects 1 observation where RXDDCI1B=41 and then picks back up when RXDDCI1B=303. It works as desired when I remove the range (i.e., 41, 42, 43, 44, etc.).

Thanks.

Re: Defining a range w/ the IN statement

ballardw — Wed, 29 Jun 2022 23:38:14 GMT

Documentation says that the integer sequence is indicated by a full colon

where same and RXDDCI1B in (41:56,303,340,342,430,433,482,483,19);

I say sequence because that is what that would be 41, 42 etc. A range would be anything between 41 and 56, such as 41.345678 but IN really want to use a finite list of values.

Re: Defining a range w/ the IN statement

Cynthia_sas — Thu, 30 Jun 2022 00:07:23 GMT

@ballardw is correct, you need the colon : to indicate a range. The SAS log notes reveal the issue with trying - for the range indicator, as shown in the simplified example below:

Cynthia