SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 


#Analytics
#SPSSStatistics
#Analyticstools
 View Only

  • 1.  Mark/color specific columns or fields

    Posted 03/10/23 02:34 PM

    Is there a way to mark or color a specific column so I can easily spot it in between the huge amount of data? I can't find any option for this.



    ------------------------------
    Renee Damstra
    ------------------------------


  • 2.  RE: Mark/color specific columns or fields

    Posted 03/10/23 02:49 PM

    Hi. See the OUTPUT MODIFY command.

    Note - OUTPUT MODIFY has a lot of options, it can do a lot of things; it can get confusing. Just start at the basic description, look at the SELECT subcommand and probably the TABLECELLS subcommand.



    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 3.  RE: Mark/color specific columns or fields

    Posted 03/10/23 03:07 PM

    Here's an example to get you started.

    ** Make data.
data list free /x y group.
begin data.
1 3 0
4 8 0
4 7 0
3 2 1
5 7 1
3 1 1
end data.

*Run MEANS.
MEANS TABLES x BY group.

*Change column to yellow.
OUTPUT MODIFY
  /SELECT TABLES /IF SUBTYPES=["Report"]
  /TABLECELLS SELECT=[BODY] SELECTCONDITION=ALL BACKGROUNDCOLOR=YELLOW APPLYTO=COLUMN.


    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------

    Original Message


  • 4.  RE: Mark/color specific columns or fields

    Posted 03/10/23 03:17 PM

    Thanks Rick, I am not so good at syntax yet, could you give me an example for instance if I have a column named 'mood_lonely' how could I use the output command to make this colum have a yellow background? 



    ------------------------------
    Renee Damstra
    ------------------------------

    Original Message


  • 5.  RE: Mark/color specific columns or fields

    Posted 03/10/23 03:24 PM 
    output close all.
dataset close all.
data list free /mood_lonely mood_happy group.
begin data.
1 3 0
4 8 0
4 7 0
3 2 1
5 7 1
3 1 1
end data.

MEANS TABLES mood_lonely mood_happy BY group.

OUTPUT MODIFY
  /SELECT TABLES
  /IF SUBTYPES=["Report"]
  /TABLECELLS SELECT=["mood_lonely"]
   SELECTCONDITION=ALL
   BACKGROUNDCOLOR=YELLOW
   APPLYTO=COLUMN.


    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------

    Original Message


  • 6.  RE: Mark/color specific columns or fields

    Posted 03/13/23 05:55 AM

    Ok thanks but it is not a table, it is just the workspace. My boyfriend says there is no option to mark/color the workspace?



    ------------------------------
    Renee Damstra
    ------------------------------

    Original Message


  • 7.  RE: Mark/color specific columns or fields

    Posted 03/13/23 06:32 AM
    For all I know, your boyfriend is right.




    Original Message


Related Content