Hi Chris,

I am a newbie to sas. I am assigned a task to automate some manual SAS processes. At first my plan is to write a java application to do the job because java is my strength. An Java application always running. Every hour the app is going to find if there are some new files copied from a remote server. If new files found, some .sas scripts will be called based on the file path and name to parse the file and analyze the file, and create a report.

I need to pass the file path and name as a parameter dynamically to the dynamically selected .sas scripts during the above process. At first I think it is simple because I just call the scripts by using command

"sas -sysparm 'A B C' sas_script.sas"

But after I talked with our SAS server administrator, I am told that I cannot use the above command anymore because we are currently using Client-Server version of SAS. The above command is not available anymore. We are using EG 4.3 as SAS client.

After search the web, I found only your blog and answers shine some light on my task. I definitely need to call the sas_scripts.sas with parameter passing.

Can you give me some help (.net or VBA is OK, what I really need is passing the parameter to the sas scripts)? you help is really appreciated! I have read your answer on the following post:

https://communities.sas.com/thread/4986

Thank you very much!

Davy