Re: st: two-way scatter conneted by id and colored by sex

[Nick Cox <njcoxstata@gmail.com>]

Thanks for the explanation.

-linkplot- (SSC) has been partially superseded by later additions to
-graph twoway-.

In any case see

Cox, N. J. 2009. Paired, parallel, or profile plots for changes,
correlations, and other comparisons. Stata Journal 9(4): 621-639

http://www.stata-journal.com/sjpdf.html?articlenum=gr0041

for detailed discussion, including of alternative graphs that often work better.

Here is some sample code.

clear
input  PatNo   sex   scan   tTbN
    690     1      1   1.28
    690     1      2   1.41
    714     1      1   1.28
    714     1      2   1.23
    735     1      1    .42
    735     1      2    .65
    762     1      1      2
    762     1      2   1.93
    792     2      1   1.78
    792     2      2   1.64
end

reshape wide tTbN, i(PatNo) j(scan)

gen one = 1
gen two = 2

twoway pcspike tTbN1 one  tTbN2 two if sex == 1, lc(red) || ///
pcspike tTbN1 one tTbN2 two if sex == 2, lc(blue) ///
legend(off) ytitle(tTbN) xla(1 2) xtitle(scan)

Nick
njcoxstata@gmail.com


On 21 November 2013 05:45, Lars Folkestad <lfolkestad@health.sdu.dk> wrote:
> Dear Nick and Sergiy
>
> Im sorry, to me (sitting and working with the data) what i wanted was obviouse. But seeing only have the Info given to you, to try to help i will elaborate:
>
>  On my X axis i would like scan.
> On my Y axis i would like tTbN.
>
> Scc i ment ssc
> Lineplot was autocorrect for linkplot
> http://www.stata.com/statalist/archive/2003-07/msg00194.html
>
> I am not sure but some patients tend to have lower values tTbN at scan 2 and some tend to have higher. I afraid that connect(direct) does not take this into account and i need the connecting lines to be from PatNo to the same PatNo to show what i said before.
>
> Hope this was the information you needed.
>
> Mvh Lars Folkestad
>
>> Den 21/11/2013 kl. 00.26 skrev "Sergiy Radyakin" <serjradyakin@gmail.com>:
>>
>> Lars, please invest some more time into formulating the question. If
>> you just want a connected scatterplot of anything, something like this
>> should satisfy all of your requirements:
>>
>> twoway scatter tTbN PatNo if sex==1 , lc(red) connect(direct) mcolor(red) || ///
>>       scatter tTbN PatNo if sex==2 , lc(blue) connect(direct) mcolor(blue)
>>
>> it is connected, it is split by sex into two colors and ordered by PatNo.
>> Whether it makes sense or not, I don't know.
>>
>> Sergiy.
>>
>>> On Wed, Nov 20, 2013 at 3:48 PM, Nick Cox <njcoxstata@gmail.com> wrote:
>>> What do you want on your y axis?
>>>
>>> What do you want on your x axis?
>>>
>>> What is "scc"?
>>>
>>> What is "lineplot"?
>>>
>>> More explanations, please?
>>>
>>> Nick
>>> njcoxstata@gmail.com
>>>
>>>
>>>> On 20 November 2013 20:26, Lars Folkestad <lfolkestad@health.sdu.dk> wrote:
>>>> Dear Listers
>>>>
>>>> Firstly sorry if this is spam, but i just got a mail saying the first one
>>>> i sent out was spam.
>>>>
>>>> I have a data set with the following structure and variables:
>>>> +---------------------------+
>>>>     | PatNo   sex   scan   tTbN |
>>>>     |---------------------------|
>>>>  1. |   690     1      1   1.28 |
>>>>  2. |   690     1      2   1.41 |
>>>>  3. |   714     1      1   1.28 |
>>>>  4. |   714     1      2   1.23 |
>>>>  5. |   735     1      1    .42 |
>>>>     |---------------------------|
>>>>  6. |   735     1      2    .65 |
>>>>  7. |   762     1      1      2 |
>>>>  8. |   762     1      2   1.93 |
>>>>  9. |   792     2      1   1.78 |
>>>> 10. |   792     2      2   1.64 |
>>>>     +---------------------------+
>>>>
>>>> I would like to graph a connected scatterplot showing in red lines if
>>>> sex=1 and blue if sex=2, and i want to connect by PatNo. I've been reading
>>>> some old FAQ's and found the scc add-on lineplot, but cannot figure out
>>>> how to get different colored lines by sex.
>>>>
>>>> Is there a more 'official' way to get what i want from these data?

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/