Hi,
I have created this stored process with EG and as far I can see I do not override anything.
Definition of Stored Process:
%STPBEGIN;
%LET _EGCHARTWIDTH=640;
%LET _EGCHARTHEIGHT=480;
%LET _SASSERVERNAME=%NRBQUOTE(SASMain - Logical Stored Process Server);
... [some code to create the following view]
PROC SQL;
CREATE VIEW WORK.SORTTempTableSorted
AS SELECT Monat, art, Anzahl, Jahr FROM WORK.QUERY_FOR_HUC_ERGEBNIS;
QUIT;
GOPTIONS xpixels=&_EGCHARTWIDTH ypixels=&_EGCHARTHEIGHT;
GOPTIONS CBACK=WHITE;
Legend1
FRAME
;
Axis1
STYLE=1
WIDTH=1
MINOR=NONE
;
Axis2
STYLE=1
WIDTH=1
;
Axis3
;
Axis3
STYLE=1
WIDTH=1
;
TITLE;
TITLE1 "Balkendiagramm";
FOOTNOTE;
FOOTNOTE1 "Erzeugt vom SAS System (&_SASSERVERNAME, &SYSSCPL) am %SYSFUNC(DATE(), DDMMYYP10.) um %SYSFUNC(TIME(), TIME5.)";
PROC GCHART DATA=WORK.SORTTempTableSorted
;
VBAR3D Monat
/
SUMVAR=Anzahl
SUBGROUP=art
SHAPE=BLOCK
FRAME DISCRETE
TYPE=SUM
LEGEND=LEGEND1
COUTLINE=BLACK
RAXIS=AXIS1
MAXIS=AXIS2
GAXIS=AXIS3
GAXIS=AXIS3
;
BY Jahr;
/* -------------------------------------------------------------------
Ende Code der Anwendungsroutine.
------------------------------------------------------------------- */
RUN; QUIT;
PROC SQL;
%_SASTASK_DROPDS(WORK.SORTTempTableSorted);
QUIT;
TITLE; FOOTNOTE;
/* --- Ende des Codes für "Balkendiagramm". --- */
* Begin EG generated code (do not edit this line);
*';*";*/;run;
%STPEND;
... View more