Hi,
I need to plot a vbar like plot with a subset that is highlighted. I tried the following and got an error message.
proc sgplot data=has;
yaxis label= "...";
vbar VEHICLE_NO;
vbar VEHICLE_NO_subset;
run;
The error message follows:
ERROR: The same category variable must be used for summarized plots.
The subset was generated as:
data has;
set has;
by vehicle_no;
if FAULT_CODE = '20-2018' and VEHICLE_NO in ("3725" "3727" "3728" "3729"
"3730" "3734" "3737" "3739" "3740" "3741" "3742" "3745" ) then
do;
vehicle_no_subset=vehicle_no;
end;
run;
You can use the VBARPARM statement with aggregated data using two different category variables or you make use of an additional
grouping variable and use the VBAR statement
See code sample below.
data cars2;
set sashelp.cars;
length group $ 8;
if type = "SUV" then do;
group = "SUV";
end;
else do;
group="other";
end;
run;
proc sgplot data=cars2 noautolegend;
vbar type / response=invoice stat=mean group=group ;
run;
data vehicle;
length
vehicle_no vehicle_no_subset $ 8
;
do vehicle_no = "3725", "3727", "3728", "3729", "4725", "4727", "4728", "4729";
response + 1;
call missing(vehicle_no_subset);
if vehicle_no in ("3725", "3727", "3728", "3729") then do;
vehicle_no_subset = vehicle_no;
end;
output;
end;
run;
proc sgplot data=work.vehicle;
vbarparm category=vehicle_no response=response;
vbarparm category=vehicle_no_subset response=response;
run;
Just try the code I provided, to see if the graphs looks the way you intend. Since you did not provide any test data, I had to create some data myself.
You then need to adapt your code accordingly either using the technique with the "group" variable or have a second category variable and use the VBARPARM statement. this data needs to be aggregated, as VBARPARM just plots the information, but does not do any aggregation.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.