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.
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.
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.
@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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.