topic Re: PROC gplot in SAS Procedures

PROC gplot

bigban777 — Thu, 05 May 2016 01:09:42 GMT

Hi,

I try to plot graph using PROC GPLOT:

PROC GPLOT DATA = lead1;

footnote j=l 'curve'
	j=r 'MAT 4672 Lab 21';
plot iqf*fwtd=3/ frame cframe=beige;;
RUN;
QUIT;

and i got this

How make it nice and sorted.

P.S

I tried that

PROC SORT data = lead1;
by fwtd;
run;
PROC GPLOT DATA = lead1;

footnote j=l 'curve'
	j=r 'MAT 4672 Lab 21';
plot iqf*fwtd=3/ frame cframe=beige;;
RUN;
QUIT;

and got that:

Re: PROC gplot

Reeza — Thu, 05 May 2016 01:56:08 GMT

What are you expecting to get? And what do you think the = 3 means in your plot statement?

Re: PROC gplot

bigban777 — Thu, 05 May 2016 02:04:15 GMT

1)3 means squares instead just dots
2) i am expecting graph through all points(squares) and sorted by X axis like
https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSnEg3_Ebu_DNwEWswUg8aygvFFBKT61C9alWAMhujgcFzPZOSC

Re: PROC gplot

Reeza — Thu, 05 May 2016 02:39:59 GMT

Yeah, I don't think 3 does what you think it does. I can't test it, but I think you want something like this, where you use the symbol statement to define the symbol (square) and the interpol=j to join the points.


symbol1 interpol=j value='square';

PROC GPLOT DATA = lead1;

footnote j=l 'curve'
	j=r 'MAT 4672 Lab 21';
plot iqf*fwtd / frame cframe=beige;;
RUN;
QUIT;

Alternatively you can use the SGPLOT procedures which I find easier to navigate:

proc sgplot data=sashelp.stocks (where=(stock="IBM"));
scatter x=date y=open / markerattrs=(symbol='square' color='beige');
series x=date y=open / lineattrs=(color='beige');
run;quit;

Re: PROC gplot

bigban777 — Thu, 05 May 2016 02:46:18 GMT

I believe x should be sorted

See attached file

Re: PROC gplot

Reeza — Thu, 05 May 2016 03:53:23 GMT

I don't download attachments.

Post your code/log if it doesn't work in the message, preferably in a code window.

Re: PROC gplot

RW9 — Thu, 05 May 2016 08:29:21 GMT

Hi,

I would suggest 1) move over to sgplot and graph template language, you will find more options/better outputs and 2) check out Sanjay's blog:

http://blogs.sas.com/content/graphicallyspeaking/

Which has many thousands of examples on all kinds of graphs, you will find what you are looking for there.

Re: PROC gplot

ballardw — Thu, 05 May 2016 15:33:15 GMT

@bigban777 wrote:
1)3 means squares instead just dots
2) i am expecting graph through all points(squares) and sorted by X axis like
https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcSnEg3_Ebu_DNwEWswUg8aygvFFBKT61C9alWAMhujgcFzPZOSC

3 means to use Symbol3 statement for the display. Yours has some sort of interpolation option (INTERPOL= or I=) other than JOIN to "fit" a curve through the data. I would guess either SM Spline or L.

If you want to connect the points you need I=Join.