I just have my SAS client setup and combined the above code with my brief business logic. It works perfectly! Thank you soooooo much Ahmed!!!!!!!!!!!! ... View more

Thank you so much Ahmed! I'm going to try modify my code use your code right now! ... View more

Thank you very much Ahmed! I spent some time on SAS and write a integration sas script. Can you help me to take a look? I think I may have errors in the folder recursive searching for the subfolders and files. Thank you very much for your help! Davy intervalForFileValidation = 1; /*** in hours ***/ currentDate = Today(); currentYear = Year(currentDate); currentYearIn2Digits = substr(currentYear,3,2); endyearIn2Digits = currentYearIn2Digits + 1; currentSubmissionPeriod = "" + currentYearIn2Digits + "" + endyearIn2Digits; /** root for project: c:\SAS\data\users\DDM\OCCI\OCCI_AuditYYYY ****/ constantPath = "c:\SAS\data\users\DDM\OCCI\OCCI_Audit"; %Let mypath = cats(of constantPath currentSubmissionPeriod); rawDataFilePath = &mypath.\Data\Rawdata data rawDataDir;   length filename dir fullpath $256;   dir = "&dataFilePath";   rc = filename("readdir","&rawDataFilePath");   did = dopen("readdir");   memcount = dnum(did);   /***** 1. Scan the given file system of rawDataFilePath folder, subfolder and files **************************************************/   do i = 1 to memcount;   filename = dread(did,i);   fullpath = trim(dir) !! "\" !! filename;   fid=fopen("readdir");   fileCreateDate=finfo(fid,"Create Time");     close=fclose(fid);   timePassed = (Today() - fileCreateDate)/InHours();   /***** 2. If the file is a TXT one and if it has not been validated before (file create date < 1 hour), populate it *********/   do while(timePassed > intervalForFileValidation and index(filename,"TXT") > 1);   if(index(filename,"AIP") > 1) then   %Let mvType   = AIP;   if(index(filename,"AMB") > 1) then   %Let mvType   = AMB;   if(index(filename,"AMH") > 1) then   %Let mvType   = AMH;   if(index(filename,"CCC") > 1) then   %Let mvType   = CCC;   if(index(filename,"RHB") > 1) then   %Let mvType   = RHB;   if(index(filename,"CAC") > 1) then   %Let mvType   = CAC;   %Let mvMileStone= YE;   %LET OCDM = Yes;   %Let filename = &fullpath;   %Let root = &mypath;   %INCLUDE "&root.\Program\Shared\Initiate.sas";   ODS path RESET;   %INCLUDE "&publicpath\Import.sas";   %INCLUDE "&publicpath\Match.sas";   %INCLUDE "&publicpath\Audit.sas";   %INCLUDE "&publicpath\Export.sas";   OPTIONS MPrint NoSymbolGen NoXWait NoxSync;   %GetSettings(0);   %GoAuditing();   ODS path RESET;   LibName metdata Clear;   LibName appdata  Clear;   LibName result Clear;   LibName keydata  Clear;   end;   end; run; rc=dclose(did); drop rc fid did memcount i; run; ... View more

They are very useful and helpful to me! Thank you very much Ahmed! David ... View more

Thank you very much Ahmed. I selected java first because My strength is Java and I though I could use the command line command sas -sysparm 'file_path_and_name' sas_script.sas to run the SAS scripts. The above links are all about the job scheduling. I read first one and the 3rd one before, and I will read the rest of them.  Is it easy to use SAS scripts to do the file system scan to find new files, to compare the time stamps of the file, to create a bunch of sub folders and to copy files? Thanks! David ... View more

Hi Ahmed, Yes we are using EG 4.5 as client. The current processes is like that: there are file copied from a remote file server to SAS server continuously. Periodically (half hour, 1 hour) a user is coming to check if there are any new files copied by using EG. If there is a new one, the user is going to find correct sas script based on the file name. Then he/she will open the selected sas scripts, modify the file name and path to the real path, file name, submission fiscal year. Then he/she will saved the script, and run the script in EG. This is tiresome because there are so many files. So I was assigned to automate this processes. I will have a Java application always running to check if there is a new file. If there is a new file, the app will select the right scripts based on the file name. Instead of harcoded file path, name and fiscal year, I will change these 3 into a dynamic parameter in the script. Then I will call the script by using a native command call in Java: sas -sysparm 'file_path_and_name' sas_script.sas This is my plan. But EG does not have sas.exe available for the Java app to call. I want to know what else I can do? Thanks a lot! David ... View more

Hi Ahmed, I cannot use sas.exe because I was told we do not have this in our client. At first I think the app will be very simple because I just need to do a native calls like you said sas -sysparm 'file_path_and_name' sas_script.sas But I am told I cannot use above call because we do not have the above command available. How can I have the above command available in the SAS client? I searched the web, EG, SAS Connect, and so no do not have this command available. Is the SASFoundation a client I need to install to make the sas.exe available? where and how I can get it if the answer is 'yes"? Thanks a lot Ahmed. David ... View more

Thanks a lot Ahmed! At first I planed to installed the Java App on the SAS Server which is running on a Windows 2003 server. But after I talked with the SAS Server Admin, I was told I can only run the java App on a remote client workstation which is a Windows OS too. The .sas scripts and files used by the scripts are in the server too but are all mapped to the client workstation as a network driver. Currently, a user will find the new file and select a script based on the new file name, manually change the path and file name to reflect the real path and file name to be parsed, save the script, and then run the script by EG 4.5. What I need to do is call different sas scripts based on different files need to be parsed by the .sas scripts. For example, if the file name is abc.txt, I will call abc_script.sas to do the parse. In abc_script.sas, I need to change the file path and name in the "abc_script.sas"  to ..\..\abc.txt so that the script to parse the correct file, and then create a report called "abc,xls". So file name and path must be passed to the script correctly. How Can I do that? Thanks a lot! David ... View more