1 The SAS System 10:04 Wednesday, August 24, 2016
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROJECTPATH='R:\NAT\SMARTCENT\SMCTRCHOP\GCFTELE\Telephony Performance\SAS EG Files\PST_ASA_Data.egp';
5 %LET _CLIENTPROJECTNAME='PST_ASA_Data.egp';
6 %LET _SASPROGRAMFILE=;
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=Ocean
14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/Ocean.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 LIBNAME data "/sasdata/clk/dev/SERVPERFCO/SDPAGENUSER/BIS/Data/SASLib/0.Blended/CAR/Telephony" access=readonly;
NOTE: Libref DATA refers to the same physical library as CARTEL.
NOTE: Libref DATA was successfully assigned as follows:
Engine: V9
Physical Name: /sasdata/clk/dev/SERVPERFCO/SDPAGENUSER/BIS/Data/SASLib/0.Blended/CAR/Telephony
24 LIBNAME REPORT "/sasdata/clk/dev/SERVPERFCO/SDPAGENUSER/BIS/Data/SASLib/0.Blended/CAR/misc/FAP_OA_Daily";
NOTE: Libref REPORT was successfully assigned as follows:
Engine: V9
Physical Name: /sasdata/clk/dev/SERVPERFCO/SDPAGENUSER/BIS/Data/SASLib/0.Blended/CAR/misc/FAP_OA_Daily
25 Run;
26
27 Data Report.PST_Unique;
28 Set CARTEL.Employee_Telephony;
29 Keep EVENT_DT EMPLOYMENT_TYPE Logon_ID;
30 Where EVENT_DT >= '01Jul2016'd
31 and CENTRE_TYPE = 'Smart Centres - Participation Solutions'
32 and CLUSTER = 'PST - Customer';
33 format EVENT_DT WeekDate30.;
34 Run;
NOTE: There were 9295 observations read from the data set CARTEL.EMPLOYEE_TELEPHONY.
WHERE (EVENT_DT>='01JUL2016'D) and (CENTRE_TYPE='Smart Centres - Participation Solutions') and (CLUSTER='PST - Customer');
NOTE: The data set REPORT.PST_UNIQUE has 9295 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.90 seconds
cpu time 1.18 seconds
35
36 proc sql;
37 select EVENT_DT, EMPLOYMENT_TYPE, count(distinct(Logon_ID)) as count_ID
38 from Report.PST_Unique
39 group by EVENT_DT, EMPLOYMENT_TYPE;
2 The SAS System 10:04 Wednesday, August 24, 2016
40 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.05 seconds
cpu time 0.06 seconds
41
42 Proc Transpose data=Report.PST_Unique out=work.PST_UNIQUE_FINAL (DROP=_NAME_);
43 By EVENT_DT;
44 ID EMPLOYMENT_TYPE;
45 VAR Count_ID;
ERROR: Variable COUNT_ID not found.
46 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.PST_UNIQUE_FINAL may be incomplete. When this step was stopped there were 0 observations and 0
variables.
WARNING: Data set WORK.PST_UNIQUE_FINAL was not replaced because this step was stopped.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
47
48 Proc Print data=Report.PST_Unique NOOBS;
49 run;
NOTE: There were 9295 observations read from the data set REPORT.PST_UNIQUE.
NOTE: PROCEDURE PRINT used (Total process time):
real time 3.97 seconds
cpu time 4.04 seconds
50
51 Proc SQL;
52 Drop Table Work.PST_UNIQUE_SUM;
WARNING: File WORK.PST_UNIQUE_SUM.DATA does not exist.
WARNING: Table WORK.PST_UNIQUE_SUM has not been dropped.
53 Drop table Report.PST_Unique;
NOTE: Table REPORT.PST_UNIQUE has been dropped.
54 Run;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
55
56 GOPTIONS NOACCESSIBLE;
57 %LET _CLIENTTASKLABEL=;
58 %LET _CLIENTPROJECTPATH=;
59 %LET _CLIENTPROJECTNAME=;
60 %LET _SASPROGRAMFILE=;
61
62 ;*';*";*/;quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
62 ! run;
63 ODS _ALL_ CLOSE;
3 The SAS System 10:04 Wednesday, August 24, 2016
64
65
66 QUIT; RUN;
67
