topic Re: handling missing data in proc sgrender in Graphics Programming

handling missing data in proc sgrender

anurak — Tue, 12 Aug 2014 22:52:38 GMT

When I try to plot using series plot in GTL, I am getting warnings because of missing data. Is there any options that I can use to ignore missing data instead of showing warnings in Log?. The code I used is

seriesplot x = xvar y = yvar/name="ser1";

seriesplot x=xvar1 y= yvar1/yaxis = y2 name = "ser2".

some of the yvar1 is missing.

warnings: y=yavr1

is invalid

Please let me know If there is any options to ignore missing value.

Re: handling missing data in proc sgrender

Jay54 — Tue, 12 Aug 2014 23:02:18 GMT

You will get warnings only if every observation in the data column is missing. This is so that one does not provide all missing data by error, and then wonder why the graph is not being drawn. There is no option you can set to suppress such warnings. I din't know of any system option either to suppress warnings.

Re: handling missing data in proc sgrender

anurak — Tue, 12 Aug 2014 23:15:24 GMT

Thanks for your help. I am getting warnings when xvar1 is present and the corresponding yvar1 is absent for each observation.

Re: handling missing data in proc sgrender

Jay54 — Wed, 13 Aug 2014 12:29:57 GMT

If every observation in a column assigned to a required role is missing, you will get this warning, and the plot will be dropped. For SERIES plot, both X and Y are required. In your case, since every observation in yvar1 is missing, you will get this warning.