Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- Programming
- /
- Enterprise Guide
- /
- Re: how to capture the linux output to a sas dataset
Options
- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted Wednesday
(453 views)
Hello,
I am using a first linux command to get all the files in the folder /../sasdata/ and recursively and it works fine.
Then I use a command like this one below, to get all possible path where the files is hosted, but when it takes to much time, the response value is not obtained
%macro doit(dir=);
libname dest1 base "/..._Data_Retention/data";
/*proc printto log='/.../Temp/Alain/logfiles/sasfiles_log.txt' new;*/
/*run;*/
filename oscmd1 pipe "ls -Rla --time-style=long-iso ~ &dir. | awk '{printf ""%-10s %-10s %10s %20s %12s %s %s\n"", $1, $3, $4, $5, $6, $7, substr($0,index($0,""/""),500)}'";
Data dest1.sasfiles1 ;
format fname $50. ;
infile oscmd1 dsd LRECL=32000 TRUNCOVER firstobs=2;
input
permissions $ 1-12
owner $ 12-24
group $ 26-35
fsize $ 36-54
cr_dt $ 55-67
time $ 68-74
filepath $ 75-500
;
run;
data sasfiles2;
format create_date create_date2 yymmdd10. create_time tod5.;
length cfname $100. fname $50.;
set dest1.sasfiles1;
where owner eq '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 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 ;
filesize=input(fsize,8.);
fname = scan(scan(filepath,-1,''),1,'.');
cfname=scan(filepath,-1,'');
create_date=input(cr_dt,yymmdd10.);
create_date2=intnx('day',create_date,1);
create_time=input(time,time.);
cr_dt2=put(create_date2,yymmdd10.);
run;
proc sql;
create table sasfile as
select owner,
group,
permissions,
cfname,
fname,
cr_dt,
cr_dt2,
create_date,
create_date2,
create_time,
sum(filesize) format = SIZEKMG6.2 as totalfsize
from sasfiles2
group by fname;
quit;
data sasfile;
rownum = _n_;
set sasfile /*(firstobs=1 obs=2)*/;
run;
data want ;
length fvar $1000;
set sasfile;
fvar = cat("find /dwh_actuariat/sasdata/ -iname ",' "',strip(cfname),'"'," -newermt ",strip(cr_dt)," ! "," -newermt ",strip(cr_dt2), " 2>/dev/null");
run;
/****** Capturing the linux output to a sas data set *****/
data sasfiles;
set want;
infile dummy pipe filevar=fvar dsd LRECL=32000 TRUNCOVER end=done;
do until (done);
input response $400.;
output;
end;
run;
%exit: %mend doit;
%doit(dir=/.../sasdata/);
Pipe command="find /dwh_actuariat/sasdata/ -iname "be_auto_prmaou2013.dpf.00010a49.0.1.spds9" -newermt 2016-07-19 !
-newermt 2016-07-20 2>/dev/null"
NOTE: 1 record was read from the infile DUMMY.
The minimum record length was 80.
21 The SAS System 20:38 Wednesday, October 30, 2024
The maximum record length was 80.
NOTE: 1 record was read from the infile DUMMY.
The minimum record length was 89.
The maximum record length was 89.
NOTE: 1 record was read from the infile DUMMY.
The minimum record length was 80.
The maximum record length was 80.
How can we solve that issue ?
15 REPLIES 15
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Save the one line that the your Unix command returned. Or just print it to the log.
data _null_;
infile oscmd1 ;
input ;
put _infile_;
run;Then look at it and figure out what went wrong.
After you fix that so it returns more information then fix your SAS code.
Why did you tell INFILE to use the DSD option to parse the line at commas and then tell the INPUT statement to read fixed positions on the line? Which style line (or lines) did your program produce.
You could also just skip using the Unix command and use the available SAS functions. Take a look at: https://github.com/sasutils/macros/blob/master/dirtree.sas
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Instead of
2>/dev/null
use
2>&1so you also catch error messages in response.
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
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
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
"2>" means "send the output from output stream 2 somewhere else". Output stream 2 is always stderr, the standard error output.
"&1" is the "address" of output stream 1, which is stdout (standard output), where programs send all their normal output.
"/dev/null" is a virtual file in the UNIX filesystem. Anything sent to it is discarded, and nothing can be read from it (if you use it as input to a program, it will immediately receive an end-of-file).
So, "2>&1" means "please reroute anything sent to stderr to stdout". Since a FILENAME PIPE will only read from stdout, this is the way to catch error or diagnostic messages. Your original code sent all diagnostics to the "bit bucket".
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This log is NOT from your code, but from some macro with issues.
Run the posted DATA step only, and post the log from that.
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I am not sure to understand. How to run the posted data step only and post the log
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Remove the %MACRO and %MEND statement. Leave the statements in between.
Remove the call to the macro they defined.
At the top add a %LET statement to assign a value to the DIR macro variable.
Then run the code.
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Just select the code in the program editor and hit Submit.
Note that, when developing a macro, you must (MUST) start with working non-macro code before you can make it dynamic.
Note that, when developing a macro, you must (MUST) start with working non-macro code before you can make it dynamic.
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I see no problem here. All your steps ran through without WARNINGs or ERRORs, and you get a dataset with 5449 observations.
There are WARNINGs because of strings in the first FILENAME that trigger the macro processor, and there's a NOTE for an uninitialized variable which is never used anyway in that step. Remove the FORMAT statement that causes it, and add a LENGTH statement in the step where the variable is actually set.
Your log is not from the DATA step you posted at the beginning, BTW. That code does not appear anywhere in the log.
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I am having a hard time trying to see what purpose this code might be serving.
Can you explain what is the goal of this program?
For example why are you running the LS command on both the directory pass in the DIR macro variable and also the current users home directory?
Why are you generating a lot (a lot a lot) of FIND commands after you just generated an LS command? What is the FIND command providing that the LS command did not? What is the LS command providing that the FIND command could not?
Barite | Level 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
SAS Innovate 2025: Save the Date
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
SAS Enterprise Guide vs. SAS Studio
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
SAS Training: Just a Click Away
Ready to level-up your skills? Choose your own adventure.
Discussion stats
-
15 replies
-
Wednesday
-
454 views
-
0 likes
-
3 in conversation
-
