DATA Step, Macro, Functions and more

Running SAS EG process through Visual Studio (C#) which takes Excel file dynamically

Reply
Occasional Contributor
Posts: 6

Running SAS EG process through Visual Studio (C#) which takes Excel file dynamically

Hello All,

I have created a ETL process in SAS Enterprise Guide. That ETL process takes excel file as an input and further does the cleaning operation. I want to automate this process through a Desktop application built in Visual studio(C#). User will enter a excel file for processing each time he runs the desktop application. Is their any way in which I can run the SAS EG process in Visual Studio which will take the excel file path given as input by the user and further run itself.

I have searched online and found some articles which describes running of SAS EG  workflow through C#. However here along with running the EG process I need to give " NEW " excel file as input each time my process of EG would run though C#.

Please help me out if anyone has solution to this problem.

Thanks in advance.

Best Regards,

Tejas

Ask a Question
Discussion stats
  • 0 replies
  • 189 views
  • 0 likes
  • 1 in conversation