batch file

Reply
Contributor
Posts: 23

batch file

Hello, I want ask you a question about the batch file.

I have Sas on Server, and i want to run the program automatically from PC(not from Server) every half hour.

When i run batch file on server i get   results.

The problem, i don't have an opportunity to run batch file from Server.

What i should do?

Thank you.

Alexey


Attachment
Super User
Posts: 5,260

Re: batch file

Why can't you run on the server? Are you not permitted? If this is the case, you need to resolve this with the administrators.

If you have SAS installed locally, map the necessary drives on the server (if you are permitted), and the run.

Data never sleeps
Contributor
Posts: 23

Re: batch file

We need run the Sas automatically through the SQL SERVER. and SQL SERVERis not on the same  server as SAS.

therefore i check an opportunity tu run the batch file from computer(not server).


Super User
Posts: 5,260

Re: batch file

Please describe in more detail you environment.

You have a SQL Server on one Windows Server.

You have SAS on another Windows Server.

You have have a Windows client with no SAS...?

Your batch SAS program does stuff with SQL Server data, which it's accesses via SAS/ACCESS to OLEDB or ODBC?

You are not allowed to set up batches on the SAS Server? Why?

You don't happen to have a SAS Enterprise Guide client, do you? From this you cold schedule EG projects, which in turn would execute on the SAS server.

Data never sleeps
Super Contributor
Posts: 644

Re: batch file

Assuming you hav SAS Connect

  1. ensure your program on the server runs without problems
  2. create a local sas script that says

rsubmit ;

%Include "\\serverfilelocation\serversasjob.sas" ;

endrsubmit ;

and check it runs.

Then write a local batch job to invoke SAS to run this script

Lastly, schedule your local batch job.

Richard

Contributor
Posts: 23

Re: batch file

I check my file , he is running on server.

can you please explain more about what you write.

I put what you wrote but he told me that he don't know this commands.

rsubmit ;

%Include "\\serverfilelocation\serversasjob.sas" ;

endrsubmit ;

can you please explain me, because i never wrote it before. you can open my file and see. it

Thank you

Contributor
Posts: 23

Re: batch file

i don't have SAS CONNECT. i need to run the process through the Windows.

Ask a Question
Discussion stats
  • 6 replies
  • 322 views
  • 0 likes
  • 3 in conversation