topic Re: Automate a job in Microsoft Integration with SAS

Automate a job

laxmanpai — Fri, 13 Sep 2019 07:23:28 GMT

Hi All,

I have an Excel File with 8 tabs containing data.

Currently I am extracting the data from each tab and converting them to .csv files (8 csv files).

Then I execute the 8 jobs which have these sources as input.

Is it possible to automate this process where on a single click in SAS DI ( Instead of manually creating csv files , getting it done in a single click )

Re: Automate a job

FredrikE — Fri, 13 Sep 2019 07:54:45 GMT

Hi!

If you have "Access to pcfiles" it's not harder than defining a libname 🙂

libname xlfile xlsx '/home/kfen01/exceltest.xlsx';

Will automatically give you two "datasets" in the defined libname.

//Fredrik

Re: Automate a job

laxmanpai — Mon, 16 Sep 2019 06:11:51 GMT

Hi Fredrik,

My issue is the Excel file with 8 tabs (.xlsx) file is in my sharepoint location.

I need to firstly make 8 .csv files (Tab delimited) and copy these to the server location.

I need to archive the files which are already present (.csv) files to a folder with a date.

then I need to move these files to that location.

an then execute the job which will take these (.csv) files as input.

Can u let me know how to do this in SAS DI .

With an example and steps would help me a lot.

Thanks

Re: Automate a job

LinusH — Mon, 16 Sep 2019 13:17:11 GMT

When you say "need", is that an architectural requirement?

I mean, you can make similar archiving by storing the data in e.g. generation SAS datasets.

But I see your pain, Excel files is a least preffered source in data integration.

If your site is licensing Add-in for MS Office you can use Excel to update SAS datasets directly on the server.

Re: Automate a job

laxmanpai — Wed, 18 Sep 2019 08:31:46 GMT

Hi,

Could someone provide me a solution for this in SAS DI as this is a project requirement which would help me