Your code is fine and it works.
I believe you are using user written transformation, make sure you refer the output work table(Physical) of user written transformation to cars1 to view the output in DI Studio.
Or change the code to below. After running it, right click on the work table output connected to user written transformation and then select update metadata. If the option is disable try after saving the job.
ods listing close;
ods html path='/ACTDATA/fireuw/' (url=none)
body='sgplot.html';
goptions reset=all;
PROC SQL;
create table &_output1. as
SELECT make, model, type, invoice, horsepower, length, weight
FROM
SASHELP.CARS
WHERE make in ('Audi','BMW')
;
RUN;
proc print;
quit;
proc SGPLOT data = &_output1.;
vbar length /group = type GROUPDISPLAY = CLUSTER;
title 'Cluster of Cars by Types';
run;
quit;
ods html close;
ods listing;
... View more