topic Re: Graph in SGPLOT (label and minor tick marks in x axis ) in SAS Programming

Graph in SGPLOT (label and minor tick marks in x axis )

Luis3 — Sat, 26 Aug 2017 12:16:35 GMT

Hi all, I have a question I hope you can help me with it.

It is possible to reproduce this Graph (showing label and minor tick marks in x axis, using SGPLOT instead?

I think the difficulty is insert the minor tickmarcks,

notice you can do it using GPLOT:

minor=(number=9 color=red height=2 width=1)

but I am interested to create this graph in SGPLOT.

Thanks,

data dowhlc;
input subjid high low close;
datalines;
1 6511.38 6318.96 6442.49
2 6586.42 6437.10 6544.09
3 6621.82 6481.75 6600.66
4 6621.82 6481.75 6600.66
5 6511.38 6318.96 6442.49
6 6586.42 6437.10 6544.09
7 6621.82 6481.75 6600.66
8 6621.82 6481.75 6600.66
9 6511.38 6318.96 6442.49
10 6586.42 6437.10 6544.09
11 6621.82 6481.75 6600.66
12 6621.82 6481.75 6600.66
13 6511.38 6318.96 6442.49
14 6586.42 6437.10 6544.09
15 6621.82 6481.75 6600.66
16 6621.82 6481.75 6600.66
17 6511.38 6318.96 6442.49
18 6586.42 6437.10 6544.09
19 6621.82 6481.75 6600.66
20 6621.82 6481.75 6600.66
21 6586.42 6437.10 6544.09
22 6621.82 6481.75 6600.66
23 6621.82 6481.75 6600.66
24 6511.38 6318.96 6442.49
25 6586.42 6437.10 6544.09
26 6621.82 6481.75 6600.66
27 6621.82 6481.75 6600.66
28 6511.38 6318.96 6442.49
29 6586.42 6437.10 6544.09
30 6621.82 6481.75 6600.66
run;

data dowhlc2;
set dowhlc;
drop high low close;
dow=high; output;
dow=low; output;
dow=close; output;

title1 'Dow Jones High-Low-Close';
title2 'January, 1997';
footnote height=3 justify=right 'GR08N01 ' ;

symbol interpol=hiloctj
cv=blue
ci=red
width=2;

axis1 order=(10 20 30)
offset=(3,3)
color=blue
label=none
major=(height=3 width=2)
minor=(number=9 color=red height=2 width=1)
width=3;

axis2 color=blue
label=none
major=(height=3)
minor=(number=4 color=red height=1)
offset=(2,2);

proc gplot data=dowhlc2;
plot dow*subjid / haxis=axis1
vaxis=axis2;
run;
quit;

Re: Graph in SGPLOT (label and minor tick marks in x axis )

Luis3 — Sat, 26 Aug 2017 13:45:47 GMT

Hi again,

I did part of the job, now need to reproduce the same label and minot tick marks

I used in GPLOT:

If anyone can help me with it, to reproduce the same x axis I did for GPLOT, will

be appreciate,

Thanks,

data dowhlc;

input subjid high low close;

datalines;

1 6511.38 6318.96 6442.49

2 6586.42 6437.10 6544.09

3 6621.82 6481.75 6600.66

4 6621.82 6481.75 6600.66

5 6511.38 6318.96 6442.49

6 6511.38 6318.96 6442.49

7 6586.42 6437.10 6544.09

8 6621.82 6481.75 6600.66

9 6621.82 6481.75 6600.66

10 6511.38 6318.96 6442.49

11 6511.38 6318.96 6442.49

12 6586.42 6437.10 6544.09

13 6621.82 6481.75 6600.66

14 6621.82 6481.75 6600.66

15 6511.38 6318.96 6442.49

16 6511.38 6318.96 6442.49

17 6586.42 6437.10 6544.09

18 6621.82 6481.75 6600.66

19 6621.82 6481.75 6600.66

20 6511.38 6318.96 6442.49

21 6511.38 6318.96 6442.49

22 6586.42 6437.10 6544.09

23 6621.82 6481.75 6600.66

24 6621.82 6481.75 6600.66

25 6511.38 6318.96 6442.49

26 6511.38 6318.96 6442.49

27 6586.42 6437.10 6544.09

28 6621.82 6481.75 6600.66

29 6621.82 6481.75 6600.66

30 6511.38 6318.96 6442.49

;

ods listing close;

ods graphics / reset width=600px height=400px imagefmt=gif;

proc sgplot data=dowhlc noautolegend;

scatter x=subjid y=close / yerrorlower=low

yerrorupper=high

markerattrs=(color=blue symbol=CircleFilled);

series x=subjid y=close / lineattrs=(color=blue pattern=2);

run;

ods listing;

Re: Graph in SGPLOT (label and minor tick marks in x axis )

Luis3 — Sat, 26 Aug 2017 13:54:30 GMT

Label 10 20 30 can be done adding this line:

xaxis label='Rain' grid values= (10 20 30);

Now, I need to add the minor tickmarks , any one can help me with it?

thanks.

Re: Graph in SGPLOT (label and minor tick marks in x axis )

Luis3 — Sat, 26 Aug 2017 14:08:08 GMT

I solved my own question 🙂

I havr to use minor option and then minorcount=9:

xaxis label='Rain' grid values= (10 20 30) minor minorcount=9;

Solved 🙂

Reproducing GPLOT graph using SGPLOT:

data dowhlc;

input subjid high low close;

datalines;

1 6511.38 6318.96 6442.49

2 6586.42 6437.10 6544.09

3 6621.82 6481.75 6600.66

4 6621.82 6481.75 6600.66

5 6511.38 6318.96 6442.49

6 6511.38 6318.96 6442.49

7 6586.42 6437.10 6544.09

8 6621.82 6481.75 6600.66

9 6621.82 6481.75 6600.66

10 6511.38 6318.96 6442.49

11 6511.38 6318.96 6442.49

12 6586.42 6437.10 6544.09

13 6621.82 6481.75 6600.66

14 6621.82 6481.75 6600.66

15 6511.38 6318.96 6442.49

16 6511.38 6318.96 6442.49

17 6586.42 6437.10 6544.09

18 6621.82 6481.75 6600.66

19 6621.82 6481.75 6600.66

20 6511.38 6318.96 6442.49

21 6511.38 6318.96 6442.49

22 6586.42 6437.10 6544.09

23 6621.82 6481.75 6600.66

24 6621.82 6481.75 6600.66

25 6511.38 6318.96 6442.49

26 6511.38 6318.96 6442.49

27 6586.42 6437.10 6544.09

28 6621.82 6481.75 6600.66

29 6621.82 6481.75 6600.66

30 6511.38 6318.96 6442.49

;

ods listing close;

ods graphics / reset width=600px height=400px imagefmt=gif;

/* The SCATTER statement generates the scatter plot with error bars. */

/* The SERIES statement draws the line to connect the means. */

proc sgplot data=dowhlc noautolegend;

scatter x=subjid y=close / yerrorlower=low

yerrorupper=high

markerattrs=(color=blue symbol=CircleFilled);

series x=subjid y=close / lineattrs=(color=blue pattern=2);

xaxis label='Rain' grid values= (10 20 30) minor minorcount=9;

title1 'Plot Means with Standard Error Bars from Calculated Data';

run;

ods listing;