You can use the ODS LAYOUT feature for HTML based output   See this code sample, it will create three KPI's side by side   ods layout gridded COLUMNS=3 width=50pct ; ods region; proc gkpi mode=raised; trafficlight actual=100 bounds=(100 97 85 0) / colors=(green yellow red) noavalue lfont=(h=16pt) bfont=(h=16pt) afont=(h=20pt) label="100% Mål KKK" ; run; ods region; proc gkpi mode=raised; trafficlight actual=96 bounds=(100 97 85 0) / colors=(green yellow red) noavalue lfont=(h=16pt) bfont=(h=16pt) afont=(h=20pt) label="100% Mål KKK" ; run; ods region; proc gkpi mode=raised; trafficlight actual=75 bounds=(100 97 85 0) / colors=(green yellow red) noavalue lfont=(h=16pt) bfont=(h=16pt) afont=(h=20pt) label="100% Mål KKK" ; run; ods layout end; Bruno ... View more

Hi   Use the OUT2= option with Proc CONTENTS, this will give the information on the constraints you.   You can also use the ODS OUTPUT statement to route the printed result to a SAS Data set, the ODS TRACE ON; statement will show you which output objects are created by a proc.   See a code sample below: ods trace on; ods output IntegrityConstraints=ic; proc contents data=testali out2=info; run; ods trace off; Bruno ... View more

Hi   From the document you showed, one can not see whether you actually called the macros.   the code should look like: %macro _startjob; /* your code */ %mend; %_startJob Also opening the Listing destination will not help, because SAS Enteprise Guide will generate code that closes all open destinations: (ods _all_ close;).   To collect the SAS Log there better alternatives then the Proc PRINTTO, because using Proc PRINTTO means, you will not see the SAS Log in SAS Enterprise Guide.   I suggest you have a look at the mentioned SAS Logging Facility, The App.Program logger is the one you want to use to capture the complete SAS Log of a session.   Have a look at this discussion as well https://communities.sas.com/t5/SAS-Enterprise-Guide/Setting-log-level-for-the-workspace-server/td-p/183038   Bruno ... View more

Hi   You combine the data that needs to be plotted into one data set using different varibale names, see below for an example   You then can use the appropriate plot statements of Proc SGPLOT that are compatible with each other, for your example they are VBARPARM and SCATTER   See also this blog entry http://blogs.sas.com/content/graphicallyspeaking/2013/03/09/parametric-bar-charts/ by @Jay54   Here is a code sample that creates two tables with the data to be plotted, they are combined and then used with Proc SGPLOT   proc sql; create table carsAggr1 as select origin , type , mean(horsePower) as avg_horsePower from sashelp.cars group by origin , type ; quit; proc sql; create table carsAggr2 as select origin as origin2 , count(*) / (select count(*) from sashelp.cars) as share_pct format=percent9.1 from sashelp.cars group by origin ; quit; data carsAggr3; set carsAggr1 carsAggr2; * * fill it, so we do not get an additional legend entry *; if type = " " then do; type = "SUV"; end; run; proc sgplot data=carsAggr3; vbarparm category=Origin response=avg_horsePower / group=Type name="bar"; scatter x=origin2 y=share_pct / y2axis markerattrs=(symbol= squarefilled) name="scatter" datalabel datalabelpos=top ; keylegend "bar" "scatter" / location=outside position=right noborder ; y2axis values=(0 to 1.2 by 0.2); run; Bruno ... View more

Hi   Have a look at the DBMAX_TEXT option. This option sets the maximum length of char variable coming from the DBMS.   See example below   proc sql; connect to oracle ( path="host/dbms" user=yourUser password=yourPassword DBMAX_TEXT=32767 ); create table myViews as select * from connection to oracle ( select * from all_views ) ; quit; Bruno ... View more

Hi   You will need to create a graph for each school district. An then include those graphs in the Proc REPORT   See the example below, it just creates the one graph which is used for all the schools.   ods _all_ close; Data Ranks; Length RateRank 8 SchDist $ 20 VarCount 8 VarRate 8; Infile Datalines Missover; Input RateRank SchDist VarCount VarRate; Datalines; 1 Auburn 523 720 2 Seattle 3425 560 3 Higline 662 543 4 SouthCentral 90 539 5 Kent 785 524 6 Renton 429 407 7 Shoreline 225 334 8 FederalWay 424 338 9 Tahoma 69 198 10 SnoqualmieValley 61 183 ; Run; * * load all the SAS/GRAPH macros *; %annomac Data Anno; * * declare the variables used by the annotate macros *; %dclanno * * set the coordinate system, in our case % of graphics area *; xsys="3"; ysys="3"; * * set how to measure size for text (pt) *; hsys="D"; * * use macros to create two bars and a text *; %Bar(0,0,100,100,cx0000ff,0,e); %Bar(0,0,75,100,cxff0000,0,s); %LABEL(100, 50, "75", cx000000, 0, 0, 8, none , <); Run; ods listing; OPTIONS printerpath=postscript; filename bar 'c:\temp\barsample.png'; goptions reset=all; goptions device=png gsfname=bar xpixels=100 ypixels=25; ; Proc gslide Anno=Anno; Run; Quit; ods listing close; Proc Format; Value ColorList 1-3="cxff0000" 4-6="cxff9999" 7-10="cxffeeb8" 11-13="cx9999ff" 14-16="cx0000ff" 17-19="white" ; Value TextColor 1,2,3='white' other='black' ; RUN; ods html file="c:\temp\sample.html"; PROC REPORT data=Ranks nowd; Columns RateRank SchDist ("Selected Measure" VarCount VarRate); Define RateRank / "Rank" group style=[background=ColorList. foreground=TextColor.]; Define SchDist / "School District"; Define VarCount / "Count"; Define VarRate / "Rate"; RUN; PROC REPORT data=Ranks nowd; Columns RateRank SchDist ("Selected Measure" VarCount VarRate) showBar ; Define RateRank / "Rank" group; Define SchDist / group "School District"; Define VarCount / "Count"; Define VarRate / "Rate"; Define ShowBar / "Relative Rate" computed; compute ShowBar / char; call define(_col_,'style',"style=[preimage='c:\temp\barsample.png']"); endcomp; Run; ods html close; Bruno ... View more

Hi   Using the task Summary Tables you can create something like this. The layout definition would look like It is using sashelp.cars.   And here a code example generated by SAS Enterprise Guide   PROC TABULATE DATA=SASHELP.CARS FORMAT=NLNUM14. ; WHERE( Origin IN ('Asia','Europe')); VAR Invoice; CLASS Type / ORDER=UNFORMATTED MISSING; CLASS Origin / ORDER=UNFORMATTED MISSING; CLASS DriveTrain / ORDER=UNFORMATTED MISSING; TABLE /* Row Dimension */ Type={LABEL=""} ALL={LABEL="Total (ALL)"}, /* Column Dimension */ Origin={LABEL=""}*( DriveTrain={LABEL=""}* Invoice={LABEL=""}* Sum={LABEL=""} ALL={LABEL="Total (ALL)"}* Invoice={LABEL=""}* Sum={LABEL=""}); ; RUN;   Bruno       ... View more