A*******s 发帖数: 3942 | 1 Try to run multiple times a sas file in batch modes under windows 7 OS. Most
succeed but some tasks fail. The error msg in log file says "unable to read
the file". Is there any limit about batch modes I dont know? |
s******r 发帖数: 1524 | 2 1. SAS is crazy. It happens from time to time. There are thousands of
hotfixes.
2. If your code only take seconds, stupid sas may not release first lock
while it runs second loop.
Most
read
【在 A*******s 的大作中提到】 : Try to run multiple times a sas file in batch modes under windows 7 OS. Most : succeed but some tasks fail. The error msg in log file says "unable to read : the file". Is there any limit about batch modes I dont know?
|
D******n 发帖数: 2836 | 3 without knowing what ur code does and what u mean by multiple times its real
ly hard to answer ur question. your company still uses windows only?
Most
read
【在 A*******s 的大作中提到】 : Try to run multiple times a sas file in batch modes under windows 7 OS. Most : succeed but some tasks fail. The error msg in log file says "unable to read : the file". Is there any limit about batch modes I dont know?
|
A*******s 发帖数: 3942 | 4 1. I couldn't agree more... when i run computing and I/O intensive programs,
I always find some occasional random errors i cannot explain...
【在 s******r 的大作中提到】 : 1. SAS is crazy. It happens from time to time. There are thousands of : hotfixes. : 2. If your code only take seconds, stupid sas may not release first lock : while it runs second loop. : : Most : read
|
A*******s 发帖数: 3942 | 5 actually i am doing simulation and try to save time by submitting multiple
tasks simultaneously in batch modes. Couldn't understand why some tasks
failed but other didn't . I am wondering whether there may be some
limitations, say the maximum number of processes reading the same file.
i dont have company yet and dont know how to use Unix...
real
【在 D******n 的大作中提到】 : without knowing what ur code does and what u mean by multiple times its real : ly hard to answer ur question. your company still uses windows only? : : Most : read
|
D******n 发帖数: 2836 | 6 there are of course limitations for file access. A lock will be placed on a
file if one program is already reading it. It is not about SAS.
【在 A*******s 的大作中提到】 : actually i am doing simulation and try to save time by submitting multiple : tasks simultaneously in batch modes. Couldn't understand why some tasks : failed but other didn't . I am wondering whether there may be some : limitations, say the maximum number of processes reading the same file. : i dont have company yet and dont know how to use Unix... : : real
|
s*r 发帖数: 2757 | 7 that is not a good idea
【在 A*******s 的大作中提到】 : actually i am doing simulation and try to save time by submitting multiple : tasks simultaneously in batch modes. Couldn't understand why some tasks : failed but other didn't . I am wondering whether there may be some : limitations, say the maximum number of processes reading the same file. : i dont have company yet and dont know how to use Unix... : : real
|
A*******s 发帖数: 3942 | 8 i know i cant edit a file when another programs is reading it. But is it ok
that multiple processes read a file simultaneously?
a
【在 D******n 的大作中提到】 : there are of course limitations for file access. A lock will be placed on a : file if one program is already reading it. It is not about SAS.
|
A*******s 发帖数: 3942 | 9 so how to improve efficiency if i couldn't do multi-thread programming? plz
zkss...
【在 s*r 的大作中提到】 : that is not a good idea
|
s******r 发帖数: 1524 | 10 See following code,
proc sql;
select * from a
inner join b
on ...
;
select * from a
inner join b
on ...
where;
quit;run;
Guess what's the result?
-log Can not find table b***
but result is right.
While I changed to
proc sql;
select * from a
inner join b
on ...
;
quit;run;
proc sql;
select * from a
inner join b
on ...
where;
quit;run;
Everything is fine. No error message.
I would suggest you,
1. Check necessary hotfix
2. try to break your process and not to read one file simultaneously or put
it
【在 A*******s 的大作中提到】 : i know i cant edit a file when another programs is reading it. But is it ok : that multiple processes read a file simultaneously? : : a
|
A*******s 发帖数: 3942 | 11 interesting...
maybe i could try some stupid ways, say duplicate the sas file and assign
each for only one task.
【在 s******r 的大作中提到】 : See following code, : proc sql; : select * from a : inner join b : on ... : ; : select * from a : inner join b : on ... : where;
|