1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Aggiunta campi con sigla X';
4 %LET _CLIENTPROCESSFLOWNAME='Flusso dei processi';
5 %LET _CLIENTPROJECTPATH='C:\Users\AntonioCiccaglione\Desktop\Iccrea\Implementazione colonne X e aggiunta descrizione.egp'
5 ! ;
6 %LET _CLIENTPROJECTPATHHOST='LAPTOP-5ML4ES7K';
7 %LET _CLIENTPROJECTNAME='Implementazione colonne X e aggiunta descrizione.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HtmlBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 proc sql;
29 create table _3006_AG_E_DM_T099_INDOTHX_PROVA as
30 select a.* ,b.E_DOMINIO,b.E_DESCRIZIONE as E_T99_X0010
31 from mis2dm._3006_ag_e_dm_t099_indothx a
32 left join DOMINI_LDR_FIX b
33 on a.E_PU_08910=b.E_PU_08910 and a.E_T99_C0010=b.E_DOMINIO ;
WARNING: Variable E_T99_X0010 already exists on file WORK._3006_AG_E_DM_T099_INDOTHX_PROVA.
NOTE: Table WORK._3006_AG_E_DM_T099_INDOTHX_PROVA created, with 13 rows and 11 columns.
34 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
user cpu time 0.02 seconds
system cpu time 0.01 seconds
memory 14559.31k
OS Memory 36176.00k
Timestamp 19/07/2022 01:18:28 p.
Step Count 87 Switch Count 2
Page Faults 0
Page Reclaims 940
Page Swaps 0
Voluntary Context Switches 132
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 1952
35
36 %LET _CLIENTTASKLABEL=;
2 The SAS System 08:06 Tuesday, July 19, 2022
37 %LET _CLIENTPROCESSFLOWNAME=;
38 %LET _CLIENTPROJECTPATH=;
39 %LET _CLIENTPROJECTPATHHOST=;
40 %LET _CLIENTPROJECTNAME=;
41 %LET _SASPROGRAMFILE=;
42 %LET _SASPROGRAMFILEHOST=;
43
44 ;*';*";*/;quit;run;
45 ODS _ALL_ CLOSE;
46
47
48 QUIT; RUN;
49 This is the log
... View more
