BookmarkSubscribeRSS Feed
anandbillava
Fluorite | Level 6
I am plotting a graph with two plots inside proc gplot. One of the variable is having all the missing observation. Due to this other variables are also not plotted. If i put this observation at the end then the graph will be plotted.
Please Let me know what is the solution
5 REPLIES 5
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
For this type of post, it is best to at least share your SAS code, ideally as part of your SAS log pasted in your post or reply to your own post.

Scott Barry
SBBWorks, Inc.
anandbillava
Fluorite | Level 6
NOTE: 19 observation(s) contained a MISSING value for the TRIAL_PATIENTS_PLAN * PERIOD_END_DATE
request.
NOTE: 19 observation(s) contained a MISSING value for the TRIAL_PATIENTS_ACTUAL * PERIOD_END_DATE
request.
NOTE: 19 observation(s) contained a MISSING value for the TREAT_PATIENTS_ACTUAL * PERIOD_END_DATE
request.


Other than that my data set has many missing observations. If i make the missing observation to 0 then it plots. but i dont need 0 to be plotted in my graph.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Please share your SAS code, not just the SAS NOTEs.

Possibly you have a data problem to address - would you expect the "missing value" condition.

What are you hoping to get back from the forum subscribers input/feedback?

Again - you really need to post your SAS code as it occurs in the SAS-generated log -- you may need to add the statement below to get the most diagnostic output:

OPTIONS SOURCE SOURCE2 MACROGEN MPRINT;

Scott Barry
SBBWorks, Inc.
anandbillava
Fluorite | Level 6
I dont have any problem in sharing the code. But its a big program and with lot of dependent data.

I am able to get succeed about 80% on this problem. Now i am stuck with order of the axis. If i dont mention the by value in order value then the order is clustered. These orders are dynamic always. For .eg
In axis if i put order = 1(a) to 100000(b) by 1000(c) - It works fine with beautiful graph
But if put order = 1(a) to 100000(b) then the graph is clustered.
Problem is i do know the a and b. But determing the c is becoming challenge for me.
Bill
Quartz | Level 8
I think you might mean cluttered rather than clustered.
If that's the case, you will want to limit the number of major tick marks. This can be done without specifying the increment c with an axis statement option such as
axis1 minor=none
major=(n=5)
;
If you add order, it might still get messy.
Another option might be to use proc means to find the min & max of the data for each variable and then run the results through a data step to round the min & max values, calculate an increment, and then output them to macro variables. These macro variables are then used in the axis statement, e.g. order=&min to &max by &incr.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 972 views
  • 0 likes
  • 3 in conversation