1                                                          Le Système SAS                             11:35 Thursday, August 4, 2016

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Filtrer et trier12';
4          %LET _CLIENTPROJECTPATH='C:\Users\vrqn418\Documents\PILOTAGE\Extract SID\analyse des causes 2015\SAS ADC\adc janvier
4        ! 2016.egp';
5          %LET _CLIENTPROJECTNAME='adc janvier 2016.egp';
6          
7          ODS _ALL_ CLOSE;
8          OPTIONS DEV=ACTIVEX;
9          GOPTIONS XPIXELS=0 YPIXELS=0;
10         FILENAME EGSR TEMP;
11         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue
11       ! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE
11       ! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
12         
13         GOPTIONS ACCESSIBLE;
14         %_eg_conditional_dropds(WORK.FILTER_FOR_QUERY_FOR_APPEND_TABL);
15         
16         PROC SQL;
17            CREATE TABLE WORK.FILTER_FOR_QUERY_FOR_APPEND_TABL AS
18            SELECT t1.'Libellé Centre Financier'n,
19                   t1.'Métier'n,
20                   t1.'Libellé famille opération'n,
21                   t1.LB_TYP_OPE2,
22                   t1.Nombre,
23                   t1.BGP,
24                   t1.'Date dernière màj opération'n,
25                   t1.'Numéro de compte1'n,
26                   t1.'Code CF'n,
27                   t1.'BGP begin'n,
28                   t1.'CF après bascule'n,
29                   t1.'Date de bascule'n
30               FROM WORK.QUERY_FOR_APPEND_TABLE t1
31               WHERE SUBSTR(t1.'Numéro de compte1'n, 1, 2) ;
NOTE: Table WORK.FILTER_FOR_QUERY_FOR_APPEND_TABL created, with 298549 rows and 12 columns.

32         QUIT;
NOTE: PROCEDURE SQL used (Total process time):
      real time           2.60 secondes
      cpu time            0.71 secondes
      

33         
34         GOPTIONS NOACCESSIBLE;
35         %LET _CLIENTTASKLABEL=;
36         %LET _CLIENTPROJECTPATH=;
37         %LET _CLIENTPROJECTNAME=;
38         
39         ;*';*";*/;quit;run;
40         ODS _ALL_ CLOSE;
41         
42         
43         QUIT; RUN;
44