BookmarkSubscribeRSS Feed
denserro
Calcite | Level 5

I have been having issues with creating block groups in proc boxplot.

i.e. The example when I try to perform the following:

 

proc boxplot;

plot y*male (group);

run;

 

I keep getting an error message that the data is not properly sorted.  

 

NOTE: Processing beginning for PLOT statement number 1.
ERROR: The values of the group variable male are not sorted in increasing order in the data set
POOLED.
NOTE: Recommended practice is to sort the data by the group variable (within BY groups if any)
with PROC SORT.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 3432 observations read from the data set WORK.POOLED.
NOTE: PROCEDURE BOXPLOT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

 

However, when I do attempt to sort the data in the following way, it does not work.

proc sort; by group male; 

 

This also does not work.

proc sort; by male group;

 

The odd thing is that this method DOES work on one dataset I have but not another one.

 

Has anyone else experienced this issue?

 

2 REPLIES 2
Reeza
Super User
You never reference data in either of your procs? Can you please post your full code. It should be something like the following:

proc sort DATA=HAVE;
by male group;
run;

proc boxplot data=HAVE;
...

run;
ballardw
Super User

@denserro wrote:

 

However, when I do attempt to sort the data in the following way, it does not work.

proc sort; by group male; 

 

This also does not work.

proc sort; by male group;

 

The odd thing is that this method DOES work on one dataset I have but not another one.

 

Has anyone else experienced this issue?

 


Please describe how or what doesn't work. Do you get an error message from the sort, post the error.

 

When you do not explicitly list the name fo the data set to be used the last created data set is used in procs. You might be attempting to sort a data set other than the one used for the boxplot procedure or plotting a set other than the sorted one.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1004 views
  • 0 likes
  • 3 in conversation