1. Forum
  2. Usenet
  3. COMP.SOFT-SYS.STAT.SPSS

  • Inverting column in SPSS

    From T Nimof@21:1/5 to All on Mon Nov 28 06:22:04 2022
    Does anyone know how to invert a column in SPSS? I.e., given a column with elements 0.1,0.5,1.2,4.3,5.1, I would like to get a new column with elements 5.1,4.3,1.2,0.5,0.1.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rich Ulrich@21:1/5 to All on Tue Nov 29 16:59:52 2022
    On Mon, 28 Nov 2022 06:22:04 -0800 (PST), T Nimof <thiddr@gmail.com>
    wrote:

    Does anyone know how to invert a column in SPSS? I.e., given a column with elements 0.1,0.5,1.2,4.3,5.1, I would like to get a new column with elements 5.1,4.3,1.2,0.5,0.1.


    By 'column', are you referring to what you see in the data editor?

    If you have a data file that is sorted in order on one variable,
    you can use SORT (Descending) to reverse the order.

    --
    Rich Ulrich

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ki@21:1/5 to Rich Ulrich on Wed Nov 30 09:59:03 2022
    On Tuesday, November 29, 2022 at 3:59:59 PM UTC-6, Rich Ulrich wrote:
    On Mon, 28 Nov 2022 06:22:04 -0800 (PST), T Nimof <thi...@gmail.com>
    wrote:
    Does anyone know how to invert a column in SPSS? I.e., given a column with elements 0.1,0.5,1.2,4.3,5.1, I would like to get a new column with elements 5.1,4.3,1.2,0.5,0.1.
    By 'column', are you referring to what you see in the data editor?

    If you have a data file that is sorted in order on one variable,
    you can use SORT (Descending) to reverse the order.

    --
    Rich Ulrich
    If the columns are variables that you want to change from v1, v2, v3, v4, and v5 into v5, v4, v3, v2, and v1 then you could use:
    Match files /file=* /keep=v5 v4 v3 v2 v1 all.
    Ki

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)