Hello, I have created more than two years ago my &home/.tks3.conf many months ago which contains keyID, secret and the region as well.   Unfortunately, I don't remember how I have created it and on top of that, the value found into that file are not the one I see on Amazon when I go on AWS access portal. To use three different folders for dev, intg and uat is a very good idea.  The first steps I want to do is to get the list of the files into each bucket.  You will find my SAS code below. Only the old dev values into the home/.tks3.config file is working.  It is strange.  How can I solve that issue?   can you provide me your SAS script just to get the files listing using either a pipe command or a proc s3 and passing the .tks3 value in it.   %macro FindingMasterListPolicyName(env); %let filelist=/&path1./s3filestodownload.txt; /***** Selecting the good s3 bucket path according to the environment selected *****/ %if &env eq dev %then %let s3bucketpath=s3://dev-pr-brz-datareten-edp-nprod; %else %if &env eq intg %then %let s3bucketpath=s3://intg-pr-brz-datareten-edp-nprod; %else %if &env eq uat %then %let s3bucketpath=s3://uat-pr-brz-datareten-edp-nprod; %put &=env &=s3bucketpath; /*********************************************************************************/ filename oscmd pipe "aws s3 ls ""&s3bucketpath."" --recursive | grep .csv "; data foldercontents2 ; length text $2000. fnameandpath $200.; infile oscmd; input; text=_infile_; run; data foldercontents2 (drop=text); set foldercontents2 ; creationdate=scan(text,1,' '); creationtime=scan(text,2,' '); filesize=scan(text,3,' '); fnameandpath =scan(text,1," ","b"); FName =scan(text,1,"/","b"); path=substr(fnameandpath,1,length(fnameandpath)-length(FName)- 1); where find(text,'MASTER_LIST') > 0 AND find(text,'_Policy_') > 0 AND find(text,'ARCHIVE') = 0; run; proc sort data=foldercontents2 out=foldercontents; by creationdate creationtime FName; run; /*** Getting the path and file name of the Master List to download ***/ Data _null_; set foldercontents; if _n_ = 1 then do; call symputx('MasterListName',Fname,'g'); call symputx('masterlistfilepath',Path,'g'); end; run; %put &=masterlistfilepath. &=MasterListName.; %goto exit; filename filelist "&filelist"; data _null_; FILE filelist LRECL=150 recfm=v; put "&masterlistfilepath./&MasterListName."; ; run; %exit: %mend FindingMasterListPolicyName; %FindingMasterListPolicyName(dev); ... View more

When you mentioned that the directory was available with the ls command, you piqued my interest. So I decided instead of using a script from one of our SAS admins, to read the contents of the infile. And effectively, you were right.   So here's my SAS code   %let dir=/.../sasdata/; libname dest1 base "/.../data"; filename oscmd1 pipe "ls -Rla --time-style=long-iso ~ &dir. "; Data dest1.sasfiles1 ; length response $1000.; infile oscmd1 ; input ; response= _infile_; run; data sasfile2 specialcases; set dest1.sasfiles1; if find(response,'total') > 0 then delete; else if find(response,'cannot access') > 0 then output specialcases; else if find(response,'?') > 0 then output specialcases; else if response = '' then delete; else output sasfile2; run; data sasfile2; set sasfile2 /*(firstobs=1 obs=10)*/; run; data files (drop= pos pos2 response); length permission $11 links pos 8 user group filetype $10 size 8 folderorfname $100 response $1000; retain path; set sasfile2; if ':'=char(response,length(response)) then do; path = substr(response,1,length(response)-1); delete; end; if '.'=char(response,length(response)) then delete; pos=find(response,':'); pos2=length(response); if pos=find(response,':') lt length(response) then do; pos=pos+3; folderorfname =substr(response,pos,length(response)-pos+1); end; else do; delete; end; creation_time=scan(response,7, ''); creation_date=scan(response,6, ''); size=scan(response,5, ''); group=scan(response,4,''); user=scan(response,3,''); links=scan(response,2,''); permission=scan(response,1,''); if user eq 'root' then delete; if find(folderorfname,'.') > 0 then filetype = 'file'; else if find(folderorfname,'.') = 0 then filetype = 'folder'; run; ... View more

