topic sgplot, vline, break on xaxis in Graphics Programming

sgplot, vline, break on xaxis

Dave25 — Sat, 14 Sep 2019 21:22:37 GMT

in the sample code, below, I can't figure out why the plotted lines aren't breaking at "Calc_4", which has a missing value?

thanks for any suggestions,

Dave

data test;
length Q $ 10;
input Q $ Q1 Grade Value;
datalines;
Calc_1 1 8 77
Calc_1 1 9 81
Calc_2 2 8 69
Calc_2 2 9 73
Calc_3 3 8 64
Calc_4 . . .
Non-Calc_1 1 8 83
Non-Calc_1 1 9 83
Non-Calc_2 2 8 84
Non-Calc_2 2 9 86
Non-Calc_3 3 8 83
Non-Calc_3 3 9 84
;
run;

proc format;
value $qfmt
'Calc_4' = ' ' ;
run;

proc sgplot data=test; format Q $qfmt.;
series x = Q y = value/group=grade BREAK ;
xaxis DISCRETEORDER=DATA ;
run;

Re: sgplot, vline, break on xaxis

jjjch — Sat, 14 Sep 2019 21:34:09 GMT

Maybe you need to add two records having missing values with Grade equal to 8 and 9? Like below:

data test;
length Q $ 10;
input Q $ Q1 Grade Value;
datalines;
Calc_1 1 8 77
Calc_1 1 9 81
Calc_2 2 8 69
Calc_2 2 9 73
Calc_3 3 8 64
Calc_4 . 8 .
Calc_4 . 9 .
Non-Calc_1 1 8 83
Non-Calc_1 1 9 83
Non-Calc_2 2 8 84
Non-Calc_2 2 9 86
Non-Calc_3 3 8 83
Non-Calc_3 3 9 84
;
run;

Re: sgplot, vline, break on xaxis

Dave25 — Sat, 14 Sep 2019 22:46:25 GMT

eureka! that works - thanks

Re: sgplot, vline, break on xaxis

FreelanceReinh — Sun, 15 Sep 2019 08:09:11 GMT

Hello @Dave25,

Glad to see that @jjjch's solution worked for you. Then it would help later readers if you marked that helpful reply as the accepted solution, not your own "thank you" post. Could you please change that? It's very easy: see instructions here (if needed): https://communities.sas.com/t5/SAS-Programming/how-to-find-the-difference-between-two-hex-data/m-p/552509#M153587