AI and Data Science Master the art of data science. Join now
Hello,I'm dealing with the OUTPUT MODIFY command for the first time (using SPSS 24) and I'm still at the beginning.
I have already been able to solve some of my problems myself. But now I am faced with a requirement of which I do not know whether this can be implemented at all. Maybe someone in this community can help me.
I have a frequency table with two data columns: Once the number of cases (n) and to the right the column with the corresponding percentages (%). All n-columns with a total number of cases < 50 are marked in red. In this case, however, the corresponding %-column should also be marked red. And I wonder if this is somehow possible.So is it possible to format columns based on a value in the neighboring column with OUTPUT MODIFY?
Any advice would be appreciated.Lisa
first of all thanks for your quick and detailed reply and the reference to MODIFY TABLES.
I installed the extension and tested your code. And it works in some way, but I think unfortunately it doesn't do exactly what I want. I already tried to modify it somehow but failed miserably. :D So maybe you could help me again....
Let me describe my problem a little more precisely for this.
Let's assume I have the following SPSS table:
I would now like to check the "Total number of valid cases (frequency)" (here = 50 cases).If the number is >= 50, then everything is ok and no coloring should be done - as in this example.But if the number is < 50, then the "Frequency column" should be completely colored AND the "Percent column" should be completely colored.The background is that I have to make recognizable all data in my tables which are based on a small number of cases .
To summarize again, this means that I only check one value in a cell and then based on that cell I want to color the column itself and the neighboring column. Is this somehow possible?