Good Morning Mr Bremser,   Good point.  However, how do you interpret the contents of the notes that goes for the value of the pipe command to the length of the string as below. How do you interpret that. Does it means that the last pipe command did not work fine.    NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 20 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.13.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. ... View more

The ls command provides me the owner, group, permission, creation date, creation time and of course, the file size. However, the ls command did not provide me the path. So, in the sasfile, I have about 62 000 file names for which I would like to get their path and in some case, the same could have few different path.   Therefore, I am using the find command to find the various paths for each file. However if we look at the log file it seems that the find command works well for the first two hundreds files and we are not getting any information for the remaining files approximately 61800.   I am trying to find what wrong with the find command because in the log file we can see at the beginning the information related to the find command but after a certain point we can see the note but without the information on the find command as below   NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. So I would like to know what to do to get the path of the remaining files (61800). Any idea how to solve that problem  ... View more

The program failed again. I wonder if it is not the time that is an issue, because it seems to failed always at the same obseration.  I have try to get the response with a separate piece of code and it tooks many minutes before getting an anwser.  Could it be the time to get a reponse after the pipe that is too long.  If so, how to solve that?   filename oscmd2 pipe ' find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>/dev/null'; Data sasfiles3 ; infile oscmd2 dsd LRECL=32000 TRUNCOVER ; length information $200.; input information $ char200.; fname=scan(information,-1,"/"); path=substr(information,1,length(information)-length(fname)-1); run; /************** log file **************************/ 1 The SAS System 14:12 Thursday, October 31, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Programme 5'; 4 %LET _CLIENTPROCESSFLOWNAME='Flux de processus'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 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 STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/8/Styles/HTMLBlue.css") 24 NOGTITLE 25 NOGFOOTNOTE 26 GPATH=&sasworklocation 27 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 28 29 options mprint mlogic source2; 30 31 %let dir=/dwh_actuariat/sasdata/; 32 libname dest1 base "/finsys/bicoe/BICOE/CR_SR_Prj/LEGO_3730_Data_Retention/data"; NOTE: Libref DEST1 was successfully assigned as follows: Engine: BASE Physical Name: /finsys/bicoe/BICOE/CR_SR_Prj/LEGO_3730_Data_Retention/data 33 34 /*proc printto log='/finsys/bicoe/Temp/Alain/logfiles/sasfiles_log.txt' new;*/ 35 /*run;*/ 36 37 filename oscmd1 pipe "ls -Rla --time-style=long-iso ~ &dir. | awk '{printf ""%-10s %-10s %10s %20s %12s %s %s\n"", $1, 37 ! $3, $4, $5, $6, $7, substr($0,index($0,""/""),500)}'"; WARNING: Apparent invocation of macro S not resolved. WARNING: Apparent invocation of macro S not resolved. 38 39 Data dest1.sasfiles1 ; 40 format fname $50. ; 41 infile oscmd1 dsd LRECL=32000 TRUNCOVER firstobs=2; 42 input 43 44 permissions $ 1-12 45 owner $ 12-24 46 group $ 26-35 47 fsize $ 36-54 48 cr_dt $ 55-67 49 time $ 68-74 50 filepath $ 75-500 51 ; 2 The SAS System 14:12 Thursday, October 31, 2024 52 run; NOTE: Variable fname is uninitialized. NOTE: The infile OSCMD1 is: Pipe command="ls -Rla --time-style=long-iso ~ /dwh_actuariat/sasdata/ | awk '{printf "%-10s %-10s %10s %20s %12s %s %s\n", $1, $3, $4, $5, $6, $7, substr($0,index($0,"/"),500)}'" NOTE: 1242521 records were read from the infile OSCMD1. The minimum record length was 30. The maximum record length was 586. NOTE: The data set DEST1.SASFILES1 has 1242521 observations and 8 variables. NOTE: Compressing data set DEST1.SASFILES1 decreased size by 70.32 percent. Compressed is 775 pages; un-compressed would require 2611 pages. NOTE: DATA statement used (Total process time): real time 7:53.04 cpu time 1.70 seconds 53 54 data sasfiles2; 55 format create_date create_date2 yymmdd10. create_time tod5.; 56 length cfname $100. fname $50.; 57 set dest1.sasfiles1; 58 59 where owner eq 'dwhprd1' and find(filepath,'prm')> 0 and find(filepath, '_ab_') =0 and find(filepath, 'raw') =0 and 59 ! find(filepath, '_d') =0 and find(filepath, 'dat') =0 60 and find(filepath,'test')= 0 and find(filepath,'after')= 0 and find(filepath,'Test')= 0 and 60 ! find(filepath,'zip')= 0 and find(filepath,'prmccl') = 0 61 and find(filepath,'tst001mc')= 0 and find(filepath,'prmmichele')= 0 and find(filepath,'_old')= 0 61 ! and find(filepath,'gcna_prm_src')= 0 62 and find(filepath,'histo')= 0 and find(filepath,'all')= 0 and find(filepath,'atl')= 0 and 62 ! find(filepath,'before')= 0 and find(filepath,'war')= 0 63 and find(filepath,'log')= 0 and find(filepath,'lst')= 0 and find(filepath,'cmay25p')= 0 and 63 ! find(filepath,'conprjc')= 0 and find(filepath,'conprjh')= 0 64 and find(filepath,'pasprjc')= 0 and find(filepath,'cyc1')= 0 and find(filepath,'eco')= 0 and 64 ! find(filepath,'igroup')= 0 and find(filepath,'ont_ont')= 0 65 and find(filepath,'pas')= 0 and find(filepath,'prji')= 0 and find(filepath,'uapr')= 0 and 65 ! find(filepath,'wst')= 0 and find(filepath,'ukp')= 0 66 and find(filepath,'dev')= 0 and find(filepath,'ykp')= 0 and find(filepath,'cmcle')= 0 and 66 ! find(filepath,'nhfld')= 0 and find(filepath,'bad')= 0 67 and find(filepath,'abw2')= 0 and find(filepath,'bcclm')= 0 and find(filepath,'covid')= 0 and 67 ! find(filepath,'prj')= 0 and find(filepath,'west')= 0 68 and find(filepath,'tsv')= 0 and find(filepath,'octv')= 0 and find(filepath,'wcauto')= 0 and 68 ! find(filepath,'sept2017')= 0 and find(filepath,'novtst2017')= 0 ; 69 filesize=input(fsize,8.); 70 fname = scan(scan(filepath,-1,''),1,'.'); 71 cfname=scan(filepath,-1,''); 72 create_date=input(cr_dt,yymmdd10.); 73 create_date2=intnx('day',create_date,1); 74 create_time=input(time,time.); 75 cr_dt2=put(create_date2,yymmdd10.); 76 run; NOTE: There were 61257 observations read from the data set DEST1.SASFILES1. WHERE (owner='dwhprd1') and (FIND(filepath, 'prm')>0) and (FIND(filepath, '_ab_')=0) and (FIND(filepath, 'raw')=0) and (FIND(filepath, '_d')=0) and (FIND(filepath, 'dat')=0) and (FIND(filepath, 'test')=0) and (FIND(filepath, 'after')=0) and (FIND(filepath, 'Test')=0) and (FIND(filepath, 'zip')=0) and (FIND(filepath, 'prmccl')=0) and (FIND(filepath, 'tst001mc')=0) 3 The SAS System 14:12 Thursday, October 31, 2024 and (FIND(filepath, 'prmmichele')=0) and (FIND(filepath, '_old')=0) and (FIND(filepath, 'gcna_prm_src')=0) and (FIND(filepath, 'histo')=0) and (FIND(filepath, 'all')=0) and (FIND(filepath, 'atl')=0) and (FIND(filepath, 'before')=0) and (FIND(filepath, 'war')=0) and (FIND(filepath, 'log')=0) and (FIND(filepath, 'lst')=0) and (FIND(filepath, 'cmay25p')=0) and (FIND(filepath, 'conprjc')=0) and (FIND(filepath, 'conprjh')=0) and (FIND(filepath, 'pasprjc')=0) and (FIND(filepath, 'cyc1')=0) and (FIND(filepath, 'eco')=0) and (FIND(filepath, 'igroup')=0) and (FIND(filepath, 'ont_ont')=0) and (FIND(filepath, 'pas')=0) and (FIND(filepath, 'prji')=0) and (FIND(filepath, 'uapr')=0) and (FIND(filepath, 'wst')=0) and (FIND(filepath, 'ukp')=0) and (FIND(filepath, 'dev')=0) and (FIND(filepath, 'ykp')=0) and (FIND(filepath, 'cmcle')=0) and (FIND(filepath, 'nhfld')=0) and (FIND(filepath, 'bad')=0) and (FIND(filepath, 'abw2')=0) and (FIND(filepath, 'bcclm')=0) and (FIND(filepath, 'covid')=0) and (FIND(filepath, 'prj')=0) and (FIND(filepath, 'west')=0) and (FIND(filepath, 'tsv')=0) and (FIND(filepath, 'octv')=0) and (FIND(filepath, 'wcauto')=0) and (FIND(filepath, 'sept2017')=0) and (FIND(filepath, 'novtst2017')=0); NOTE: The data set WORK.SASFILES2 has 61257 observations and 14 variables. NOTE: Compressing data set WORK.SASFILES2 decreased size by 58.28 percent. Compressed is 68 pages; un-compressed would require 163 pages. NOTE: DATA statement used (Total process time): real time 3.32 seconds cpu time 3.30 seconds 77 78 proc sql; 79 create table sasfile as 80 select owner, 81 group, 82 permissions, 83 cfname, 84 fname, 85 cr_dt, 86 cr_dt2, 87 create_date, 88 create_date2, 89 create_time, 90 sum(filesize) format = SIZEKMG6.2 as totalfsize 91 92 from sasfiles2 93 group by fname; NOTE: The query requires remerging summary statistics back with the original data. NOTE: Compressing data set WORK.SASFILE decreased size by 29.82 percent. Compressed is 40 pages; un-compressed would require 57 pages. NOTE: Table WORK.SASFILE created, with 61257 rows and 11 columns. 94 quit; NOTE: PROCEDURE SQL used (Total process time): real time 1.78 seconds cpu time 1.81 seconds 95 96 data sasfile; 97 rownum = _n_; 98 set sasfile (firstobs=1 obs=200); 99 run; NOTE: There were 200 observations read from the data set WORK.SASFILE. NOTE: The data set WORK.SASFILE has 200 observations and 12 variables. NOTE: Compressing data set WORK.SASFILE increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): 4 The SAS System 14:12 Thursday, October 31, 2024 real time 0.02 seconds cpu time 0.03 seconds 100 101 102 data want ; 103 length fvar $1000; 104 set sasfile; 105 fvar = cat("find /dwh_actuariat/sasdata/ -iname ",' "',strip(cfname),'"'," -newermt ",strip(cr_dt)," ! "," -newermt 105 ! ",strip(cr_dt2), " 2>&1"); 106 infile dummy pipe filevar=fvar dsd LRECL=32000 TRUNCOVER end=done; 107 do until (done); 108 input response $400.; 109 output; 110 end; 111 run; NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.idxpolicyseq.000109f0.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 5 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.dpf.000109f0.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2001.hbxpolicyseq.000109f0.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.idxpolicyseq.00010a0e.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.hbxpolicyseq.00010a0e.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2002.dpf.00010a0e.6.1.spds9" -newermt 2016-07-19 ! 6 The SAS System 14:12 Thursday, October 31, 2024 -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.hbxpolicyseq.00010a2c.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.idxpolicyseq.00010a2c.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2003.dpf.00010a2c.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.hbxpolicyseq.00010a4a.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: 7 The SAS System 14:12 Thursday, October 31, 2024 Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.idxpolicyseq.00010a4a.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2004.dpf.00010a4a.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 8 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.idxpolicyseq.00010a68.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.hbxpolicyseq.00010a68.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2005.dpf.00010a68.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.hbxpolicyseq.00010a86.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: 9 The SAS System 14:12 Thursday, October 31, 2024 Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.idxpolicyseq.00010a86.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2006.dpf.00010a86.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 10 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.idxpolicyseq.00010aa4.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.hbxpolicyseq.00010aa4.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.3.1.spds9" -newermt 2016-07-19 ! 11 The SAS System 14:12 Thursday, October 31, 2024 -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2007.dpf.00010aa4.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.idxpolicyseq.00010ac2.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.hbxpolicyseq.00010ac2.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: 12 The SAS System 14:12 Thursday, October 31, 2024 Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2008.dpf.00010ac2.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.12.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 13 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.11.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.hbxpolicyseq.00010ae0.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.idxpolicyseq.00010ae0.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2009.dpf.00010ae0.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.hbxpolicyseq.000109ef.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.14.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: 14 The SAS System 14:12 Thursday, October 31, 2024 Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.11.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.idxpolicyseq.000109ef.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.12.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 15 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.15.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2010.dpf.000109ef.13.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.12.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.11.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.0.1.spds9" -newermt 2016-07-19 ! 16 The SAS System 14:12 Thursday, October 31, 2024 -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.idxpolicyseq.00010a0d.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.hbxpolicyseq.00010a0d.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2011.dpf.00010a0d.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: 17 The SAS System 14:12 Thursday, October 31, 2024 Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.4.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.hbxpolicyseq.00010a2b.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.11.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.12.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.13.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 18 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.dpf.00010a2b.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2012.idxpolicyseq.00010a2b.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.idxpolicyseq.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.12.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.1.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.12.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.11.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.9.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: 19 The SAS System 14:12 Thursday, October 31, 2024 Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.3.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.mdf.0.0.0.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.5.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.idxpolicyseq.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.10.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.hbxpolicyseq.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.13.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.hbxpolicyseq.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.7.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" 20 The SAS System 14:12 Thursday, October 31, 2024 NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.13.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.2.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.6.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.8.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: The infile DUMMY is: Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.0.1.spds9" -newermt 2016-07-19 ! -newermt 2016-07-20 2>&1" NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. 21 The SAS System 14:12 Thursday, October 31, 2024 NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. 22 The SAS System 14:12 Thursday, October 31, 2024 The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. 23 The SAS System 14:12 Thursday, October 31, 2024 The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. 24 The SAS System 14:12 Thursday, October 31, 2024 NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. 25 The SAS System 14:12 Thursday, October 31, 2024 The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. 26 The SAS System 14:12 Thursday, October 31, 2024 The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. 27 The SAS System 14:12 Thursday, October 31, 2024 NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. 28 The SAS System 14:12 Thursday, October 31, 2024 The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 29 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. 29 The SAS System 14:12 Thursday, October 31, 2024 The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 73. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 89. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 81. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. 30 The SAS System 14:12 Thursday, October 31, 2024 NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: 30 records were read from the infile DUMMY. The minimum record length was 80. The maximum record length was 111. NOTE: There were 188 observations read from the data set WORK.SASFILE. NOTE: The data set WORK.WANT has 5449 observations and 13 variables. NOTE: Compressing data set WORK.WANT decreased size by 50.00 percent. Compressed is 7 pages; un-compressed would require 14 pages. NOTE: DATA statement used (Total process time): real time 19:02.92 cpu time 0.32 seconds 112 113 data dest1.sasfiles (drop=response); 114 retain owner group permissions; 115 length path $400; 116 set want; 117 path=substr(response,1,length(response)-length(cfname)-1); 118 run; NOTE: There were 5449 observations read from the data set WORK.WANT. NOTE: The data set DEST1.SASFILES has 5449 observations and 13 variables. NOTE: Compressing data set DEST1.SASFILES decreased size by 50.00 percent. Compressed is 7 pages; un-compressed would require 14 pages. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 119 120 121 122 123 124 125 126 127 128 129 %LET _CLIENTTASKLABEL=; 130 %LET _CLIENTPROCESSFLOWNAME=; 131 %LET _CLIENTPROJECTPATH=; 132 %LET _CLIENTPROJECTPATHHOST=; 133 %LET _CLIENTPROJECTNAME=; 134 %LET _SASPROGRAMFILE=; 135 %LET _SASPROGRAMFILEHOST=; 136 137 ;*';*";*/;quit;run; 138 ODS _ALL_ CLOSE; 139 140 141 QUIT; RUN; 142 ... View more

I am running the code outside of the macro and will provide you the log latter during the day depending on the duration of the execution. I have limitted it to 200 observations ... View more

I am not sure to understand. How to run the posted data step only and post the log ... View more

Good Morning Mr Bremser, I will test it this morning and I will let you know if it works well. Could you please explain me the difference between 2>1&1 and 2>/dev/null ... View more