topic Re: Scatter plot matrix with 3 variables in Graphics Programming

Scatter plot matrix with 3 variables

nash_sas — Thu, 20 Feb 2014 17:17:53 GMT

Time	700	900	1100
Time1	10	11	21
Time2	20	12	22
Time3	30	13	23
Time4	40	14	24

I am trying to do a scatter plot with 'Time on x-axis' and 700, 900, 1100 values (above table has them as variable names) on y axis and corresponding values 10,20,30,40,11,12,13,14,........as poin for that particular Time and y-axis value.

In other terms, I am trying to see a point corresponding to all 3 variables. For below example, there would be only two points : one with age-14 height- 69 weight - 112.5; other point for age -13 height - 56.5 weight -84. I am not looking for a 3 dimensional but there can be a vertical right axis.

Age

Height

Weight

112.5

56.5

I tried below code and it's plotting two plot separately one with height*age; other with weight*age. Can it be possible to have plot with height*weight*age ? Thanks

PROC GPLOT DATA = sashelp.class;

PLOT Height * Age / GRID

VAXIS=AXIS1

HAXIS=AXIS2

FRAME SKIPMISS LEGEND=LEGEND1 ;

PLOT2 Weight * Age = 2 / VAXIS=AXIS3

SKIPMISS OVERLAY LEGEND=LEGEND1 ;

Re: Scatter plot matrix with 3 variables

PGStats — Thu, 20 Feb 2014 18:28:24 GMT

Do you want something like this?

data have;

input Time $ t700 t900 t1100;

datalines;

Time1 10 11 21

Time2 20 12 22

Time3 30 13 23

Time4 40 14 24

;

proc sgplot data=have;

scatter x=time y=t700;

scatter x=time y=t900;

scatter x=time y=t1100;

yaxis label="Whatever";

run;

Re: Scatter plot matrix with 3 variables

nash_sas — Thu, 20 Feb 2014 18:49:03 GMT

I would need to plot 700, 900, 1100 on the y-axis (or any other axis with a scale); I am looking for something like a spectral plot / Matrix plot. As we see the below example plot, frequency on x- axis, m2/hz on y-axis. period on other axis (not sure if we can call that as z- axis). Thanks

Re: Scatter plot matrix with 3 variables

ballardw — Thu, 20 Feb 2014 22:25:07 GMT

This looks like you may be looking for Proc SGPLOT as PGStats suggests but add an X2axis for the time part as well as an X axis for the frequency.

Re: Scatter plot matrix with 3 variables

PGStats — Thu, 20 Feb 2014 22:53:32 GMT

I can't imagine how to create two X or Y axes related to the same curve, such as on your Specral Density example. Especially if one scale is linear and the other isn't. - PG

Re: Scatter plot matrix with 3 variables

Jay54 — Thu, 20 Feb 2014 23:07:16 GMT

I am taking a stab here and may be totally off the mark here...

I suppose you may (Fourier) transform a time domain signal to the frequency domain. However, I don't know if the shape of the response stays the same. However, you could plot the original (signal by time) on (y, x) axis, and then also plot (TransSignal by freq) on (y, x2). Axis type can be linear or log (2, 10 or e). Now, you could make the 2nd plot invisible by making the line thickness zero or transparency=1. This will certainly give you "some kind of" plot. You may need to set axis options for offsets, thresholds etc to ensure the axes are synchronized.

Re: Scatter plot matrix with 3 variables

nash_sas — Fri, 21 Feb 2014 00:12:23 GMT

Sanjay,

I am trying to imagine what you suggested here but not sure how to code this. As I've got about 1000 signal points for one timeperiod (signal vs time) and 3000 signal points for one frequency (signal vs frequency). Would you be able to explain this with some code. Thanks

Timeperiod	100	101	102	103	104	105
1/2/2010 11:00	10	20	30	40	50	60
1/2/2010 13:30	20	30	40	50	60	70
1/2/2010 16:00	40	60	60	60	60	60
1/2/2010 18:30	60	50	50	40	40	30

Re: Scatter plot matrix with 3 variables

Jay54 — Fri, 21 Feb 2014 01:04:30 GMT

Can you attach sample data set (reduced) so I can try it out? Tell me which variables to plot.

Re: Scatter plot matrix with 3 variables

nash_sas — Fri, 21 Feb 2014 01:25:13 GMT

Sanjay,

Would this help for you to try ? Frequency variables here are 100 to 105 and 10,20,40,.....70,60,30.are signals at various time periods and frequencies.

Timeperiod	100	101	102	103	104	105
1/2/2010 11:00	10	20	30	40	50	60
1/2/2010 13:30	20	30	40	50	60	70
1/2/2010 16:00	40	60	60	60	60	60
1/2/2010 18:30	40	50	50	40	40	30

Re: Scatter plot matrix with 3 variables

Jay54 — Fri, 21 Feb 2014 04:48:05 GMT

This is not clear to me. Can you attach a SAS data set with four columns. Time, Signal1, Freq, Signal2?