1 The SAS System 08:49 Monday, September 5, 2022
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='DNK COSTOFFUNDS';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\Colosas SAS prosjekter\CC 0.13.egp';
6 %LET _CLIENTPROJECTPATHHOST='ZLE02763';
7 %LET _CLIENTPROJECTNAME='CC 0.13.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 DNK_REPAYMENTPERFORMANCE_L12M as
30 select t.snp_dt
31 ,t.Product
32 ,t.Country
33 ,t.Prod_Group
34 ,t.Totalcount
35 ,t1.Missrep
36
37
38 from
39 (
40 select snp_dt, Product, Country,Prod_Group, count(Contractnbr) as TotalCount
41 from DNK_REPAYMENTPERFORMANCE_L12M_a
42 group by snp_dt, Product, Country,Prod_Group)t
43 and
___
22
76
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
44 (
45 select snp_dt, Product, Country,Prod_Group,RepaymentPerformanceL12M, count(Contractnbr) as MissRep
46 from DNK_REPAYMENTPERFORMANCE_L12M_a
47 where Repayment_performance='Repayment missed'
48 group by snp_dt, Product, Country,Prod_Group,RepaymentPerformanceL12M)t1
2 The SAS System 08:49 Monday, September 5, 2022
49 /*on*/
50 /* t.snp_dt=t1.snp_dt and t.Product=t1.Product and t.Country=t1.Country and t.Prod_Group=t1.Prod_Group)a*/
51
52 ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
53 Quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 436.21k
OS Memory 33120.00k
Timestamp 09/05/2022 12:19:55 PM
Step Count 95 Switch Count 0
54
55 %LET _CLIENTTASKLABEL=;
56 %LET _CLIENTPROCESSFLOWNAME=;
57 %LET _CLIENTPROJECTPATH=;
58 %LET _CLIENTPROJECTPATHHOST=;
59 %LET _CLIENTPROJECTNAME=;
60 %LET _SASPROGRAMFILE=;
61 %LET _SASPROGRAMFILEHOST=;
62
63 ;*';*";*/;quit;run;
64 ODS _ALL_ CLOSE;
65
66
67 QUIT; RUN;
68
... View more
