Export/Print bar graph along with table in HTML format using SAS Data integration

AkshayS — Wed, 08 Jul 2020 09:00:37 GMT

Hi All,

I am trying to print both table and bar graph in HTML but able to only get table in output using SAS DI.

Kindly assist me what modification is needed in my below code:

ods listing close;
ods html path='/ACTDATA/fireuw/' (url=none)
body='sgplot.html';
goptions reset=all;

PROC SQL;
create table CARS1 as
SELECT make, model, type, invoice, horsepower, length, weight
FROM
SASHELP.CARS
WHERE make in ('Audi','BMW')
;
RUN;
proc print;
quit;

proc SGPLOT data = cars1;
vbar length /group = type GROUPDISPLAY = CLUSTER;
title 'Cluster of Cars by Types';
run;
quit;

ods html close;
ods listing;

Thanks,

Akshay

Re: Export/Print bar graph along with table in HTML format using SAS Data integration

Rama_V — Mon, 31 Aug 2020 23:49:24 GMT

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;

topic Re: Export/Print bar graph along with table in HTML format using SAS Data integration in SAS Data Management

Export/Print bar graph along with table in HTML format using SAS Data integration

Re: Export/Print bar graph along with table in HTML format using SAS Data integration