Hi Experts,
I have a sample dataset which includes a month column which has month like YYYYMM format ( e.g. 201911 is November 2019). I have written a code which runs successfully but does not generate any output data. Could you please check and help? (Month column has type as 'Numeric', Group as 'Date' and Format as YYMMN6.)
Sample dataset
Data Accounts_in_Oct; infile cards expandtabs; input ACCOUNT_ID FINREP_CURR_SEGMENT$ FINREP_CURR_SEGMENT_REASON$ Month; datalines ; 100016 NONPERFORMING MEETREQUIREMENTS 201911 100032 PERFORMING MEETREQUIREMENTS 202311 100040 PERFORMING MEETREQUIREMENTS 202310 100075 NONPERFORMING MEETREQUIREMENTS 201911 100112 PERFORMING MEETREQUIREMENTS 201911 100120 PERFORMING MEETREQUIREMENTS 201911 100163 NONPERFORMING MEETREQUIREMENTS 202310 100198 NONPERFORMING MEETREQUIREMENTS 201911 100200 PERFORMING MEETREQUIREMENTS 201911 100278 NONPERFORMING MEETREQUIREMENTS 202310 100286 PERFORMING MEETREQUIREMENTS 201911 ; run;
Proc sql;
create table Accounts_in_Oct as
select
ACCOUNT_ID,
FINREP_CURR_SEGMENT,
FINREP_CURR_SEGMENT_REASON,
month
from FSFINREP.FINREP_LM_AF_DET
where month = 201911;
quit;
Log:
28 Proc sql;
29 create table Accounts_in_Oct as
30 select
31 ACCOUNT_ID,
32 FINREP_CURR_SEGMENT,
33 FINREP_CURR_SEGMENT_REASON,
34 month
35 from FSFINREP.FINREP_LM_AF_DET
36 where month = 201911;
NOTE: Table WORK.ACCOUNTS_IN_OCT created, with 0 rows and 4 columns.
37 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 10.96 seconds
user cpu time 0.02 seconds
system cpu time 0.01 seconds
memory 5004.75k
OS Memory 31404.00k
Timestamp 12/13/2023 02:54:42 PM
Step Count 35 Switch Count 8
Page Faults 0
Page Reclaims 4
Page Swaps 0
Voluntary Context Switches 77
Involuntary Context Switches 4
Block Input Operations 0
Block Output Operations 0
... View more
