Data visualization with SAS programming

handling missing data in proc sgrender

Reply
Occasional Contributor
Posts: 8

handling missing data in proc sgrender

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.

SAS Super FREQ
Posts: 1,139

Re: handling missing data in proc sgrender

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.

Occasional Contributor
Posts: 8

Re: handling missing data in proc sgrender

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

SAS Super FREQ
Posts: 1,139

Re: handling missing data in proc sgrender

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.

Ask a Question
Discussion stats
  • 3 replies
  • 417 views
  • 3 likes
  • 2 in conversation