1 The SAS System 09:59 Thursday, June 23, 2016 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Query Builder'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTNAME=''; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 %_eg_conditional_dropds(WORK.QUERY_FOR_dummy); 24 25 PROC SQL; 26 CREATE TABLE WORK.QUERY_FOR_dummy AS 27 SELECT t1.billingdate 28 FROM test.dummy t1 29 WHERE t1.billingdate >= '1May2016'd; NOTE: Table WORK.QUERY_FOR_dummy created, with 8932083 rows and 1 columns. 30 QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 52.48 seconds cpu time 12.73 seconds 31 32 GOPTIONS NOACCESSIBLE; 33 34 35 %LET _CLIENTTASKLABEL=; 36 %LET _CLIENTPROCESSFLOWNAME=; 37 %LET _CLIENTPROJECTPATH=; 38 %LET _CLIENTPROJECTNAME=; 39 40 ;*';*";*/;quit;run; 41 ODS _ALL_ CLOSE; 42 43 44 QUIT; RUN; 45
... View more