call python script in SAS EG

[Moe_Issa]

we have a python script that should request a data from API call . my question can SAS EG trigger the paython script ? 

or can sas connect to API call and pull a data from it ?

Thanks

[michelle_delaurentis_sas_com · Accepted solution]

You can use the X command to start a program outside of SAS. 

http://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#p11ba12uypvfazn...

If your EG is using an object spawner then you will need to enable all SAS processes started with the object spawner the ability to use X commands by adding the option -ALLOWXCMD to the object spawner command. THIS CAN BE DANGEROUS. There are security risks associated with allowing system commands to be executed from a client application. Clients can use host commands to perform potentially harmful operations such as file deletion.

Alternatively, you could create .sas files with the SAS code from the EG project and use them in a batch or cron job. Something like

sas -sysin sasJobsBeforePython.sas

run python

sas -sysin sasJobsAfterPython.sas 

And per @FriedEgg, there are other ways to integrate Python and R into your SAS process:

Check out this open source offering from SAS.

https://github.com/sassoftware/enlighten-integration

[FriedEgg]

Check out this open source offering from SAS.

https://github.com/sassoftware/enlighten-integration