topic Re: Ranges in custom format in SAS Programming

Ranges in custom format

mintbit — Tue, 19 May 2020 06:52:09 GMT

Can someone please explain this a little further? Is there a greater than symbol in a?

Which of the following does not have proper syntax for specifying a range in the VALUE statement?

 a.  500>-700

 b.  500-<700

 c.  'A'-'C'

 d.  'Horse'-'Mouse'

Your answer: b
Correct answer: a

The greater than symbol is not valid for a range. The less than symbol can be used after the starting value or before the ending value.

Re: Ranges in custom format

ed_sas_member — Tue, 19 May 2020 07:30:57 GMT

Hi @mintbit

By default, a simple hyphen (-) means that boundaries are included.

To exclude them, you can use the inferior sign: <

500>-700 is not a proper syntax
500-700 is equivalent to [500;700]
500-<700 is equivalent to [500;700[
500<-700 is equivalent to ]500;700]
500<-<700 is equivalent to ]500;700[

Best,

Re: Ranges in custom format

Kurt_Bremser — Tue, 19 May 2020 10:34:56 GMT

This:

is a "greater than" symbol.

Re: Ranges in custom format

mintbit — Tue, 19 May 2020 11:31:21 GMT

Thank you for the reply. It is much clearer now. My question seems so stupid now that I understand the answer 😅