Thank you Kurt I really appreciate you coming back to me. I have previously deleted that dataset in the RLADV but then I get the error that it doesn't exist, then it creates a new one but it looks the same as the previous one. 33 libname rladv "/proj/sas/sasdata/basesas/nonrisk/OnePath/SASTables/Data/Retail/ADV";
NOTE: Libref RLADV was successfully assigned as follows:
Engine: V9
Physical Name: /proj/sas/sasdata/basesas/nonrisk/OnePath/SASTables/Data/Retail/ADV
34
35 data _null_;
36 call symput('im',trim(left(month(intnx('month',today(),-1,'beginning')))));
37 call symput('iy',substr(trim(left(year(intnx('month',today(),-1,'beginning')))),3,2));
38 call symput('iy_a',trim(left(year(intnx('month',today(),-1,'beginning')))));
39 run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
36:29 37:36 38:31
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
40
2 The SAS System 17:52 Sunday, November 14, 2021
41 %put &im;
10
42 %put &iy;
21
43 %put &iy_a;
2021
44 Options datestyle=dmy;
45
46 /* ************************************************************************************************** */
47 /* # 1 # - Submissions Tracker - BDM */
48 /* ************************************************************************************************** */
49 data b1;
50 infile "/proj/sas/sasdata/basesas/nonrisk/OnePath/InputFiles/bdm&iy.&im..csv"
51 dsd dlm = ';' missover firstobs = 2 linesize = 32767;
52 informat AR_Party_Key $18. Open_Acc ddmmyy10. close_acc ddmmyy10. Acc_Name $50. Dealer_grp $50. Strategic_AM $3.
52 ! Member_type $19. OP_NB_Seg $4. Industry_NB_Seg $10.
53 Region $7. OP_Salesperson $37.;
54 format AR_Party_Key $18. Open_Acc ddmmyy10. close_acc ddmmyy10. Acc_Name $50. Dealer_grp $50. Strategic_AM $3.
54 ! Member_type $19. OP_NB_Seg $4. Industry_NB_Seg $10.
55 Region $7. OP_Salesperson $37.;
56 input AR_Party_Key :$18. Open_Acc :anydtdte. close_acc :anydtdte. Acc_Name :$50. Dealer_grp :$50. Strategic_AM :$3.
56 ! Member_type :$19. OP_NB_Seg :$4. Industry_NB_Seg :$10.
57 Region :$7. OP_Salesperson :$37.;
58 file_d = mdy(&im.,1,&iy_a.);
59 format file_d ddmmyy10.;
60 informat file_d ddmmyy10.;
61 run;
NOTE: The infile "/proj/sas/sasdata/basesas/nonrisk/OnePath/InputFiles/bdm2110.csv" is:
Filename=/proj/sas/sasdata/basesas/nonrisk/OnePath/InputFiles/bdm2110.csv,
Owner Name=symondsr,Group Name=gblunixdefault,
Access Permission=-rw-r--r--,
Last Modified=14Nov2021:12:30:05,
File Size (bytes)=2167334
NOTE: 22234 records were read from the infile "/proj/sas/sasdata/basesas/nonrisk/OnePath/InputFiles/bdm2110.csv".
The minimum record length was 54.
The maximum record length was 139.
NOTE: The data set WORK.B1 has 22234 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.05 seconds
62
63 /*sas 7bdat file can be found:/proj/sas/sasdata/basesas/nonrisk/OnePath/SASTables/Data/Retail/ADV*/
64
65 data bdm_hist;
66 set rladv.bdm_hist b1;
67 run;
NOTE: There were 1744186 observations read from the data set RLADV.BDM_HIST.
NOTE: There were 22234 observations read from the data set WORK.B1.
NOTE: The data set WORK.BDM_HIST has 1766420 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 1.17 seconds
cpu time 0.75 seconds
3 The SAS System 17:52 Sunday, November 14, 2021
68
69 data rladv.bdm_hist (compress = yes);
70 set bdm_hist;
71 run;
NOTE: There were 1766420 observations read from the data set WORK.BDM_HIST.
NOTE: The data set RLADV.BDM_HIST has 1766420 observations and 13 variables.
NOTE: Compressing data set RLADV.BDM_HIST decreased size by 42.70 percent.
Compressed is 3589 pages; un-compressed would require 6264 pages.
NOTE: DATA statement used (Total process time):
real time 1.47 seconds
cpu time 1.22 seconds
... View more