Conditional formatting

[88videos]

Hi,

I have a few problems related to formatting.

First issue first. Later I will describe other problems.

Let' s say that my dataset looks like this.

data list list
/id(f8.0) text(A15) condition (f8.0).
begin data.
1 I 1
2 spend 1
3 the 2
4 day 1
5 in 3
6 bed 2
end data.
EXECUTE.
dataset name b1.


I want to find a way to format variable 'text':
If condition=1 (font should be: times new roman in cursive, size 8)
If condition=2 (font should be: times new roman in bold, size 8)
If condition=3 (font should be: calibri, size 10)

I assume that this can't be done in dataset, but formatting options in
OUTPUT are more flexible. I guess that this way this can be done. Am I
right?

At the end I need to have .docx or .xlsx file formatted as I described with
only 2 variable: id, text.

I guess that MODIFY TABLES or OUTPUT MODIFY might be helpful. But I have no
experience of using this extensions.

Thanks for any clues in advance.





--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon Peck]

These commands can handle this, but the code would be specific to the pivot table type.  Please post an example of the table you want to format.

On Thu, Dec 14, 2017 at 3:56 AM, 88videos <[hidden email]> wrote:

Hi,

I have a few problems related to formatting.

First issue first. Later I will describe other problems.

Let' s say that my dataset looks like this.

data list list
/id(f8.0) text(A15) condition (f8.0).
begin data.
1 I 1
2 spend 1
3 the 2
4 day 1
5 in 3
6 bed 2
end data.
EXECUTE.
dataset name b1.


I want to find a way to format variable 'text':
If condition=1 (font should be: times new roman in cursive, size 8)
If condition=2 (font should be: times new roman in bold, size 8)
If condition=3 (font should be: calibri, size 10)

I assume that this can't be done in dataset, but formatting options in
OUTPUT are more flexible. I guess that this way this can be done. Am I
right?

At the end I need to have .docx or .xlsx file formatted as I described with
only 2 variable: id, text.

I guess that MODIFY TABLES or OUTPUT MODIFY might be helpful. But I have no
experience of using this extensions.

Thanks for any clues in advance.





--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

--

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Rick Oliver]

For Output Modify, you might want to start with the UI to build some basic syntax and then make adjustments.

https://www.ibm.com/support/knowledgecenter/SSLVMB_24.0.0/spss/base/modify_output.html

On Thu, Dec 14, 2017 at 4:56 AM, 88videos <[hidden email]> wrote:

Hi,

I have a few problems related to formatting.

First issue first. Later I will describe other problems.

Let' s say that my dataset looks like this.

data list list
/id(f8.0) text(A15) condition (f8.0).
begin data.
1 I 1
2 spend 1
3 the 2
4 day 1
5 in 3
6 bed 2
end data.
EXECUTE.
dataset name b1.


I want to find a way to format variable 'text':
If condition=1 (font should be: times new roman in cursive, size 8)
If condition=2 (font should be: times new roman in bold, size 8)
If condition=3 (font should be: calibri, size 10)

I assume that this can't be done in dataset, but formatting options in
OUTPUT are more flexible. I guess that this way this can be done. Am I
right?

At the end I need to have .docx or .xlsx file formatted as I described with
only 2 variable: id, text.

I guess that MODIFY TABLES or OUTPUT MODIFY might be helpful. But I have no
experience of using this extensions.

Thanks for any clues in advance.





--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[88videos]

I do not have access to real dataset yet, I will have in a few days. But I
was informed about transformations, which need to be done (casetovars etc.)
with this data and based on this information I predict/guess :) that in
result I will have dataset similar to this example (3 columns).
And this dataset is my table, which need to be format.   Real dataset will
consists of approximately 4000 rows.


PS I know how to do this manually in excel (filter data by every condition (one by one) and format cells). But I wonder whether more reproducible solution is possible in SPSS.
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[e-mail] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon Peck]

Pivot tables are not really intended to handle such large numbers of rows, but I tried using SUMMARIZE to list the cases as a pivot table for 5000 cases, and that worked well.

SUMMARIZE 

  /TABLES=id text condition

  /FORMAT=LIST NOCASENUM TOTAL LIMIT=5000 

  /TITLE='Case Summaries' 

  /MISSING=VARIABLE 

  /CELLS=NONE.

For styling, you can right click on the table and choose Style Output, but the dialogs do not give you access to all the properties and conditions you want to modify.  The syntax below is able to do this except that the SELECTCONDITION is applied to all the variables, not just the condition variable.  If the values do not overlap, it would work, but the ID variable might cause a problem for the first few cases if it counts from 1.

OUTPUT MODIFY NAME=Document1

  /REPORT PRINTREPORT=NO

  /SELECT TABLES 

  /IF COMMANDS=["Summarize(1)"] LABELS=[EXACT("Case Summaries")] INSTANCES=[1]

  /TABLECELLS SELECT=[BODY] SELECTCONDITION="x=1.0" STYLE= ITALIC  APPLYTO=ROWDATA FONT="times new roman" FONTSIZE=8

  /TABLECELLS SELECT=[BODY] SELECTCONDITION="x=2.0" STYLE= BOLD  APPLYTO=ROWDATA FONT="times new roman" FONTSIZE=8

  /TABLECELLS SELECT=[BODY] SELECTCONDITION="x=3.0" APPLYTO=ROWDATA FONT="calibri" FONTSIZE=10.

The SPSSINC MODIFY TABLES extension command, which was the model on which OUTPUT MODIFY was based, can do all this, but it would require a small plug-in custom function.  I can provide that if necessary.

On Thu, Dec 14, 2017 at 8:43 AM, 88videos <[hidden email]> wrote:

I do not have access to real dataset yet, I will have in a few days. But I
was informed about transformations, which need to be done (casetovars etc.)
with this data and based on this information I predict/guess :) that in
result I will have dataset similar to this example (3 columns).
And this dataset is my table, which need to be format.   Real dataset will
consists of approximately 4000 rows.

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

--

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[David Marso]

"manually in excel "?
PLEASE be serious.  Have you looked into VBA?
I don't see how such a result has any practical utility.
---


88videos wrote
> I do not have access to real dataset yet, I will have in a few days. But I
> was informed about transformations, which need to be done (casetovars
> etc.)
> with this data and based on this information I predict/guess :) that in
> result I will have dataset similar to this example (3 columns).
*
> And this dataset is my table, which need to be format
*

> .   Real dataset will
> consists of approximately 4000 rows.
>
>
> PS I know how to do this manually in excel (filter data by every condition
> (one by one) and format cells). But I wonder whether more reproducible
> solution is possible in SPSS.
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[88videos]

I can assure You, that this is very practical task.

I am basic vba user, I do manually things first and then try to modify it.

Asking how to do something in SPSS is not a crime :) , even if some other
tools are more suitable to solve specific problem.

Thanks for all answers, my biggest thanks goes to Jon for detailed
explanation.



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD