SPSS Statistics

 View Only
  • 1.  RANGE function with dates

    Posted Fri October 22, 2021 03:29 PM

    I am looking for documentation of syntax that uses the RANGE function to determine if a variable containing a date falls between two other variables containing dates.  All 3 variables are in date format ADATE10.  (I am not working with time series data.)  For example,

    RPTDATE = 03/02/2018  (test value)

    INT1DATE = 11/02/2018

    INT2DATE = 03/21/2019

     

    Thank you.

     

    Miriam

     

     

    -----------------------------------------------------------------------------------------------------------------
    CONFIDENTIALITY NOTICE: The documents accompanying this email may contain confidential information, which is legally privileged. This information is intended only for the use of the recipient named above. If you are not the addressee or the employee or agent of the intended recipient, you are hereby notified that you are strictly prohibited from printing, storing, disseminating, distributing, or copying this communication. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
    -----------------------------------------------------------------------------------------------------------------

    #SPSSStatistics


  • 2.  RE: RANGE function with dates

    IBM Champion
    Posted Fri October 22, 2021 03:37 PM
    under CROSSTABS.  You will see that there are two different formulas used.

    --





  • 3.  RE: RANGE function with dates

    IBM Champion
    Posted Fri October 22, 2021 03:39 PM
    Use the yrmoda function to write the dates to the range function
    e.g., yrmoda(2018, 11, 02)

    --