topic Re: How to plot by ID by VISIT across age in Graphics Programming

How to plot by ID by VISIT across age

Melk — Thu, 11 Jan 2018 18:17:56 GMT

I would like to create a graph with age as my x axis and subject ID as my Y axis, grouped by treatment group. I want the markers to represent the subject visit at each age and a line to connect across to all visits, only by ID. How can I do this?

Sample data set:

ID VISIT AGE Y TX

1 1 40 200.4 A

1 2 43 144.4 A

1 3 45 106.3 A

2 1 36 120.6 B

2 2 39 106.8 B

2 3 41 101.1 B

Re: How to plot by ID by VISIT across age

Reeza — Thu, 11 Jan 2018 01:16:39 GMT

Are you sure about this portion?

subject ID as my Y axis

And which variable corresponds to 'treatment group'?

@Melk wrote:

grouped by treatment group.

A sketch of what you're looking for would be helpful. This should be relatively easy within a SGPLOT, with a SERIES statement and the MARKERS option to have points that are connected via a line.

And what is the Y supposed to represent, or is it extraneous information?

@Melk wrote:

I would like to create a graph with age as my x axis and subject ID as my Y axis, grouped by treatment group. I want the markers to represent the subject visit at each age and a line to connect across to all visits, only by ID. How can I do this?

Sample data set:

ID        VISIT         AGE           Y

1            1               40             200.4

1            2               43             144.4

1            3               45             106.3

2            1               36             120.6

2            2               39             106.8

2            3               41             101.1

Re: How to plot by ID by VISIT across age

Melk — Thu, 11 Jan 2018 18:18:11 GMT

Added, just A or B

Re: How to plot by ID by VISIT across age

Reeza — Thu, 11 Jan 2018 18:26:14 GMT

Have you tried SGPLOT yet? If so, please post what you've attempted thus far.

Re: How to plot by ID by VISIT across age

GraphGuy — Mon, 15 Jan 2018 13:54:23 GMT

Here's some code to do what I *think* you're looking for (or at least, maybe it will get you started)...

data foo;
length tx $1;
input ID VISIT AGE Y TX;
datalines;
1 1 40 200.4 A
1 2 43 144.4 A
1 3 45 106.3 A
2 1 36 120.6 B
2 2 39 106.8 B
2 3 41 101.1 B
;
run;

proc sort data=foo out=foo;
by id age;
run;

goptions xpixels=500 ypixels=400 htitle=12pt htext=10pt ctext=gray33;
symbol1 value=dot height=8pt interpol=join color=blue pointlabel=(height=8pt color=gray55 "#y");
axis1 label=('Measurement') order=(0 to 250 by 50) minor=none offset=(0,0);
axis2 label=('Age') order=(30 to 50 by 5) minor=none offset=(0,0);

options nobyline;
title1 "Graph for patient " c=blue "#byval(id)";
footnote;
proc gplot data=foo;
by id;
plot y*age=1 /
vaxis=axis1 haxis=axis2
autovref cvref=graydd autohref chref=graydd;
run;