1 The SAS System 16:01 Thursday, November 12, 2020
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 PROC SQL NOEXEC;
4 SELECT t1.G1ZWCG,
5 t1.G1UEDT LABEL="FIP Created Date" AS G1UEDT,
6 t1.G1PDVC LABEL="FIP Plan Amount" AS G1PDVC,
7 t1.G1AAVN LABEL="FIP Created By" AS G1AAVN,
8 t1.G1PZTA LABEL="WEBCOLLS Created By" AS G1PZTA,
9 t1.n9e5cd LABEL="Router Number" AS n9e5cd,
10 /* Total Created By */
11 (IFC(t1.G1AAVN, 'WEBCOLLS', t1.G1PZTA, t1.G1AAVN)) AS 'Total Created By'n
12 FROM DM_DATA.DM_G1_FLEXISTPLAN_HEADER t1
13 WHERE t1.G1UEDT >= 1201111 AND t1.G1ZWCG NOT IS MISSING;
ERROR: Function IFC requires a numeric expression as argument 1.
14 QUIT;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
Memory 446k
OS Memory 18728k
Timestamp 11/12/2020 6:47:48 PM
Page Faults 0
Page Reclaims 32
Page Swaps 0
Voluntary Context Switches 11
Involuntary Context Switches 6
Block Input Operations 0
Block Output Operations 0
15 QUIT; RUN;
16
... View more
