1                                                          The SAS System                                10:57 Friday, March 1, 2019

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Programma (12)';
4          %LET _CLIENTPROJECTPATH='C:\Users\graschella\Desktop\ProgettiSAS\ProgettiEG\DatamartINPS_GapAnalysis_3_copia2.egp';
5          %LET _CLIENTPROJECTNAME='DatamartINPS_GapAnalysis_3_copia2.egp';
6          %LET _SASPROGRAMFILE=;
7          
8          ODS _ALL_ CLOSE;
9          OPTIONS DEV=ACTIVEX;
10         GOPTIONS XPIXELS=0 YPIXELS=0;
11         FILENAME EGHTML TEMP;
12         ODS HTML(ID=EGHTML) FILE=EGHTML
13             STYLE=HtmlBlue
14             STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
15             ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v94/sasgraph.exe#version=9,4")
16             NOGTITLE
17             NOGFOOTNOTE
18             GPATH=&sasworklocation
19             ENCODING=LATIN1
20         ;
NOTE: Writing HTML(EGHTML) Body file: EGHTML
21         
22         GOPTIONS ACCESSIBLE;
23         


24         proc sql;
25         create table estrazione as
26         select ID_caso, id_contatto, dt_creazione, d_creazione, origine,
27         id_categoria, id_sottocategoria, id_oggetto, categoria, sottocategoria,
28         oggetto
29         from dtm1.caso
30         where d_creazione >= "01Aug2018"d and d_creazione <= "31Aug2018"d
31         and origine in ("Chat","E-Mail","ENPALS Risponde","Fax","FondoCasalinghe",
32         "INPDAP Risponde","INPS Risponde","INTERNET","IRMobile","IRWeb","NO","SI","PEC",
33         "Portale Patronati","Processo Automatico","Processo Automatico IVR","RISCLA","Sede",
34         "Sede INPS","Servizio WEB","Sportello Mobile","TFR esattoriali","Telefono")
35         and id_contatto ne "1-39FZ"
36         and( id_categoria ne "" or id_sottocategoria ne "" or id_oggetto ne "" )
37         order by id_contatto, dt_creazione asc;
NOTE: Compressing data set WORK.ESTRAZIONE decreased size by 87.87 percent. 
      Compressed is 4133 pages; un-compressed would require 34073 pages.
NOTE: Table WORK.ESTRAZIONE created, with 1601416 rows and 11 columns.

38         quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           12.68 seconds
      cpu time            17.97 seconds
      

39         
40         GOPTIONS NOACCESSIBLE;
41         %LET _CLIENTTASKLABEL=;
42         %LET _CLIENTPROJECTPATH=;
43         %LET _CLIENTPROJECTNAME=;
44         %LET _SASPROGRAMFILE=;
45         
46         ;*';*";*/;quit;run;
2                                                          The SAS System                                10:57 Friday, March 1, 2019

47         ODS _ALL_ CLOSE;
48         
49         
50         QUIT; RUN;
51